That’s certainly possible and expected, depending on what else was entered in between. For example, suppose you have the city name Carmel in your database, and it’s the only city that starts with Car. So you could enter Car and clairvoyance will kick in and complete the entry.
But then, you enter Carmel Valley into the database. Once you’ve done that, Car won’t trigger clairvoyance any more. In fact, at that point you’ll always have to fully type in Carmel, clairvoyance will never kick in. However, if you type in Carmel and then a space, it will suggest Carmel Valley. That’s how the clairvoyance feature has always worked, all the way back to Panorama 1.0.
I wrote a longer post about Clairvoyance a couple of months ago, you may find that helpful. There are also some great suggestions from several other users on that thread about how to understand why Clairvoyance doesn’t, by design, find a match with a particular data set.