This wildcard need not be entered by the end user. Below are the steps you will have to implement.
1. User submits the literal string eg."509 BERRY CT" to your php page.
2. In php page break this string into multiple words.
3. Parse multiple words with wildcard character.
4. Send this new parsed string to the query.
The code could be something like below.
$search = "509 BERRY CT";
$multipleWords = explode(" ",$search);
$parsedTerm = "%";
foreach($multipleWords as $word){
$parsedTerm .= $word."%";
}
$query = $pdo->prepare("select * from PERMITMASTER where ADDRESS LIKE '".$parsedTerm."'");
Here is a php sandbox link with a working snippet for this case.