I've searched this site and the internet in general and can't find any information which answers my question, so I thought I'd post it here. I have Full Text search operating on a database in SQL server 2008 and I have 2 questions relating to the index and stoplists:
- Do stoplist stopwords prevent the tokenised word from actually being inserted into the index or do they just filter results returned to queries?
- Can patterns be used in a stoplist to filter, for example, all numbers?
The reason I ask, is we have lots of documents with tables of numbers which we don't really want indexed or searched for but when I examine our FTS index, over half of the 4 million rows are numbers such as 1, 76.01, -0.1036886733 etc.