I dont think its in our hand to cancel a transaction at any point. Only if its dropped we get it back but soon it gets re-broadcast by itself.
I understand, basically, transactions on the Bitcoin network in particular and blockchain in general cannot be canceled or changed by anyone. I am talking about transactions that have dropped from the mempool.
What is the difference between this and double spend? Both occur when the transaction fee is set low

How to distinguish them?