One of our table has full text catalog on it. It contains some data in a language other than English which makes some words such as "are", "or" useful. There is no stop list defined but these words are considered as system stop lists therefore won't appear in the index keywords. How can I remove these words from the system stop list and add them to the indexed keywords?

Thank you.

  • You can use this: ALTER FULLTEXT STOPLIST CombinedFunctionWordList DROP 'en' LANGUAGE 'French'; I don't remember for certain but I'm not sure you can change the system stoplist. Nov 6, 2014 at 12:40
  • You have to have a stoplist named CombinedFunctionWordList in order to drop a word off it. There is no stop list in my db. Nov 6, 2014 at 12:52
  • Create a new stoplist from the system stoplist msdn.microsoft.com/en-us/library/cc280405.aspx then set it as the default. Then remove the words you want gone. Here is the link for managing stoplists in general. msdn.microsoft.com/en-us/library/ms142551.aspx Nov 6, 2014 at 14:30

1 Answer 1


You can turn off the system stoplist and create your own, eg



ALTER FULLTEXT STOPLIST myCustomStoplist ADD 'someWord' LANGUAGE 'English';

ALTER FULLTEXT INDEX ON dbo.yourTable SET STOPLIST = myCustomStoplist

If you create an empty stoplist, it means all words are considered, or to put it another way, words that were previously considered noise words are no longer. You will need to add some words to avoid index bloat, and as mentioned in my other post, if you really leave the word 'a' out of your stoplist, searches for 'a' will return most of your documents, somewhat defeating the object of full-text index ( ie tightly scoped searches ).

  • But wBob if I issue ALTER FULLTEXT STOPLIST myCustomStoplist ADD 'someWord' LANGUAGE 'English'; it will add.. I want to REMOVE that word from the list. In other words I want that word to be indexed. Thanks. Nov 5, 2014 at 14:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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