I'm trying to replicate what SQL Server 2008 is doing when generating full-text indexes, but I'm having a hard time finding a list of which characters SQL Server 2008 considers to be word breakers.

Is there a list out there specifying which characters SQL Server 2008 will break words on for full-text indexes for English?


The per language noise list (also referred to as stop list) and thesaurus files are in the MSSQL/FTData/ folder. The noise files are plain text, the thesaurus XML, so both can be inspected or changed easily.

Configuring Full-Text Linguistic Components in BOL has the details.

  • I'm looking for the criteria where SQL server breaks up the words.. i.e. "Hello World" gets broken into two due to the space – John Dec 9 '11 at 19:05
  • @John - its in the link he posted....maybe read it first. – JNK Dec 9 '11 at 19:30
  • @JNK: where does it list out the word breakers? – John Dec 9 '11 at 19:36
  • took me 2 clicks to get there from his link – JNK Dec 9 '11 at 19:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.