Lookup Formula Issue, Search issue

Here is the file I am working on. What I need done with it is:
1) on the lookup tab in the "Search Box I want to be able to abbreviate the spelling of a street name, (ex Deer Run to be able to just type Dee or something.
2) You will see in the database there are street names that are the same but in different districts. I need an option on the lookup tab to be able to scroll to the correct one when I enter in the search name.
3) The search name will always be the street name

Maybe this could help

YES!!!!
It's almost perfect.
All I need now is that on Streets tab the formula works for all new entries. I added one and its not showing on the search tab. I have several thousand rows to add into the street database.
Also Is there a way so that on the search tab if there is nothing in the Street Search box the listing below is blank instead of it listing all the data?
I attached the sheet again with some changes.

YES!!!!
It's almost perfect.
All I need now is that on Streets tab the formula works for all new entries. I added one and its not showing on the search tab. I have several thousand rows to add into the street database.
Also Is there a way so that on the search tab if there is nothing in the Street Search box the listing below is blank instead of it listing all the data?
I attached the sheet again with some changes.

In B6 and down, change to this:

=IFERROR(IF($C$2="","",INDEX(Streets!A$2:A$6,SMALL(IF(ISNUMBER(SEARCH($C$2,Streets!$A$2:$A$6)),ROW(Streets!$A$2:$A$6)-MIN(ROW(Streets!$A$2:$A$6))+1),ROWS($1:1)))),"")

Array Formula, you need to confirm press CTRL-SHiFT-ENTER button together, ENTER alone is not works

I don't understand, Is it set up now correctly? I don't know where I need to place the formula. Also is there a way to not have the 0 show up in the search results if there is nothing entered in the Street Data tab? I'm trying to keep the Search results as clean as possible.

I don't understand, Is it set up now correctly? I don't know where I need to place the formula. Also is there a way to not have the 0 show up in the search results if there is nothing entered in the Street Data tab? I'm trying to keep the Search results as clean as possible.

Can anyone help me on the attached spreadsheet to make it not show the "0" in columns G and H on the Search tab if there is no data entered on the Streets tab on a particular row?

Im sorry forget to tell that Column C through H has different formula with Column B (Street Names)

Pls see the file

I believe it is perfect... Thank you all!!!!