in effect vs in substance

in effect

adj
  • Operating or functioning; in force; in play. 

adv
  • For all practical purposes; in practice; actually; essentially; basically. 

in substance

How often have the words in effect and in substance occurred in a corpus of books? (source: Google Ngram Viewer )