FREETEXTTABLE not finding short words
Posted by Anders Vindberg
in Lunarmedia Blog
on the 23 Jan. 2008 (9,062 views).
When using Full-Text Indexing in MS-Sql you may find that search results for "the" or "saw" doesn't return any results. To resolve the issue, go to "properties" of the Full-Text index select "Columns" and change the "Language for Word Breaker" setting to "Neutral". If "English" is selected, then common English words are not indexed.