System for mending through automated processes

Systems and methods are provided for transforming historical data collected in response to one or more triggering events, in order to classify textual values. Embodiments access a plurality of textual values from historical transaction data; identify one or more distinct patterns within the plurality of textual values; group the textual values based on the one or more distinct patterns, thereby forming one or more clusters; apply a similarity gauge to the textual values of each of the clusters to determine similarity or dissimilarity among the textual values of each cluster; and filter the textual values of each cluster to determine which textual values belong in each cluster, wherein the textual values that belong are cluster values. Some embodiments also remove undesired characters from the textual values, and in some cases identifying the distinct patterns includes comparing pronunciations and/or phonetics of the textual values.