Can't figure out what is wrong with this query?

Basically, there is nothing wrong with this query when you need to find parts of words in large texts, but this query is inefficient when you want to find words that start with specific characters.

So what is the solution?

Well, start with indexing columns, something like this:

Now query needs to be modified slitly.

If you couldn't find the difference, you should see the result and look more carefully: