Search Feature Implementation

Help me design search for {{use_case}} over {{data}}. Recommend the approach (database queries, full-text search, or a search engine) based on the scale and relevance needs, how to handle typos, synonyms, ranking, filters and facets, partial matches, performance, and an empty or no-results experience. Provide an implementation outline. Note when a simple LIKE query is fine versus when you need real search infrastructure, and how to keep results relevant rather than just matching keywords. Stack: {{stack}}.