Similarity search PostgreSql [duplicate]

2

I would like to know if I can do a similarity lookup in a field of type character varying in PostgreSql.

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

Remembering that I'm using version 8.4 of postgresql and I also have no way to make installations on the server, since it is from a company that I split the bank. That is, I can not use the fuzzystrmatch module, with the functions soundex() and difference()

    
asked by anonymous 29.07.2014 / 19:23

1 answer

0

I do not believe that any database has some 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 from this forum , below you will see that a user posted a script with some functions for PostgreSQL that will probably help you.

    
29.07.2014 / 20:36