Compare 2 Columns For Close Matches

I want to compare two columns (from two different files, but copied into a new sheet) for duplicates or identical entries. But here's the trick, each entry contains atleast a number of digits. I'm not quite sure how to find items that may be 80% identical (in the right order, but might be messing a digit, or there is a dash or a 'o' instead of a '0'). I know how to do it in C++ or Java, but not quite sure how to do it in VBA/macro. Here's an example of what I meant. Let's say column one has the following:

0244-34
9393-O0
3932-44

and second column has
939300
493384
938923

If I was comparing second column to first column, it can pick up the 9393-O0 one because it's close enough to 939300.