Similarity model and preprocessing

Job ID: 33256860

Budget: ₹6,000 – ₹15,000 INR

Use Case: I have two files with multiple columns. We need to find best similar columns to match.
Requirements and suggestions:
>Alphanumeric, symbols and abbreviations present. Apply necessary rules / regex / custom corpus to preprocess.
>Match using similarity with higher weightage to alphabetic word match.
>Set a threshold and above it give as best match below it give top 3 suggestions.
Attaching example data. Will share actual data after the plan seems right and NDA.
Related categories: Python Machine Learning (ML) NLP