I had a similar problem and initially came up with a similar solution. However in practice our database contains names like MacDoanld, McDonald, Mace. What i've ended up with is...