Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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