Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Evaluate the similarity of two strings and return the match rate In vertica SQL

Hi Guys,

I am comparing two columns in a table which contains text search. I would like to know whether we have any functions in vertica as if we have in SQL server (Soundex()) and Excel(Fuzzy lookup). Kindly help me out in this.

Sample :
Here we compare Comp_name and Company_name -and the output is similarity

Comp_name,company_name,Similarity
ALLIANCE ,alliance ia,0.9789
ARISTOON ,aristoon group,0.9556
ACII CLUB ,aciI - automobile club d'italia,0.9555
UNIVERSITTTTTA' DI MILANO , studi di milano,0.9250
START ,start srl,0.9077
ANASS ,anssa,0.9036

Thanks in advance

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.