How to search by text based on morphology in C#?

Question

Database

There is MSSQL a DB. It contains texts ranging from 300 to 10,000 characters. How to organize a search on them taking into account morphology in C sharp? How to give the most relevant texts?

Answer 1

Thanks for answers. I understand Sphinx also makes sense to consider? Which of the three options (full text, Elastic, Sphinx) do you prefer and why?
UPDATE: Sphinx launched in a couple of hours. Articles from here chakrygin.ru/ helped to figure it out. Elastic did not win in the evening and abandoned.

Answer 2

You need a full text search
https://habrahabr.ru/post/40218/

Answer 3

You can index texts using the ElasticSearch search engine, and only then search in ElasticSearch using the library:
https://github.com/elastic/elasticsearch-net