Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “consecutions” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

32 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
consecutions	16	4	704	(None)
consecution	15	4	730	1	consecution_
confections	18	4	1139	2	confec_tions
connections	15	4	1070	2	connec_tions
consecrations	17	4	921	2	consecrations
convections	18	4	1149	2	convec_tions
collections	15	4	793	3	collec_tions
conceptions	17	4	1059	3	conce_ptions
concoctions	14	4	825	3	concoc_tions
conductions	16	4	966	3	conduc_tions
confection	17	4	1118	3	confec_tion_
congelations	15	4	973	3	congelations
congestions	14	4	931	3	conge_stions
connection	14	4	1053	3	connec_tion_
consecration	16	4	978	3	consecration_
consecutive	18	5	594	3	consecuti_ve
conservations	18	4	909	3	conservations
consociations	17	4	751	3	consociations
consolations	14	4	974	3	consolations
constitutions	15	5	486	3	constitutions
constructions	17	4	771	3	constructions
consumptions	18	4	514	3	consumptions
contentions	13	4	1209	3	conte_ntions
convection	17	4	1112	3	convec_tion_
conventions	16	4	1053	3	conve_ntions
convictions	18	4	804	3	convic_tions
convocations	19	4	736	3	convocations
convolutions	17	4	519	3	convolutions
corrections	15	4	886	3	correc_tions
nonsolutions	12	5	417	3	nonsolutions
persecutions	16	5	479	3	persecutions
prosecutions	16	4	561	3	prosecutions

Search took 5 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	95024	0.376	475242.0
2	DLD Change Limit	95024	32	3.890	24427.8
3	Display Results	32	32	0.016	2000.0
	(SQL Overall)	178691	32	4.282	41730.7