Drug names with minor typographical differences is repeated

[sunbiz]

We need a mechanism to check for minor typographical differences in drug names so that they are not repeated in the concept or drug tables. Currently, spaces, multiple spaces, or lack of spaces is creating duplicate concept/drug names in the database.
Below is an example:

[arygup]

Dear sir, after going through the codebase. I have tried my best to write a function which deletes all rows with similar names. This function can be modified to prevent inserting new rows of already existing data.

kindly please consider going through this small piece of code
https://github.com/arygup/Projects/blob/main/HandlingTypos.ipynb

Best Regards,
Aryan Gupta