You don't need Elasticsearch! Fuzzy Search with PostgreSQL and Spring Data by Thomas Gräfenstein

Thomas Grfenstein explains how to implement fast, error-tolerant fuzzy text search using PostgreSQL trigrams and Spring Data JPA without Elasticsearch.

Spring I/O 2025 - 21-23 May, Barcelona Slides: github.com/g-stone7/fuzzy-search-with-postgres-trigram/blob/… Repo: github.com/g-stone7/fuzzy-search-with-postgres-trigram Have you ever needed to implement a search feature that’s error-tolerant, fast, and delivers relevant results regardless of the natural language and you didn’t want to run your own Elasticsearch or Opensearch cluster? Look no further! In this talk, we’ll explore how PostgreSQL’s powerful tools enable fuzzy text search. From similarity scoring to trigram matching, discover practical techniques to build robust search capabilities. And the best part? You will learn how to seamlessly integrate these features into your application using Spring Data JPA, all while ensuring your code remains clean, abstract, and reusable.