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

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

61 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
capacitated	18	5	245	(None)
capacitate	16	5	345	1	capacitate_
capacitates	17	5	301	1	capacitates
capitated	14	15	904	2	cap__itated
incapacitated	20	9	160	2	incapacitated
capacitance	16	5	190	3	capacitance
capacitances	17	5	194	3	capacitances
capacitating	19	5	255	3	capacitating
capacitation	18	5	416	3	capacitation
capacities	16	4	769	3	capacit_ies
capacitive	19	5	315	3	capacitive_
capitate	12	17	1218	3	cap__itate_
captivated	18	4	476	3	cap_tivated
cavitated	15	17	735	3	c__avitated
incapacitate	18	9	181	3	incapacitate_
incapacitates	19	9	175	3	incapacitates
acetated	11	20	1068	4	___acetated
agitated	10	3	841	4	___agitated
apocopated	17	5	355	4	_apocopated
caffeinated	20	5	204	4	caffeinated
calculated	15	7	780	4	ca_lculated
capacitations	19	5	362	4	capacitations
capacitively	24	5	211	4	capacitively
capacitor	15	4	347	4	capaci__tor
capacitors	16	4	358	4	capacit_ors
capacity	17	4	602	4	capaci__t_y
caparisoned	16	9	175	4	caparisoned
capitulated	16	4	415	4	capitulated
capsulated	15	4	565	4	cap_sulated
captivate	16	4	592	4	cap_tivate_
captivates	17	4	549	4	cap_tivates
carinated	12	34	1426	4	c__arinated
castigated	14	4	632	4	ca_stigated
cavitate	13	15	983	4	c__avitate_
cavitates	14	16	896	4	c__avitates
cogitated	13	4	632	4	c__ogitated
copycatted	20	5	157	4	copycat_ted
crepitated	15	8	474	4	c_repitated
decapitated	17	4	494	4	decapitated
deracinated	15	4	486	4	deracinated
emaciated	14	4	693	4	_emaci_ated
expatiated	20	4	420	4	expati_ated
facilitated	17	5	364	4	facilitated
fasciated	15	4	613	4	fa_sci_ated
fascinated	16	4	587	4	fa_scinated
felicitated	17	4	356	4	felicitated
glaciated	13	6	575	4	_glaci_ated
gravitated	15	4	413	4	_gravitated
habilitated	17	8	293	4	habilitated
lactated	11	3	886	4	__lac_tated
lancinated	13	4	557	4	la_ncinated
lapidated	13	4	567	4	lap__idated
paginated	13	30	946	4	__paginated
palpitated	15	4	423	4	pa_lpitated
patinated	12	39	1141	4	__patinated
rapacities	14	4	654	4	rapacit_ies
sanitated	10	6	899	4	__sanitated
speciated	14	20	754	4	_speci_ated
spectated	14	23	659	4	_spec_tated
vaccinated	18	5	544	4	va_ccinated
vaticinated	17	5	343	4	vaticinated

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	148819	0.423	422437.4
2	DLD Change Limit	148819	61	8.313	17902.0
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	8.766	20384.6