Compare a field with other records return the number characters equal

[jbuzz7373]

I have a value in a table 010012001 which is called MO. Each number represents a descriptive factor in sightings of possible perverts watching kids in a park. I need to compare that with all of the other MO's in the table to see how many digits match. I can break it into 9 different fields if necessary. It is in text form.

For example:

record 1:021210012
record 2:122110111
record 3:211112211

What I need is Record 1 has 4 matching factors with record 2 and 3 matching factors with record 3. Record 2 has 4 matching factors with record 1 and 4 matching factors with record 3 and record 3 has 3 matching factors with record 1 and 4 matching factors with record 2.

Thanks for the help.

 

[jbuzz7373]

Nevermind. I figured it out.