.NET Zone is brought to you in partnership with:

I’ve been a Windows developer since 3.0 and caught the Visual Basic wave early with v1. I’ve released a “production” application in every version of VB since then (except VB for DOS). Focusing on enterprise, line-of-business development I’ve built Call Center Applications, Mortgage finance systems, Customer Relationship Management tools and more recently I’ve been in the Litigation Support/Electronic Data Discovery/Electronically Stored Information space. Greg is a DZone MVB and is not an employee of DZone and has posted 477 posts at DZone. You can read more from them at their website. View Full User Profile

Hit Highlighting and Summarization with SQL Server Full Text Indexing/Searching

  • submit to reddit

 Bob Beauchemin's Blog - Hit Highlighting/Summarization product for SQL Server Full-Text Search

"I've often asked about add-ins for SQL Server Full-Text Search feature. And the most requested feature for FTS has long been some way to accommodate hit highlighting. Recently, I've come across a beta for a product that does just this, along with document summarization formats for display, ThinkHighlight by Interactive Thoughts.

The add-in is implemented as a single SQLCLR assembly that exposes a pair of UDFs, HitHighlightContext and HitHighlight. The first UDF prepares a context. You only have to do this once per query, so this appears to be a nice optimization. The HitHighlight one is used to produce a column of output with summarized text and highlighted hits. You have a choice of three different output summarization strategies: baseline, complete, and top-fragment. Baseline and top-fragment are meant to be used in a manner similar to one that you'd see used in search websites. There's an interactive demo that shows some examples.

The product comes with a ..."

Interactive Thoughts - ThinkHighlight for SQL Server


Indexing and searching documents with Microsoft's SQL Server Full-Text Search is quite easy and effective, yet visualizing the results has always needed a UI boost.

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
More Information


That is something that's always concerned me about SQL Server's Full Text Indexing (which has gotten really awesome in SQL Server 2012), the apparent lack of third party extensions, ISV's pushing it, etc.

This looks very interesting and when doing searching, kind of a must have...

Published at DZone with permission of Greg Duncan, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)