I am trying to find duplicates within a column, where the data represents the same thing but has not been normalized correctly during processing. 
I have built a # table with two key fields to search on.
Instead of trimming or manipulating the column I would like to bring back any matches > 8 characters in common sequentially.

Example data:

```
ID    Information
1     ABCDEF12.domain
2     domain.ABCDEF12
3     XYZABC123.22.26
4     222-XYZABC123-26
5     YYYYYYYYYYYYYYYY
6     AAAAAAAAAAAAAAAA
7     XYZABC123
8     ABCDEF12
9     123456789.1.2

```

would return sorted by least in length:

```
ID    Information
8     ABCDEF12
1     ABCDEF12.domain
2     domain.ABCDEF12
7     XYZABC123
3     XYZABC123.22.26
4     222-XYZABC123-26

```

Any starting points, best practice or any pointers to achieve this would be great. I am unsure how to initially identify any values that have 8 characters or more in common initially to narrow the data set, the sort is relatively simple.