db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Trigram search

pg_trgm breaks text into three-letter pieces and measures how many two strings share. word_similarity(a, b) compares a to the best-matching part of b, so it forgives typos that full-text search cannot.

task

Titles with a word within word_similarity above 0.25 of 'bridge' (it also finds the typo "brdige").

hints