I'm trying to evaluate a address to avoid duplicate information, in this case I developed a apex class that consult a custom dictionary, the idea is take exact words from the Street and replace for a new one for example:
st - Street
st. - Street
ave. - Avenue
av - Avenue
Now I'm using the CONTAINS method and REPLACE, but just I need is the exact word to replace it. I hope anybody can help me with some ideas.