I'm not sure which version of IPAM do you use, but we do an improvement of search performance in latest IPAM 3.1.
Unlikely the "no IP address found" message you see is most likely connected with timeout of search query. If you can try uncheck all
other search options except IP address option itself and do a search it will be quick enough to give you result also in older versions of IPAM.
The wildcards are applied automatically. Once you search for 'D019' it's handled as if you do search for '*D019*' and in default case insensitive.
This can be of course altered by settings in MSSQL server.
In case you have no custom modifications of settings in MSSQL and so ... please feel free to open support case.
IPAM Dev Team