SQL Server FTS: possible to get information how/why rows were matched?

Posted by jimmy_keen on Stack Overflow See other posts from Stack Overflow or by jimmy_keen
Published on 2010-05-17T18:14:17Z Indexed on 2010/05/17 20:20 UTC
Read the original article Hit count: 125

Is it possible to get the information why/how given row returned by FTS query was matched (or which substring caused row to match)? For example, consider simpliest table with id and text columns, with FTS index on the later one.

SELECT * FROM Example
WHERE CONTAINS(text, 'FORMSOF(INFLECTIONAL, jump)');

This examplary query could return, say row {1, 'Jumping Jack'}.

Now, is it possible to somehow get information that this very row was matched because of 'Jumping' word? It doesn't even have to be exact information, more of a which substring caused row to match.

Why I'm asking - I got C# app that builds up those queries basing on user input (keywords to search for), and I need the very basic information why/how row was matched back, to use further in C# code.

If it's not possible, any alternatives?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2008