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

c# .net sql-server full-text-search stop-words
Guilherme de Jesus Santos picture Guilherme de Jesus Santos · Feb 11, 2011 · Viewed 13.9k times · Source

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.

Answer

jasttim picture jasttim · Nov 1, 2017

SELECT * FROM sys.fulltext_stopwords |
SELECT * FROM sys.fulltext_system_stopwords

you can filter which stoplist you return by including the language code in a where clause

e.g. SELECT * FROM sys.fulltext_system_stopwords WHERE language_id=1033

(id 1033 corresponds to syslanguages 'English')

Alternatively, these can be found under the 'Full-Text Stoplists' category within the 'Storage' group against a standard SQL database

Related questions

ElasticSearch vs SQL Full Text Search

I want to use full text search in my project... Can anyone explain me, what is the difference between ElasticSearch and SQL Full Text Search Or why SQL Full Text Search is better (worse) than elastic? documentations, presentations, schema...

Read More
C# Equivalent of SQL Server DataTypes

For the following SQL Server datatypes, what would be the corresponding datatype in C#? Exact Numerics bigint numeric bit smallint decimal smallmoney int tinyint money Approximate Numerics float real Date and Time date datetimeoffset datetime2 smalldatetime datetime time Character Strings …

Read More
What is the equivalent of bigint in C#?

What am I supposed to use when handling a value in C#, which is bigint for an SQL Server database?

Read More