When using Search there’s a hard limit of 50 results from the local library for reasons I don’t know about. As you’ve already figured out to get all possible local results for a certain category (albums, tracks, …) you need to use the other means Roon provides - like using the funnel filter in the respective category.
BTW I’ve asked for a change to this behaviour but it’s not looking like it’s of much interest.
