Find all Database Objects by Name?

Assuming you have the right permissions:

SELECT *
FROM yourdatabasename.sys.all_objects
WHERE upper(name) like upper('my prefix%')  --use UPPER for case-INsensitivity