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

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

89 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
desalinator	12	5	435	(None)
desalinators	13	5	360	1	desalinators
desalinate	11	4	667	2	desalinat_e
desalinated	13	4	577	2	desalinated
desalinates	12	4	621	2	desalinates
desalination	13	4	1113	2	desalination
decapitator	16	5	380	3	decapitator
defalcator	16	4	317	3	defal_cator
defoliator	14	4	418	3	defoli_ator
delineator	11	7	417	3	de__lineator
denominator	14	10	471	3	denominator
desalinating	14	7	631	3	desalinating
desalinations	14	4	1018	3	desalinations
designator	12	4	471	3	des_ignator
desolator	10	4	667	3	desol__ator
salivator	12	13	611	3	__salivator
alienator	9	4	619	4	___alienator
assassinator	12	6	137	4	assassinator
deactivator	17	5	284	4	deactivator
deaerator	10	12	811	4	de_a_erator
deaminate	12	4	1017	4	de_aminat_e
deaminated	14	4	801	4	de_aminated
deaminates	13	4	938	4	de_aminates
deamination	14	4	1154	4	de_amination
decaliter	12	4	798	4	decali__ter
decapitators	17	5	326	4	decapitators
decelerator	14	5	399	4	decelerator
decimator	14	4	773	4	de__cimator
declination	14	4	1187	4	de_clination
dedicator	13	4	825	4	de__dicator
defalcators	17	4	286	4	defal_cators
deflator	12	32	834	4	de_fl__ator
defoliators	15	4	372	4	defoli_ators
dekaliter	14	4	506	4	dekali__ter
delaminate	13	4	737	4	delaminat_e
delaminated	15	4	578	4	delaminated
delaminates	14	5	690	4	delaminates
delamination	15	4	885	4	delamination
delator	8	30	1502	4	de__l__ator
delegator	11	4	624	4	de__legator
delineators	12	5	396	4	de__lineators
denominators	15	7	409	4	denominators
depilator	12	4	765	4	de__pilator
deracinate	13	5	656	4	deracinat_e
deracinated	15	4	486	4	deracinated
deracinates	14	4	586	4	deracinates
deracination	15	4	886	4	deracination
desalinization	24	5	561	4	desalinization
desalinize	20	4	432	4	desalin_ize
desalinized	22	5	389	4	desalinized
desalinizes	21	4	414	4	desalinizes
desalter	9	3	836	4	desal___ter
descriptor	15	5	297	4	descri_ptor
desecrator	13	4	600	4	des_ecrator
desiccator	15	4	399	4	des_iccator
designators	13	4	430	4	des_ignators
designatory	16	5	338	4	des_ignatory
desolater	10	3	838	4	desol__ater
desolators	11	4	628	4	desol__ators
destination	12	4	1384	4	des_tination
determinator	15	5	457	4	determinator
detonator	10	4	598	4	de__tonator
devastator	14	5	314	4	deva_stator
deviator	12	4	831	4	de__vi_ator
disseminator	15	5	351	4	disseminator
dominator	12	5	823	4	d__ominator
duplicator	15	4	480	4	d_uplicator
eliminator	12	4	512	4	_eliminator
emanator	10	4	729	4	_ema__nator
eradicator	13	4	557	4	_eradicator
escalator	11	4	568	4	_escal__ator
estimator	11	4	742	4	_es_timator
estivator	12	4	629	4	_es_tivator
evaluator	12	10	496	4	_eval_uator
explicator	21	4	515	4	_explicator
fascinator	15	4	521	4	fas_cinator
hesitator	12	8	602	4	hes__itator
inseminator	13	5	424	4	inseminator
invalidator	15	5	319	4	invalidator
laminator	11	4	755	4	__laminator
pollinator	12	4	477	4	_pollinator
resonator	9	4	636	4	res__onator
respirator	12	6	573	4	res_pirator
retaliatory	14	5	332	4	retali_atory
salivators	13	13	575	4	__salivators
supinator	11	4	586	4	__supinator
terminator	12	4	663	4	te_rminator
totalisator	11	5	210	4	totalisator
totalizator	20	5	239	4	totalizator

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.423	422437.4
2	DLD Change Limit	148819	89	9.110	16335.8
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	9.579	18654.5