CODEWITHSUNDEEP
excelnlpfuzzy-searchfuzzy-comparisonsentence-similarity
Chitwan
Chitwan

Reputation: 21

String Match using Fuzzy Lookup in Excel

I am trying to use Fuzzy Lookup to match two strings in two columns of a table that looks like below. Table1 Table2

| Column A     | Column B |
| --------     | -------- | 
| Flower.com   | Flower   | 
| Flower.com   | snacks   | 
| Flower.com   | food     |

When I apply Fuzzy lookup to the above tables I get false positive. In the sense I get a similarity score of 0.987 for all three rows.
Table1             Table2  

| Column A     | Column B | Similarity Score | 
| --------     | -------- | ---------------| 
| Flower.com   | Flower   | 0.987 | 
| Flower.com   | snacks   | 0.987 | 
| Flower.com   | food     | 0.987 |

Which is not making any sense. I have tried applying threshold between 0 to 0.8 but the similarity score remains same. Why is that so? I want it to look like below
Table1             Table2  

| Column A     | Column B | Similarity Score | 
| --------     | -------- | ---------------| 
| Flower.com   | Flower   | 0.987 | 
| Flower.com   | snacks   | 0 | 
| Flower.com   | food     | 0.0 |

Is there another way to match the two strings in excel?

I have tried fuzzy lookup addin provided by Excel

Upvotes: 0

Views: 60

Answers (0)

Related Questions