e.g. Kit/package name "apple", made an assembly/BOM with name "greenapple". How can I do a search to check if kit/package name matches with ANY assembly name?

I can't think how this can be done in a saved search. As it's hopefully a once off I think you will have to export to spreadsheet and do a vlookup or similar