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

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

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.

84 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
dermabrasions	18	6	84	(None)
dermabrasion	17	6	89	1	dermabrasion_
abrasions	11	4	581	4	____abrasions
cerebrations	16	4	696	4	cer_ebrations
deaerations	12	3	1167	4	de__aerations
declarations	15	4	680	4	decla_rations
deflagrations	18	8	302	4	deflagrations
demarcations	17	4	612	4	de_marcations
abrasion	10	4	662	5	____abrasion_
adumbrations	17	5	229	5	adum_brations
celebrations	16	4	574	5	ce_lebrations
cerebration	15	4	792	5	cer_ebration_
corrasions	12	4	635	5	cor___rasions
deaeration	11	3	1301	5	de__aeration_
dealations	11	3	1137	5	de__a_lations
deaminations	15	10	1013	5	deam_inations
debarkations	19	4	365	5	de_barkations
decantations	15	4	794	5	de_cantations
decelerations	16	4	642	5	decelerations
decerebrations	19	9	374	5	decerebrations
declamations	17	4	530	5	decla_mations
declaration	14	4	783	5	decla_ration_
decorations	14	3	1288	5	de__corations
defalcations	18	4	519	5	de_falcations
defamations	17	4	589	5	de_fa_mations
deflagration	17	7	347	5	deflagration_
deflorations	16	4	606	5	de_florations
degenerations	15	4	635	5	degenerations
deglaciations	17	5	391	5	deglaciations
degradations	15	4	455	5	degra_dations
dehydrations	20	4	340	5	de_hydrations
delaminations	16	4	794	5	delaminations
deliberations	16	4	553	5	deliberations
demarcation	16	4	702	5	de_marcation_
demissions	13	4	566	5	de_m__issions
denaturations	14	4	495	5	denaturations
denigrations	14	4	735	5	de_nigrations
depravations	18	8	537	5	depra_vations
deracinations	16	4	783	5	deracinations
derealizations	24	9	1081	5	derealizations
deregulations	15	4	520	5	deregulations
derepressions	16	5	307	5	derepressions
derisions	10	3	884	5	de____risions
derivations	15	6	1149	5	der__ivations
dermatosis	13	5	494	5	derma_tosi__s
derogations	13	4	939	5	der__ogations
desecrations	15	5	921	5	de_secrations
desiderations	15	4	567	5	desiderations
desperations	15	5	952	5	de_sperations
detrusions	11	4	421	5	de___trusions
deuterations	13	4	808	5	de_uterations
devaluations	16	4	635	5	de_valuations
devastations	16	4	582	5	de_vastations
elaborations	14	4	492	5	_e_laborations
emaciations	15	4	816	5	_e_maciations
emanations	12	8	959	5	_e_ma_nations
embarkations	20	6	225	5	_e_mbarkations
emersions	11	4	728	5	_e_m_er_sions
emigrations	14	18	715	5	_e_migrations
erasions	8	3	1098	5	_e____rasions
fermentations	18	5	627	5	fermentations
germanizations	26	16	683	5	germanizations
germinations	15	13	794	5	germ_inations
mercurations	16	4	656	5	mer_curations
perambulations	20	5	307	5	perambulations
perforations	17	4	787	5	per_forations
permeations	15	4	988	5	perm__eations
permissions	15	4	533	5	perm__issions
permutations	16	4	650	5	perm_utations
perorations	13	3	1406	5	per__orations
perpetrations	17	4	637	5	perpetrations
perspirations	17	8	617	5	perspirations
persuasions	13	8	391	5	per__suasions
perturbations	17	12	326	5	perturbations
pervasions	15	4	566	5	per___vasions
perversions	16	4	541	5	per_ver_sions
preparations	16	4	831	5	prepa_rations
remigrations	15	22	779	5	re_migrations
reparations	13	6	1166	5	re_pa_rations
reradiations	13	4	949	5	rer_adiations
separations	13	6	927	5	se_pa_rations
serrations	10	3	1310	5	ser___rations
terminations	14	14	976	5	term_inations
trabeations	13	4	537	5	_tr_abeations

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.406	440125.6
2	DLD Change Limit	124790	84	8.296	15042.2
3	Display Results	84	84	0.063	1333.3
	(SQL Overall)	178691	84	8.765	20386.9