Category Archives: SQL

Fuzzy String Search in SQL

Users often enter data approximately or inaccurately.. But sometimes, we need to search or match this inaccurate data anyway!

For example, users should match existing customer records rather than creating unwanted duplicates.

There are standard algorithms for measuring string-distances, but we’ll need a few extra steps to make this work efficiently against a database..  Continue reading