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

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

128 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
deactivation	18	15	608	(None)
deactivations	19	17	506	1	deactivations
reactivation	17	17	695	1	reactivation
activation	15	6	1013	2	__activation
deactivating	19	5	345	2	deactivating
deactivator	17	5	284	2	deactivat_or
inactivation	17	4	509	2	inactivation
reactivations	18	17	614	2	reactivations
activations	16	6	926	3	__activations
aestivation	14	4	792	3	ae_stivation
captivation	18	4	617	3	_captivation
deactivate	16	4	462	3	deactivat__e
deactivated	18	4	373	3	deactivat_ed
deactivates	17	4	439	3	deactivat_es
deactivators	18	5	257	3	deactivators
deamination	14	4	1154	3	dea_mination
decapitation	17	4	868	3	decapitation
decimation	15	4	1162	3	de_c_imation
declination	14	4	1187	3	de_clination
deprivation	17	8	877	3	de_privation
deputization	24	4	721	3	deputization
deracination	15	4	886	3	derac_ination
derivation	14	7	1278	3	de__rivation
destination	12	4	1383	3	de_stination
estivation	13	4	981	3	_e_stivation
inactivations	18	5	424	3	inactivations
jactitation	20	4	562	3	_jactitation
pectination	15	4	1033	3	pe_ctination
reactivating	18	4	475	3	reactivating
remotivation	17	4	742	3	remotivation
activating	16	4	785	4	__activating
activator	14	4	644	4	__activat_or
actuation	11	3	1033	4	__act_uation
aestivations	15	4	748	4	ae_stivations
brachiation	18	15	408	4	brachi_ation
captivations	19	4	534	4	_captivations
castigation	14	4	797	4	_castigation
coacervation	19	6	427	4	coacervation
cultivation	16	11	641	4	_cultivation
deaeration	11	3	1301	4	dea__eration
dealation	10	3	1300	4	dea___lation
deaminations	15	10	1012	4	dea_minations
debilitation	15	4	778	4	debilitation
decantation	14	4	894	4	de_cantation
decapitations	18	4	765	4	decapitations
decimations	16	4	1015	4	de_c_imations
declamation	16	4	610	4	de_clamation
declaration	14	4	783	4	de_claration
declinations	15	4	1021	4	de_clinations
decollation	14	4	819	4	de_collation
decoration	13	3	1440	4	de_c_oration
decortication	18	5	753	4	decortication
decussation	14	4	430	4	de_cussation
dedication	14	3	1196	4	de__dication
defoliation	15	4	831	4	defoli_ation
deglaciation	16	5	430	4	deglac_i_ation
deification	17	4	1166	4	de_ification
deionization	22	4	987	4	deionization
delamination	15	4	885	4	delamination
delectation	14	4	855	4	delect__ation
delimitation	15	9	726	4	delimitation
demonization	24	4	1093	4	demonization
denaturation	13	4	588	4	denaturation
denervation	15	6	794	4	de_nervation
denomination	15	11	882	4	denomination
denotation	11	3	1108	4	denot__ation
dentation	10	3	1523	4	de_nt__ation
dentition	10	4	963	4	de_nti__tion
deoxidation	20	4	595	4	de_oxidation
depilation	13	3	1203	4	de__pilation
depravation	17	8	569	4	de_pravation
deprivations	18	9	791	4	de_privations
deputation	13	3	939	4	deput__ation
deputizations	25	4	673	4	deputizations
deracinations	16	4	781	4	derac_inations
derivations	15	6	1148	4	de__rivations
desalination	13	4	1112	4	desalination
description	16	4	537	4	descri_ption
destinations	13	4	1265	4	de_stinations
destitution	12	5	554	4	de_stitution
detonation	11	3	1094	4	de__tonation
detoxication	22	4	620	4	detoxication
deuteration	12	4	910	4	de_uteration
devastation	15	4	673	4	devast__ation
deviation	13	3	1239	4	de__vi_ation
diazotization	22	6	430	4	diazotization
dictation	12	8	1056	4	d_ict__ation
digitization	23	4	767	4	digitization
dramatisation	16	7	301	4	dramatisation
dramatization	25	7	619	4	dramatization
emaciation	14	4	927	4	emac_i_ation
erotization	20	4	1205	4	_erotization
estimation	12	4	1084	4	_e_stimation
estivations	14	4	927	4	_e_stivations
excavation	22	4	543	4	_exc_avation
excitation	19	4	1017	4	_exc_itation
fractionation	18	5	320	4	fractionation
glaciation	13	4	658	4	glac_i_ation
idealization	22	4	1026	4	idea_lization
inactivating	18	5	346	4	inactivating
jactation	18	3	814	4	_jact__ation
jactitations	21	4	501	4	_jactitations
lacrimation	15	4	626	4	_lacrimation
lactation	11	3	1081	4	_lact__ation
legitimation	15	5	516	4	legitimation
machination	18	10	682	4	_machination
mastication	15	6	1029	4	_mastication
motivation	15	4	808	4	__motivation
negotiation	12	4	577	4	negoti_ation
passivation	16	10	474	4	_passivation
patination	12	3	1257	4	_pa_tination
pectinations	16	4	925	4	pe_ctinations
quantitation	21	5	364	4	quantitation
quantization	30	5	504	4	quantization
reactivate	15	4	584	4	reactivat__e
reactivated	17	4	497	4	reactivat_ed
reactivates	16	4	561	4	reactivat_es
reactivities	17	5	616	4	reactivities
realization	20	4	1721	4	rea_lization
reanimation	13	5	963	4	rea_nimation
recitation	12	3	1594	4	re_c_itation
remotivations	18	4	668	4	remotivations
revaccination	20	5	386	4	revaccination
salivation	13	4	981	4	_sa_livation
satiation	9	3	1342	4	_sa_ti_ation
titivation	13	4	703	4	__titivation
vaccination	18	4	645	4	_vaccination
ventilation	14	4	816	4	ve_ntilation

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.170	1051123.5
2	DLD Change Limit	124790	128	8.500	14681.2
3	Display Results	128	128	0.080	1600.0
	(SQL Overall)	178691	128	8.750	20421.8