---
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: 
  - "sql12.swb.fulltextsearch.ftstoplistproperties.general.f1"
  - "sql12.swb.fulltextsearch.ftstoplistproperties.schedule.f1"
ms.assetid: 2e907f5b-0cf9-484a-afcf-a4e7f1e2f87f
author: craigg-msft
ms.author: craigg
manager: craigg
---
# Full-Text Stoplist Properties
  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](../relational-databases/search/full-text-search.md).  
  
 **To use SQL Server Management Studio to change stoplist properties**  
  
-   [Configure and Manage Stopwords and Stoplists for Full-Text Search](../relational-databases/search/full-text-search.md)  
  
## Options  
 **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.  
  
## See Also  
 [sys.fulltext_stopwords (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-fulltext-stopwords-transact-sql)   
 [sys.fulltext_stoplists (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-fulltext-stoplists-transact-sql)   
 [Configure and Manage Stopwords and Stoplists for Full-Text Search](../relational-databases/search/full-text-search.md)   
 [ALTER FULLTEXT STOPLIST (Transact-SQL)](/sql/t-sql/statements/alter-fulltext-stoplist-transact-sql)   
 [CREATE FULLTEXT STOPLIST (Transact-SQL)](/sql/t-sql/statements/create-fulltext-stoplist-transact-sql)   
 [DROP FULLTEXT STOPLIST (Transact-SQL)](/sql/t-sql/statements/drop-fulltext-stoplist-transact-sql)