Hi,
I am hoping you can give me some guidance here. I’m using postgresql 9.1.
Basically, I’m trying to create a query on a table of businesses that will return all similar matches to a business name. This is a huge table, and there is a lot of variation in names. The length of the string can be up to 255. I’ve used regex, but there are always some variations of the name that are missed when I do a regex. So I decided to look at distance measures.
Has anyone compared the fuzzstrmatch package to pgsimilarity?
Would the levenshtein function in postgresql be the best way to go here? If so, should I use levenshtein in the contribution package or install the pgsimilarity package? Has anyone tried both implementations?
This would be my query:
Select * from table
WHERE levenshtein (column_name,’Name of the business’) <= 3
ORDER BY levenshtein (column_name, ‘Name of the business’)
Limit 10;
Thank you so much for your help.
Rachel