Knowledgebase
Noise words, stop words and stop lists
Posted by Polina Fedorova on 25 April 2013 09:54

The Cinegy Archive search functionality uses Microsoft SQL Server search engine for the search query processing. To prevent a full-text index from becoming bloated, Microsoft SQL Server has a mechanism that discards commonly occurring words that do not help the search. These words are called noise words or stop words.  When such a word is detected in a search query, it becomes ignored so in some cases your search results might return the results that do not contain certain nodes. While this might not be expected by the operator, it is the correct behavior and should be considered when creating your search queries.

Please, refer to the following MSDN articles regarding the noise words processing for different Microsoft SQL Server versions:

SQL Server 2005          - http://msdn.microsoft.com/en-us/library/ms142551(v=sql.90).aspx

SQL Server 2008          - http://msdn.microsoft.com/en-us/library/ms142551(v=sql.100).aspx

SQL Server 2008 R2     - http://msdn.microsoft.com/en-us/library/ms142551(v=sql.105).aspx

SQL Server 2012          - http://msdn.microsoft.com/en-us/library/ms142551(v=sql.110).aspx

SQL Server 2014          - https://msdn.microsoft.com/en-us/library/ms142551(v=sql.120).aspx 

SQL Server 2016          - https://msdn.microsoft.com/en-us/library/ms142551(v=sql.130).aspx 

(0 vote(s))
Helpful
Not helpful

Comments (0)