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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

129 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
defoliators	15	4	372	(None)
defoliator	14	4	418	1	defoliator_
defalcators	17	4	286	2	defalcators
deflators	13	34	815	2	def_l_ators
defoliates	14	4	633	2	defoliat_es
defoliations	16	4	759	2	defoliations
desolators	11	4	628	2	desol_ators
decorators	13	4	787	3	deco_rators
defalcator	16	4	317	3	defalcator_
defecators	16	5	625	3	def_ecators
deflaters	13	29	870	3	def_l_aters
deflator	12	32	834	3	def_l_ator_
deflectors	16	5	477	3	def_lectors
defoliants	14	4	293	3	defolia_nts
defoliate	13	4	699	3	defoliat__e
defoliated	15	4	583	3	defoliat_ed
defoliating	16	4	582	3	defoliating
defoliation	15	4	831	3	defoliation
delators	9	23	1482	3	de__l_ators
denominators	15	7	409	3	denominators
depilators	13	4	733	3	depil_ators
depositors	13	4	403	3	deposi_tors
desalinators	13	5	360	3	desalinators
desolaters	11	4	604	3	desol_aters
desolator	10	4	667	3	desol_ator_
detonators	11	4	585	3	deto_nators
deviators	13	5	853	3	de__viators
negotiators	12	5	316	3	negotiators
spoliators	12	4	482	3	_spoliators
collators	11	4	1034	4	__collators
deactivators	18	5	257	4	deactivators
deaerators	11	10	771	4	de_aerators
decaliters	13	4	521	4	decali_ters
decapitators	17	5	326	4	decapitators
decelerators	15	5	349	4	decelerators
deciliters	13	4	517	4	decili_ters
decimators	15	4	750	4	de_cimators
decollates	13	13	715	4	decollat_es
decollations	15	4	736	4	decollations
decolors	11	8	771	4	decol___ors
decorator	12	4	857	4	deco_rator_
decorticators	18	6	249	4	decorticators
dedicators	14	4	774	4	de_dicators
defalcates	16	4	454	4	defalcat_es
defalcations	18	4	519	4	defalcations
defamatory	19	4	348	4	def_amatory
defeaters	13	28	910	4	def__eaters
defecator	15	4	638	4	def_ecator_
defectors	15	23	788	4	def__ectors
deflater	12	32	1160	4	def_l_ater_
deflates	12	30	1394	4	def_l_at_es
deflations	14	3	971	4	def_l_ations
deflector	15	5	506	4	def_lector_
deflorations	16	4	606	4	deflorations
defoamers	15	28	525	4	defo__amers
defoliant	13	4	520	4	defolia__nt
deformations	18	4	684	4	deformations
dehydrators	19	5	285	4	dehydrators
dekaliters	15	4	341	4	dekali_ters
delator	8	30	1502	4	de__l_ator_
delegators	12	4	563	4	de_legators
delineators	12	5	396	4	delineators
demodulators	16	5	229	4	demodulators
demolishers	17	9	258	4	demolishers
demolitions	14	4	652	4	demolitions
denigrators	13	4	452	4	denigrators
denominator	14	10	471	4	denominator_
depictors	14	6	594	4	de__pictors
depilator	12	4	765	4	depil_ator_
depilatory	16	4	574	4	depil_atory
depositor	12	4	444	4	deposi_tor_
depository	16	5	325	4	deposi_tory
depreciators	17	5	390	4	depreciators
depredators	15	4	373	4	depredators
depurators	13	4	648	4	de_purators
derogatory	15	4	511	4	dero_gatory
desalinator	12	5	435	4	desalinator_
descriptors	16	5	275	4	descriptors
desecrators	14	4	523	4	desecrators
desiccators	16	4	380	4	desiccators
designators	13	4	430	4	designators
desolater	10	3	838	4	desol_ater_
desolates	10	3	1179	4	desol_at_es
desolations	12	3	1059	4	desol_ations
despoliations	16	4	639	4	despoliations
detonator	10	4	598	4	deto_nator_
devastators	15	5	292	4	devastators
deviator	12	4	831	4	de__viator_
deviatory	16	6	644	4	de__viatory
dilators	9	32	1319	4	d__il_ators
dominators	13	9	748	4	d__ominators
donators	9	3	1040	4	d__o_nators
duplicators	16	4	429	4	d_uplicators
emulators	11	4	818	4	_emul_ators
epilators	11	4	943	4	_epil_ators
evaluators	13	7	459	4	_evaluators
evocators	14	4	671	4	_evo_cators
exfoliates	20	6	370	4	exfoliat_es
exfoliations	22	4	478	4	exfoliations
expiators	18	4	680	4	_e_xpiators
explicators	22	4	471	4	_explicators
fellators	12	4	714	4	__fellators
foliates	11	4	1275	4	__foliat_es
foliations	13	9	994	4	__foliations
idolators	10	4	628	4	_idol_ators
immolators	14	4	427	4	immol_ators
inflators	12	5	771	4	inf_l_ators
inflictors	15	4	395	4	inf_lictors
isolators	9	4	751	4	_isol_ators
mediators	12	4	892	4	me__diators
negotiator	11	5	331	4	negotiator_
negotiatory	15	5	267	4	negotiatory
palliators	12	4	582	4	_palliators
peculators	14	8	698	4	pecul_ators
percolators	15	4	536	4	percol_ators
perforators	16	4	485	4	perfo_rators
perorators	12	4	935	4	pero_rators
reflectors	15	4	550	4	ref_lectors
reformatory	19	12	344	4	reformatory
regulators	11	4	650	4	regul_ators
relators	8	33	1612	4	re__l_ators
renovators	13	4	484	4	reno_vators
repudiators	14	5	352	4	repudiators
resonators	10	4	581	4	reso_nators
retaliatory	14	5	332	4	retaliatory
revelators	13	11	642	4	revel_ators
spoliator	11	4	484	4	_spoliator_
ventilators	14	10	506	4	ventilators
violators	12	4	658	4	_viol_ators

Search took 10 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.436	409841.7
2	DLD Change Limit	148819	129	8.516	17475.2
3	Display Results	129	129	0.063	2047.6
	(SQL Overall)	178691	129	9.015	19821.5