SQL Server Noise Words
December 3rd, 2009 Posted in SQL
If you do FULLTEXT searches in SQL Server, you are very aware of the limitations of noise words. Noise words are basically words that get dropped from the query. They are like common articles like ‘a’, ‘an’, etc. These words are contained in the file c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\noiseENU.txt (path may vary based on your directory setup). Here is the full list if you are looking to see if one of your terms is getting dropped
| about 1 after 2 all also 3 an 4 and 5 another 6 any 7 are 8 as 9 at 0 be $ because been before being between both but by came can |
come could did do does each else for from get got has had he have her here him himself his how if in into is it its just like make many me might |
more most much must my never no now of on only or other our out over re said same see should since so some still such take than that the their them then |
there these they this those through to too under up use very want was way we well were what when where which while who will with would you your |
