Press "Enter" to skip to content

Full-Text Word Breaking in SQL Server

Greg Low shows off a bit of functionality in SQL Server’s full-text search capability:

One of my favorite DMFs that most people seem to be completely unaware of, is sys.dm_fts_parser(). It allows you to see the result of the word-breaking occurring within full text search. If you execute the query:

Click through for an example and what the output looks like.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.