SQL indexes are hard to get right and performance is often poor even when you did.

On the other hand, for fulltext systems like Solr, indexes are trivial to set up and performance is usually impressive, even if you never use any fulltext features!

For many many uses, SQL is a poor fit, you're much better to stick to NoSQL or full text searches.

Also: Everything you knew about database normalization is SLOW.