Finding Similar Names

What do you do when you want to compare two lists of names (e.g company names)? The first thing that comes to your head is usually ‘VLookUp in Excel’! Think about it - these company names might come from difference sources and their spelling is not always the same, e.g. you will have ABC Company Limited, ABC Co. Ltd., ABC Company Ltd. or many other combinations! Here is a quick Python programme to highlight similar names and their simiarity ratio (of your choice!)