Let's say I have a CSV file (single column) with a list of words as input. Meaning the file looks like below
Input Terms
Subaaaash
Paruuru
Mettromin
Paracetamol
Crocedinin
Vehiclehcle
Buildding
Dict terms #this dict has around million records and I have to find a closest match for input term from this dictionary
Metformin 250 MG
Metformin
.....
Crocin
Vehcile
Paru
Subash
Now, I expect my output to be like as shown below
As you can see that red colored Paru
is not a correct match for paracetamol
, but that's the closest match we can get for the input term paracetamol
from the dictionary. So, I would like to do matching based on
1) Word sounds (when pronounced). Phenotics
2) Spelling mistake corrections
3) Find the best matching word from the dictionary for input terms
Can you let me know how can I do the above?