A systematic search for long-term variability in a large sample of X-ray sources