Linking and updating tables

[lizarde03]

I have one table with a list of different values. I have another table that has a field that has values from the first table somewhere in the field..

Table 1
Street
Drive
Road
Circle
Cove

Table 2
1234 A. Street
3556 B. Cove

What I want to do is if a word in table 2 matches a word from table 1 then i want to update the street name field in Table 2.

Any suggestions?

Thanks!