Match value after fuzzy lookupvalue between two tables

Hi all,

I need some help on match/LookUpValue in two different tables about streets and suburb, where the first table contants streets of all incidents, and the second table contants all the possible streets in suburb. I would like to do a match/lookup to give the complete street name and suburb in table 1 based on informaiton in table 2 (I can do this in Excel using  fuzzy lookup by set up StreetName & "*" then the lookup function could will covers street with the key word)

I tried several different method in PowerBI, but still not sucessful to get the output I want, please help if you would be able to. Thanks!

Table 1: 

STREET                     SUBURB                        STREETLOOKUP

MAIN                        BURLINGTON               BURLINGTON*MAIN

MAIN                        GREENSBORO              GREENSBORO*MAIN

MAIN AV                  GREENSBORO              GREENSBORO*MAIN AV

SECOND                  BURLINGTON                BURLINGTON*SECOND

SECOND ST              BURLINGTON                BURLINGTON*SECOND ST

SECOND PL              GREENSBORO              GREENSBORO*SECOND PL

Table 2:

STREET                     SUBURB                      LookupStreet

MAIN STREET          BURLINGTON               BURLINGTON*MAIN STREET             

MAIN AVENUE         GREENSBORO             GREENSBORO*MAIN AVENUE          

SECOND STREET      BURLINGTON              BURLINGTON*SECOND STREET          

SECOND PLACE        GREENSBORO             GREENSBORO*SECOND PLACE

AND I want to do a lookup/match so Table 1 could show the correct complete street name under each suburb as following: 

STREET            SUBURB                   STREETLOOKUP                         FinalResult

MAIN             BURLINGTON           BURLINGTON*MAIN                  BURLINGTON*MAIN STREET

MAIN              GREENSBORO         GREENSBORO*MAIN                 GREENSBORO*MAIN AVENUE

MAIN AV         GREENSBORO         GREENSBORO*MAIN AV           GREENSBORO*MAIN AVENUE

SECOND          BURLINGTON          BURLINGTON*SECOND             BURLINGTON*SECOND STREET

SECOND ST     BURLINGTON          BURLINGTON*SECOND ST        BURLINGTON*SECOND STREET

SECOND PL     GREENSBORO         GREENSBORO*SECOND PL        GREENSBORO*SECOND PLACE