Search code examples
c#.netsql-serverfull-text-searchstop-words

How to get a list of StopWords used in my FullText Catalog?

Is there a way to get the StopWord list that my SQL Server 2008 FullText Catalog is using? And use it, in my C# codebehind?

I want to use it in a ASP.NET page that I use to search terms and highlight them.

The search page and the highlight are already working fine, but I want to improve the highlight. I don't want to highlight a word that is on my StopWord list.

Solution

  • In sql server management studio if you ask the properties from the fulltext index you can see which stoplist it uses. See here.

    You can then use the system views sys.fulltext_stoplists and sys.fulltext_stopwords to get the list of stopwords.