Another interesting project which I would need to look at later on.
Some interesting formula found to search for text in SQL DB:
http://mkramar.blogspot.com/2011/05/hit-highlight-for-sqlserver-full-text_5118.html
There’s an analysis on the query:
https://sqlperformance.com/2012/09/t-sql-queries/hit-highlighting-in-full-text-search