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

Is it possible to get this information as to why / how the row returned from the FTS query was matched)? For example, consider the simplest table with the id and text columns with the FTS index on the one later.

  Choose where the Examples are (Text, 'Form (Invention, Jump)');  

This can return the experimental query, say line {1, 'jumping jack'} . Now, is it possible to have any information that it was due to the very line 'jumping' ? It does not even have accurate information, and more which rationalize authoritresses due to match .

Why am I asking - I got the C # app, which prepares those questions based on user input (to search for keywords), and I need very basic information. Why / line was matched back, to use more in C # code

If this is not possible, then any option?

---

Edit with respect to Mike Burton and Lesterdaw's responses:

For example, it was trivial for obvious reasons and your solution is OK Keeping this in mind, FTS can still remove query results where regex or ordinary string mailings (such as likes ) will not be deducted. Return to the search for

bound bound (previous form) / P>

Exceptional Search for Return Stunning (Synonyms).

Both valid matches.

I am looking for a solution to this problem and found it. However, I already have FTS & amp;

Lester's answer Although I had some suggestions, maybe I could share the original string in a temporary table, and this partition result could run the original FTS query. Because it can work for my case (where DB is quite small and the queries are not very complicated), this approach in general can be out of the question.

) is included in the SS (E. text, 'formof (insufficient, jump)') and astringence '% jump%';

* Note: The user defined for the split function I had used the editors' edit before, and applied for the permission of the space character as a delimiter.

So, e is your example table. You still have the word 'jump' word You are searching the FT on the text field and you are now joining the table with the individual substring values ​​of your text field. You can see the LIKE or INST .