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'