I'm doing some work with SQL Full-Text Search, and I'd forgotten how to display the list of "stopwords" that are currently being ignored when performing a search.
Below is a simple query to get the list of English stopwords on your database. Mine currently includes 154 items, including individual numbers and letters.
What's in your stopwords list?
SELECT ssw.stopword, slg.name
FROM sys.fulltext_system_stopwords AS ssw
JOIN sys.fulltext_languages AS slg ON slg.lcid = ssw.language_id
WHERE name = 'English'
No comments:
Post a Comment