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

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

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.

80 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
consternations	16	11	604	(None)
consternation	15	10	636	1	consternation_
conservations	18	4	909	2	cons_ervations
constellations	16	5	440	2	constellations
consternating	16	5	497	2	consternati_ng
concatenations	18	7	372	3	concate_nations
condemnations	18	4	540	3	con_demnations
consecrations	17	4	921	3	cons_ecrations
conservation	17	4	940	3	cons_ervation_
considerations	17	6	484	3	consider_ations
consignations	16	10	593	3	cons_ignations
conspirations	17	4	772	3	conspir_ations
constellation	15	5	480	3	constellation_
consternates	14	5	505	3	consternat__es
constipations	17	4	768	3	const_ipations
constrictions	17	4	778	3	const_rictions
constructions	17	4	771	3	const_ructions
contentions	13	4	1209	3	con_te_n_tions
contestations	15	4	773	3	con_testations
conversations	18	4	745	3	con_versations
alternations	12	4	677	4	__alternations
castrations	13	4	1005	4	c_ast_r_ations
catenations	13	4	836	4	c__ate_nations
coacervations	20	5	387	4	co_acervations
cogenerations	16	5	591	4	cogener_ations
concatenation	17	6	409	4	concate_nation_
condemnation	17	4	604	4	con_demnation_
condensations	16	4	627	4	con_densations
condonations	15	4	800	4	con__donations
confederations	20	10	460	4	confeder_ations
confirmations	20	5	567	4	con_firmations
conformations	20	4	672	4	con_formations
congelations	15	4	973	4	con_ge_lations
congregations	17	18	641	4	congre_gations
conjurations	21	4	849	4	con_jur_ations
connations	12	3	1294	4	con____nations
conscriptions	19	5	500	4	cons_criptions
consecration	16	4	978	4	cons_ecration_
consecutions	16	4	705	4	cons_e_cutions
conservational	19	5	534	4	cons_ervational
conservationist	20	8	402	4	cons_ervationist
conservatisms	20	8	353	4	cons_ervatisms
conservatives	21	9	519	4	cons_ervatives
conservatizes	27	11	445	4	cons_ervatizes
conservators	17	5	597	4	cons_ervat_ors
consideration	16	5	552	4	consider_ation_
consignation	15	13	631	4	cons_ignation_
consociations	17	4	751	4	cons_ociations
consolations	14	4	974	4	cons__olations
consolidations	17	5	474	4	consolidations
conspiration	16	4	838	4	conspir_ation_
constellating	16	5	326	4	constellati_ng
consternate	13	5	512	4	consternat___e
consternated	15	5	411	4	consternat__ed
constipation	16	4	856	4	const_ipation_
constitutions	15	5	486	4	const_itutions
constrains	12	4	972	4	const_r_a_i_ns
constriction	16	4	826	4	const_riction_
construction	16	4	808	4	const_ruction_
consultations	15	4	693	4	cons_ultations
consummations	19	5	515	4	cons_ummations
contaminations	18	8	610	4	contaminations
contemplations	20	7	473	4	con_templations
contention	12	4	1222	4	con_te_n_tion_
contentious	13	4	701	4	con_te_n_tious
contestation	14	4	866	4	con_testation_
continuations	15	4	714	4	con_tinuations
contortions	13	4	868	4	con_tor__tions
contractions	16	4	1040	4	con_t_ractions
contraptions	16	4	764	4	con_t_raptions
contritions	13	4	1091	4	con_t_r_itions
conurbations	16	4	666	4	con__urbations
conventions	16	4	1053	4	con_ve_n_tions
conversation	17	4	780	4	con_versation_
cooperations	16	5	919	4	co_oper_ations
counteractions	18	5	502	4	counteractions
cybernations	19	4	360	4	c__ybernations
menstruations	15	8	505	4	menst_ruations
observations	17	8	501	4	_obs_ervations
ostentations	12	4	612	4	_o_stentations

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	65874	0.313	570897.8
2	DLD Change Limit	65874	80	3.640	18097.3
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	3.999	44683.9