Search in sphinx Russian words 2

Why then do sphhix?
\r
Sphinx is a search based on the index. I.e. each word is, roughly speaking, replaced by a number and then when the search compares only numbers. Just look for a substring in each record, the Sphinx then it is unlikely that anything will speed up.
\r
Or, alternatively, add an asterisk to each word automatically before processing the request, if not embarrassing performance.

So what's stopping You after every word to slip * for Sphinx?

Try to use the options min_prefix_len and min_infix_len
\rwww.sphinxsearch.com/docs/current.html#conf-min-prefix-len