You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@aggi
I have a list of company names, about 10,000 companies. List A
I have another list of company names, about 300,000 companies. List B
I want to see which companies on List A are also on List B.
The issue I have is that the two lists are from separate sources so company names may not tie up exactly. e.g. random punctuation, Ltd rather than Limited, missing The or similar, etc
Any suggestions for a decent way to do this? I'm not looking for exact matches, just ones which are similar enough to justify looking more deeply.