SQL Server Full-Text Search (FTS) Hit-Highlighting


So you're using FTS (Full-Text Search) in SQL Server to index and search thousands if not millions of documents. But how are you visualizing the search results for your users? Are you showing them what they want to see? Users clearly want applications that look like this:

Full-Text Search in SQL Server lets users and applications run full-text queries against character-based data in SQL Server tables, but lacks the ability to analyze the results in respect to the query, such as generating hit-highlighted snippets or extracting document properties.

Introducing ThinkHighlight for SQL Server, a robust plugin component that allows users a much better understanding of the results in relation to their query.

Key Features

  • Hit-highlighting of query terms in the results
  • Snippet generation with several summarization strategies
  • Works directly on both text and binary columns (most IFilters are supported)
  • Multilingual support in the document/index/query level
  • Linked highlighting, allows styling per query term/group
  • Document Properties extraction

More Information

Supported Platforms

Microsoft SQL Server 2005/2008/2008 R2/2012/2014/2016/2017/2019/2022



License (one-time fee) Price Buy Now
Trial License - Try Before You Buy
Allows a single instance installation for 30 days evaluation
Free Trial
Developer License
Allows a single instance installation for development purposes
39 USD PayPal
Standard License
Allows a single instance installation
390 USD PayPal
Enterprise License
Allows multiple instances installation
1390 USD PayPal
OEM License
Allows bundling as part of a complete software product
Contact us


"ThinkHighlight for SQL Server has greatly enhanced our Full-Text Search experience, we receive a very good feedback from our customers."
Vincent Mercelot, Project Director at Kantar Media

Featured On