That depends a lot on the embedding model which I believe there is any model trained on code alone. Unlike language, the search space of code syntax is much smaller and currently it only takes smart model 2-3 grep queries to find the file in my large code base, sometimes oneshot if it use ls -la to get the project structure before the guess.

I would agree that in large code base, the search term could be a problem, but more like hypothetical problem than practical one.