Abstract
All versions of SQL Server that have supported full-text search have included an option to ignore certain words that are considered unimportant for search purposes. In SQL Server 2005 and earlier, this option was known as the noise word list. Noise word lists were language-specific text files stored in the file system. In SQL Server 2008, noise word lists have been replaced by stoplists, which are likewise composed of words, known as stopwords, that are unimportant for search. Unlike noise word lists, stoplists are stored in the database rather than in the file system. SQL Server 2008 also provides T-SQL language improvements designed to make stoplists more flexible than noise word lists and to facilitate and ease their management.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Michael Coles and Hilary Cotter
About this chapter
Cite this chapter
(2009). Stoplists. In: Pro Full-Text Search in SQL Server 2008. Apress. https://doi.org/10.1007/978-1-4302-1595-0_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1595-0_7
Publisher Name: Apress
Print ISBN: 978-1-4302-1594-3
Online ISBN: 978-1-4302-1595-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books