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

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

52 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
constellates	14	17	423	(None)
constellate	13	11	456	1	constellate_
constellated	15	11	357	1	constellated
consternates	14	5	505	2	consternates
cantillates	13	4	663	3	can_tillates
castellated	14	4	327	3	c_astellated
consecrates	15	4	839	3	cons_ecrates
constellating	16	5	326	3	constellating
constellation	15	5	479	3	constellation
constellations	16	5	440	3	constellations
constellatory	18	6	259	3	constellatory
consternate	13	5	512	3	consternate_
consternated	15	5	411	3	consternated
constipates	15	4	635	3	const_ipates
consulates	12	7	1110	3	cons__ulates
contemplates	18	5	528	3	con_templates
cantillate	12	4	734	4	can_tillate_
cantillated	14	4	512	4	can_tillated
castellans	12	4	358	4	c_astella_ns
collates	10	30	1914	4	co____llates
concatenates	16	5	453	4	concate_nates
conciliates	15	4	688	4	con_ciliates
condensates	14	4	531	4	con_densates
conepates	13	9	1228	4	con__e_pates
confabulates	19	5	349	4	confabulates
conflates	14	3	1113	4	con___flates
congregates	15	4	550	4	congre_gates
consecrate	14	4	843	4	cons_ecrate_
consecrated	16	4	691	4	cons_ecrated
consociates	15	4	654	4	cons_ociates
consolidates	15	6	386	4	consolidates
constables	14	4	673	4	constabl__es
constipate	14	4	639	4	const_ipate_
constipated	16	4	546	4	const_ipated
constitutes	13	7	616	4	const_itutes
consulate	11	6	1223	4	cons__ulate_
consummates	17	5	420	4	cons_ummates
contemplate	17	5	520	4	con_template_
contemplated	19	5	444	4	con_templated
corelates	11	3	1486	4	co__re_lates
correlates	12	4	867	4	co_rre_lates
corselettes	13	5	299	4	cors_elettes
covellites	15	5	471	4	co__vellites
crystallites	17	14	390	4	crystallites
distillates	12	4	615	4	_distillates
oscillates	12	4	477	4	_o_scillates
postulates	12	6	896	4	po_st_ulates
scintillates	14	8	288	4	scin_tillates
stellate	8	3	1050	4	___stellate_
stellated	10	4	680	4	___stellated
stellites	9	3	812	4	___stellites
tessellates	11	6	246	4	_tessellates

Search took 8 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	52	6.923	18025.4
3	Display Results	52	52	0.030	1733.3
	(SQL Overall)	178691	52	7.343	24334.9