Somethings that may already exist but I don't know how.
a way of ignoring ", The" , " and" , and "&"..etc when looking for duplicates.
Generate a soundex code field from another field (would be helpful in checking name and artist spellings)
Soundex codes begin with the first letter of the surname followed by a three-digit code that represents the (first three) remaining consonants. Let the Soundex converter do the tricky work for you and capture the nuances of the coding scheme (such as coding adjacent like letters as one). Enter above the surname that you want coded.
Soundex Coding Guide
1 = B,P,F,V
2 = C,S,G,J,K,Q,X,Z
3 = D,T
4 = L
5 = M,N
6 = R
The letters A,E,I,O,U,Y,H, and W are not coded.