Schedule - FOSDEM PGDay 2023

Fuzzy Text Search: An unassertive guide to almost getting what you want

Date: 2023-02-03
Time: 11:30–12:20
Room: Brussels Ballroom 2
Feedback: Leave feedback

Description: In this presentation, I'll explain what fuzzy logic is and demonstrate a number of methods you can use to implement this in your application using PostgreSQL. Ranging from not so fuzzy to very fuzzy. In addition, I'll explain what scenarios each method is suitable for and methods to improve speed and efficiency.

Presentation - intro - what is fuzzy logic - why you might want it - pattern matching - text search vectors (tsvectors) - Ngrams (trigrams) - levenstein distance - phonetics (Soundex, Metaphone, Double Metaphone)

Live Demo We'll look at a small dataset and demonstrate what kind of results you can expect.


Brendan Scullion