Compensating for typos in strings by removing spaces and making uppercase for comparison
You can simplify avoiding reassignement:

def standardizer(str):
    return str.replace("sp_ec_", "sp_etc_").replace(" ", "").upper()


You should use a for loop to avoid repetition in the following lines:

print(str1, standardizer(str1))
print(str2, standardizer(str2))
print(str3, standardizer(str3))
print(str4, standardizer(str4))
print(str5, standardizer(str5))