Agree with June. Match what you can and look at what's left. Decide a standard format and manually correct the remainder (how many teams can there be?). If this is an ongoing problem, perhaps create an 'alias' table and use the replace function to correct e.g.
Code:
tblAliases
Phrase...Alias
St. Saint
St Saint
then use a replace function to replace Phrase with Alias. However you need to take care, you would not want to change Stamford to Saintamford for example.
Had a similar situation with a pharma client where they had Tab, Tabs and Tablets, Cap, Caps, Capsule, Capsules etc so my advice would be to replace longer with shorter e.g. St replaces Saint and St.
Another small trick is to use an underscore to represent a space so it is visible in the aliases table then replace it before applying the main replace e.g.
Code:
replace(myField,replace(Phrase,"_"," "),Alias)