Find a way to standardize addresses

Database
Enthusiast

Find a way to standardize addresses

Hi Guys,

I would like to know if there is a way or function in Teradata which allows me to standardize addresses. For instance, I have the following scenarios:

Address #1

Street 111 Williams Hall

Address #2

St 111 Williams Hall

Address #3

Stt 111 Williams Hall

By reviewing the above examples, I just realize that the addresses are the same, so I would need to generate only one address with the following information

Standardize address --> ST 111 Williams Hall

Is there any way to achieve this? If so, Could you please suggest me any idea or manual where I can find this information?

Thanks in advance.