Jaime,
Yes, I thought about soundex, but my problem is, that I have PStreet - unparsed and Street - street only, e.g.
PStreet: 11 Lily Pond Rd #A
Street: Lilly Pond Rd
What should I do? I want to be sure, that I got StNum right and I got Lilly part right. Pond Rd are unrelevant...
I can, of course, create an array of words for PStreet and compare soundex of them with Street part.
Do you think, I need to proceed in this direction? Do you see other alternatives?
If it's not broken, fix it until it is.
My Blog