You can use org-roam-node-find which (maybe depending on your default completion framework, I use doom emacs btw. so some things are preset) let you type substrings of the actual title of the node to find it.
This is a bit complicated, because there is no built-in way for having distinct buckets in Org-roam. But you can set directory-local variables in .dir-locals.el to achieve this.
For example, put this inside the file /home/username/work/.dir-locals.el:
Whenever Emacs opens a file inside the work directory, it will load and apply any variables in this file.
Therefore you first must open a file inside the folder to access this files; open a file outside the directory to access the default ones.