Postgres Full-Text vs Trigram vs Meilisearch for Typo Search
Postgres full-text search returns nothing for a misspelling, by design. What trigram matching fixes, the wrong rows it brings with it, how to combine the two, and when a search engine with real typo tolerance earns its keep.