How, having a large text, find matches of all sentences?

Question

Search engines

Imagine there is a table sentences, where hundreds of thousands of some sentences or phrases are stored.
And there is a text of 5000 words that the user entered (for example).

Is there any way or algorithm to rationally use computational resources to select all matches in the text (for example, through str_replace) from the entire sentences table?

Answer 1

And why, in fact, do you want to solve this problem using postgres, and not using much more suitable solutions based on inverted indexes - Lucene, Elasticsearch, etc.?

Answer 2

It is necessary to build an alphabetical index and multiply words by simple coefficients.

Answer 3

https://ru.wikipedia.org/wiki/%D0%90%D0%BB%D0%B3%D...