Search for Postgresql similarity

Asked

Viewed 475 times

2

I wonder if I can do a similarity search in a field like character varying in Postgresql.

For example: The name I have saved in the table in the name field is Tauros and I’m looking for Taurros. I wanted something that would return me the degree of similarity between what was typed and what I found.

Remembering that I am using the version 8.4 of postgresql and also I have no way to do installations on the server, because it is a company that divides the bank. That is, I cannot use the fuzzystrmatch module, with the functions soundex() and difference()

postgresql

  • As I said, it would not be possible to use the new functions, because these functions depend on libraries that have to be installed and I do not have access. But thank you.

1 answer

0


I don’t think any database natively has any function that returns results by similarity. But from the research I’ve done, there are several algorithms that can solve your problem.

Read the posts of this forum, below you will see that a user has posted a script with some functions for Postgresql that will probably help you.

Browser other questions tagged postgresql

You are not signed in. Login or sign up in order to post.