Rename field values with values from another table

I have two tables.descriptions I'd like to relate and use to find/replace in bulk.

[Checking].[Description] (with the source data)

[Rename].[NewDescription] (with the correct data)



I'd like the values in [Checking].[Description] to be replaced with the values in [Rename].[NewDescription], including those that are "Like".



Examples:

[Checking].[Description] = Geico 12345

[Rename].[NewDescription] = Geico



[Checking].[Description] = Geic

[Rename].[NewDescription] = Geico



Can someone tell me the SQL for this? Thanks

Rename field values with values from another table