| title | Full-Text Stoplist Properties | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/13/2017 | ||
| ms.prod | sql-server-2014 | ||
| ms.reviewer | |||
| ms.technology | search | ||
| ms.topic | conceptual | ||
| f1_keywords |
|
||
| ms.assetid | 2e907f5b-0cf9-484a-afcf-a4e7f1e2f87f | ||
| author | craigg-msft | ||
| ms.author | craigg | ||
| manager | craigg |
Use this dialog box to add or delete individual stopwords, delete all stopwords for a specific language, or clear the current stoplist. A stopword is a commonly used word that is included in a stoplist. The stopwords in a stoplist are omitted from full-text indexing for tables that use the stoplist. For more information, see Configure and Manage Stopwords and Stoplists for Full-Text Search.
To use SQL Server Management Studio to change stoplist properties
Action
Specifies the action that you want to perform.
Add stopword
Add a commonly used word to the stoplist.
Delete stopword
Delete a stopword from the stoplist.
Delete all stopwords
Delete all the stopwords for a specific language.
Clear stoplist
Clear the stoplist by deleting all the stopwords for all languages.
Stopword
If you selected Add stopword or Delete stopword, enter the stopword in the Stopword field. A new stopword must be unique; that is, not yet in this stoplist for the language that you select.
Full-text language
If you selected Add stopword, Delete stopword, or Delete all stopwords, select the language of the stopword or stopwords from the list box. This lists all the full-text languages that are supported by the server instance.
sys.fulltext_stopwords (Transact-SQL)
sys.fulltext_stoplists (Transact-SQL)
Configure and Manage Stopwords and Stoplists for Full-Text Search
ALTER FULLTEXT STOPLIST (Transact-SQL)
CREATE FULLTEXT STOPLIST (Transact-SQL)
DROP FULLTEXT STOPLIST (Transact-SQL)