When validating student addresses, the difference between St. Maria and St Maria can cause it to fail. The same with the difference between Av, Ave, and Avenue. All mean the same thing, but if the street table only contains one variation then only that one variation will pass validation. The street address parser could be much more intelligent, checking if the final 'word' in the student and street table addresses match any of a set of known street type variations and then validating true if both are in the same class of street type