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

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

114 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
redecorations	16	4	508	(None)
redecoration	15	4	601	1	redecoration_
decorations	14	3	1288	2	__decorations
redecorating	16	11	505	2	redecorati_ng
redecorators	15	5	266	2	redecorat_ors
decoration	13	3	1442	3	__decoration_
desecrations	15	5	921	3	desec_rations
execrations	20	4	892	3	_exec_rations
federations	15	4	888	3	fede__rations
overdecorations	21	6	372	3	overdecorations
recordations	15	4	864	3	r__ecordations
redecorates	14	6	568	3	redecorat__es
redecorator	14	5	298	3	redecorat_o_r
rededications	17	4	612	3	rededications
regenerations	14	4	714	3	regenerations
restorations	12	4	1095	3	re_storations
adorations	11	3	1023	4	_ad__orations
celebrations	16	4	574	4	cele_brations
cerebrations	16	4	696	4	cere_brations
deaerations	12	3	1167	4	__deaerations
decelerations	16	4	642	4	decelerations
decimations	16	4	1016	4	__decimations
declarations	15	4	680	4	__declarations
decoctions	15	4	714	4	__deco_ctions
decollations	15	4	736	4	__decollations
decorating	14	3	1207	4	__decorati_ng
decorators	13	4	787	4	__decorat_ors
dedications	15	3	1087	4	dedic__ations
defecations	17	7	900	4	defec__ations
deflorations	16	4	606	4	de_florations
deformations	18	4	684	4	__deformations
degenerations	15	4	635	4	degenerations
delectations	15	4	745	4	delec_tations
denotations	12	3	985	4	__denotations
deportations	15	4	846	4	__deportations
derogations	13	4	939	4	__derogations
desecration	14	4	1007	4	desec_ration_
desolations	12	3	1059	4	__desolations
desorptions	14	4	599	4	__desorptions
deteriorations	15	16	469	4	deteriorations
detonations	12	3	937	4	__detonations
educations	13	3	923	4	_educ__ations
elaborations	14	4	492	4	_elaborations
evaporations	17	4	469	4	_evaporations
excoriations	21	4	752	4	_e_xcoriations
execration	19	4	983	4	_exec_ration_
expectorations	25	5	219	4	expectorations
explorations	21	8	561	4	_explorations
federation	14	4	957	4	fede__ration_
fenestrations	16	9	540	4	fenestrations
generations	12	3	1142	4	gene__rations
medications	16	4	993	4	medic__ations
meliorations	14	6	675	4	me_liorations
mercurations	16	4	656	4	me_rcurations
moderations	14	4	827	4	mode__rations
overdecoration	20	6	394	4	overdecoration_
penetrations	14	4	885	4	pene_trations
percolations	16	4	805	4	pe_rcolations
perforations	17	4	787	4	pe_rforations
perorations	13	3	1406	4	__perorations
predications	17	4	1118	4	predic__ations
reallocations	15	5	380	4	reallocations
reapportions	16	5	365	4	reappor_tions
recitations	13	3	1420	4	r__ecitations
recordation	14	4	926	4	r__ecordation_
recreations	13	4	1225	4	r__ecreations
recuperations	17	4	608	4	recuperations
redactions	13	5	913	4	redac___tions
redecorate	13	4	614	4	redecorat___e
redecorated	15	4	496	4	redecorat__ed
rededication	16	4	650	4	rededication_
redefinitions	17	5	233	4	redefinitions
redemptions	16	4	373	4	rede__mptions
redescriptions	19	6	278	4	redescriptions
reductions	13	5	958	4	reduc___tions
reeducations	15	4	547	4	re_educations
reescalations	15	7	378	4	reescalations
reexportations	23	5	284	4	reexportations
refections	15	18	1164	4	refec___tions
reformations	17	4	760	4	r__eformations
regeneration	13	4	819	4	regeneration_
registrations	14	4	689	4	registrations
rehydrations	19	4	398	4	re_hydrations
reimportations	18	11	359	4	reimportations
reincarnations	16	7	278	4	reincarnations
reiterations	12	4	1087	4	re_iterations
rejections	19	15	1010	4	rejec___tions
relegations	12	4	897	4	rele__gations
relocations	13	3	1114	4	r__elocations
reluctations	14	4	675	4	reluc_tations
remediations	15	4	827	4	reme_diations
remigrations	15	22	779	4	re_migrations
remunerations	15	5	620	4	remunerations
renaturations	13	5	596	4	renaturations
renegotiations	15	11	337	4	renegotiations
renovations	14	4	842	4	r__enovations
reoccupations	19	7	276	4	reoccupations
reoperations	14	4	1006	4	re_operations
reparations	13	6	1166	4	r__eparations
reprobations	16	4	777	4	re_probations
reregulations	14	5	571	4	reregulations
resections	12	15	1303	4	resec___tions
reservations	15	8	858	4	rese_rvations
resorptions	13	4	723	4	r__esorptions
respirations	14	4	1030	4	re_spirations
restoration	11	4	1209	4	re_storation_
reticulations	15	5	661	4	reticulations
retortions	10	4	914	4	r__etor_tions
revegetations	17	11	471	4	revegetations
revelations	14	4	1030	4	reve__lations
reverberations	19	11	358	4	reverberations
revocations	16	4	1031	4	r__evocations
teleportations	16	5	182	4	teleportations
venerations	14	4	1131	4	vene__rations

Search took 7 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	95024	0.356	501941.0
2	DLD Change Limit	95024	114	5.813	16346.8
3	Display Results	114	114	0.080	1425.0
	(SQL Overall)	178691	114	6.249	28595.1