Oracle Database Discussions

I am trying to determine the best approach to use to clean up our in house location addresses in an Oracle.

I would like to handle the basics such as ALLEE, ALLEY,ALLY to ALY; AV,AVEN,AVENU,AVENUE,AVN to AVE;

STREET, ROAD ETC.

I thought about using CASE, but that seems extensive. What are some other options that I could use.

Examples would be appreciated as well. Perhaps a procedure would be the way to go?

Thanks for taking the time to look.