Tag Archives: full text search

Full-Text Search – Thesaurus

I would hope that most of us have used a thesaurus at some point in our careers. These allow us to substitute words for one another, providing for richer and more interesting communication. Full-text search in SQL Server includes a … Continue reading

Posted in Blog | Tagged , ,

Full-Text Search – Word Breakers and Stemmers

There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to queries. Full-text Search is a little complex, and as I’ve been working with the system in an effort to learn … Continue reading

Posted in Blog | Tagged , ,

Full-Text Search – Stoplists in SQL Server

Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text formats stored in SQL Server. This is a one of a series of posts that looks at different facets of … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Building a Full Text Index

I hadn’t used full-text indexing in production throughout my career. We hadn’t had the need in the applications I worked on, all of them depending on LIKE searches in specific, normalized data. However I have always been interested in it … Continue reading

Posted in Blog | Tagged , , , | 3 Comments