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.