The most common types of psychotherapy used in treating substance use disorder are Cognitive Behavioral Therapy (CBT) and Dialectical Behavioral Therapy (DBT).