We should add search result highlighting for better UX.

The search filters are working well with the current implementation.

Agreed. We can always upgrade to Elasticsearch later if needed.

Elasticsearch might be overkill for our current scale. Let's start with database full-text search.