Hi ,

I have set of records as shown below.

ID String

1help

2HELP

3hel

4he

5helipad

6Helpad

7vice

8VICEadmin

9vice admin

10Vice President

I wanted to aggregate the count of common strings based on the similarity.

My end should look like

COUNTS STRING

2 help

1 hel

1 he

2 helipad

1 vice

2 Vice admin

1 Vice President

Please let me know thanks in advance.