As i have posted a tip to create a custom stoplist for fulltext indexes in SQL Server, http://beyondrelational.com/justlearned/posts/545/custom-stoplist-for-fulltext-index-in-sql-server.aspx. Here i am going to submit a tip as how can we add or remove stopwords/noisewords in that stoplists. Below are queries are used to add and remove stopwords in/from stoplists accordingly.

-- Adding "stop" word as a stopword to stoplist
ALTER FULLTEXT STOPLIST SL3
ADD 'stop' LANGUAGE 'English'
GO

-- Removing "stop" word from stoplist
ALTER FULLTEXT STOPLIST SL3
DROP 'stop' LANGUAGE 'English'
GO

Published under: SQL Server Tips ·  ·  ·  ·