A SQL LIKE query won't scale. "SELECT * FROM products WHERE description LIKE '%wireless headphones%'" scans every row. With million products, that's unusable.
Search engines use inverted indexes. Instead of scanning documents for words, they look up words to find documents. This changes to lookup time, using space for the index.
I'll show you how search engines work, when to add dedicated search, and how to design search features in interviews.