Fulltext search hit-highlighting in combination with a SQL Server 2017

689 Views Asked by At

I want to hightlight the search word (hits) in the search results. I use the fulltext search with e.g. where contains(html, 'formsof(INFLECTIONAL, search word)').

How I get the right hits from the SQL server to highlight them in the frontend?

I could not find an optimal solution for me. I have already tested the following things:

ThinkHighlight for SQL Server

Script from Mike Kramar

Is there a good solution (script, library) for highlighting search hits? Also like a commercial solution.

0

There are 0 best solutions below