Glossary: System Design Beyond the Basics in Java

Full-text search

Finding products whose text contains the words typed, best match first. SQL's `LIKE '%word%'` can't do this efficiently.