Revealing Interconnections between Diseases: from Statistical Methods to Large Language Models