Full-text search ranks matches by relevance, handles stemming (attorneys matches attorney), and tolerates typos. Options: MySQL/PostgreSQL built-in FULLTEXT (fine up to ~10K documents), Elasticsearch/Meilisearch (search at scale), Algolia (hosted, fast, expensive).
Full-Text Search
Also known as: FTS