Compare Two Columns For Single Character Matches

I have two excel sheets exported from two sources of information. Both sheets contain 1 column which is the primary data, ie, there is no duplicate of that information. Each information in these column represent 1 device in the real world.

Now, for example:
In one sheet, I have: SDV0620B
In the other sheet, I have: SSDV-B0620B

Please note that, both data actually represent the same device. What I now need to make sure is that, I ccan identify each corresponding data from the two sheets.

So, here is the problem that I am facing, identifying two data which are same but has two different representation techniques. (since the data are from two different sources)

I came up with the idea that, if I can check the sequence of characters with one column to another, then I might be able to pull it off.

For example,
we take SDV0620B, and match the sequence of character with SSDV-B0620B.
therefore, first is S (from SDV0620B)
match with SSDV-B0620B
then, D
match SSDV-B0620B
then V
match SSDV-B0620B
and so on, until the end.

And if the 1st sequence is found in the second sequnce of characters, then it is called a match! Hope I have explained it clearly. I have provided a file with some of the data copy and pasted out, to give you an idea of what the values look like.