DataSource Controls :: Match Address Of Same Property Between Two Tables?

I have two tables, both contains same properties. The problem is the address spellings MAY vary between table 1 and table 2 but they are actualy same properties. In my sql statement it list out the property that has exactly the same spellling. How do I match the two tables addresses? I heard about fuzzy algorithm but how do I apply it here. I know it wont be perfect but it will be close (check my sql below) I use sql server 05.

Example

Table 1
- 123 greenwood hwy
- 123 halo street
Table 2
- 123 greenwood highway
- 123 halo street
SELECT table1.address,table2.street_address
FROM table1 INNER JOIN
able2 ON table1.address = table2.street_address

My Output returns only one property that has same exact address spellings

- 123 halo street | 123 halo street