MySQL Base with 40+ ml entry AND SELECT

There is a database, weight ~10 gb, number of rows 45 million (they are divided into tables).

There are 10 columns, we need to search for 1 column which type is varchar.

Fulltext index in MySQL is not quite suitable, because the search goes after *. And need to search for words that have “ppl” as an example of the word apple.

Sphinx also as I read looking for thus (after *), therefore also does not approach.

Can you tell me what is better to use in this case?

Would a NoSQL solution work for me? (for example Cassandra, does she know how to search inside for words? In SQL query LIKE %text%)