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

Here are the results of your fuzzy-string dictionary search for “consternates” 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.

69 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
consternates	14	5	505	(None)
consternate	13	5	512	1	consternate_
consternated	15	5	411	1	consternated
constellates	14	17	423	2	constellates
concatenates	16	5	453	3	concate_nates
consecrates	15	4	839	3	cons_ecrates
constellate	13	11	456	3	constellate_
constellated	15	11	357	3	constellated
consternating	16	5	497	3	consternating
consternation	15	10	636	3	consternation
consternations	16	11	604	3	consternations
constipates	15	4	635	3	const_ipates
alternates	10	4	787	4	__alternates
caseinates	12	4	744	4	c_as_einates
castrates	11	3	1267	4	c_ast_r_ates
catenates	11	3	1181	4	c__ate_nates
cisternae	11	26	509	4	c_isterna_e_
coacervates	18	8	359	4	co_acervates
concatenate	15	5	440	4	concate_nate_
concatenated	17	5	352	4	concate_nated
condensates	14	4	531	4	con_densates
conepates	13	9	1228	4	con__e_pates
confederates	18	5	462	4	confeder_ates
congregates	15	4	550	4	congre_gates
consecrate	14	4	843	4	cons_ecrate_
consecrated	16	4	691	4	cons_ecrated
consented	12	3	1194	4	cons_e_n_ted
consenter	11	3	1249	4	cons_e_n_ter
consenters	12	4	1084	4	cons_e_n_ters
consents	10	27	1589	4	cons_e_n_t_s
conservatism	19	10	495	4	cons_ervatism
conservatives	21	9	519	4	cons_ervatives
conservatizes	27	11	445	4	cons_ervatizes
conservator	16	5	637	4	cons_ervator
conservators	17	5	597	4	cons_ervators
conserves	14	3	1119	4	cons_er__ves
considerate	14	5	547	4	consider_ate_
consociates	15	4	654	4	cons_ociates
consolidates	15	6	386	4	consolidates
constancies	15	4	664	4	const_ancies
constantans	13	5	343	4	const_antans
constants	11	4	1091	4	const_an_t_s
constipate	14	4	639	4	const_ipate_
constipated	16	4	546	4	const_ipated
constitutes	13	7	616	4	const_itutes
constrains	12	4	972	4	const_r_ains
constricted	16	4	636	4	const_ricted
constricts	14	7	773	4	const_rict_s
constringes	14	4	504	4	const_ringes
construals	12	4	521	4	const_rua_ls
constructed	16	4	625	4	const_ructed
constructs	14	5	705	4	const_ruct_s
construes	11	4	1013	4	const_r__ues
consulates	12	7	1110	4	cons__ulates
consummates	17	5	420	4	cons_ummates
contaminates	16	5	631	4	contaminates
contemplates	18	5	528	4	con_templates
contented	12	3	1304	4	con_te_n_ted
contents	10	40	1821	4	con_te_n_t_s
cooperates	14	6	961	4	co_oper_ates
counterpanes	16	4	930	4	counterpanes
counterstates	15	8	664	4	counterstates
cybernates	17	4	339	4	c__ybernates
fosterages	14	4	477	4	fo_ster_ages
menstruates	13	4	398	4	menst_ruates
monsteras	11	31	824	4	monster_a__s
monstrances	15	4	501	4	monst_rances
nonliterates	12	5	545	4	nonliter_ates
sternites	9	3	1007	4	___sternites

Search took 9 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	124790	0.390	458182.1
2	DLD Change Limit	124790	69	7.706	16193.9
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	8.126	21990.0