To dream of digging a hole to find something represents hard work to uncover answers or solve a problem. Getting to the root of an issue. Preoccupation with trying to find something out. Alternatively, digging something up may reflect a return to old problems. Not letting the past stay settled. “Digging” up trouble.
Negatively, a hole may reflect a fruitless effort that is making a problem worse. Using all your resources to get to the root of a problem only to leave yourself worse than before. Embarrassment that thinking your ideas were going to work.
To dream of a dug hole filled with water represents uncertainty or trouble that is in the the way of your search for answers.
To dream of a whole an purposely filled with water represents an attempt to cover up your search for answers by telling others it’s too dangerous or problematic to follow you. Keeping people copying you or following your search.