Improve search in content perspective

• Across the content perspective, and in pickers within this perspective, ensure search functionality can handle wild card and partial searches.

NOTE: whatever we implement here should be consistent with the search functionality in the admin perspective (as this search functionality was recently improved)