Joomla 3 - is it possible to search by partial word?

Question

Joomla

Is there any way to do a partial word search in Joomla 3?
Can you somehow set it up?
Maybe play around with the settings when indexing "smart search" or somehow fill in some fields in a tricky way (I read somewhere that you can cram into meta-words and meta-description - all forms of words - for indexing "smart search")?
Is there a module or plugin to solve this problem?

If anything: we are talking about 2-3 million records in cobalt.

Answer 1

MYSQL LIKE - https://yournet.kz/blog/mysql/poisk-s-pomoshhyu-op...

Answer 2

For a long time I created it manually under 3.5
Now - most likely it will be necessary to adapt it to 4-ku.