Just experienced what the 'gap limit' is in a wallet...that'll make your heart race lullz.
Discussion
tf is gap limit
read up on it here https://docs.btcpayserver.org/FAQ/Wallet/#the-gap-limit-problem
It cites electrum and wasabi wallet as wallets that give the ability to determine your gap limit and find a wallet address that is seemingly missing from your wallet due to the problem. But I believe Sparrow can solve for it too.