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

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

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

119 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
decoration	13	3	1442	(None)
decorations	14	3	1288	1	decorations
deaeration	11	3	1301	2	deaeration
decimation	15	4	1162	2	decimation
declaration	14	4	783	2	declaration
decoction	14	4	752	2	deco_ction
decollation	14	4	819	2	decollation
decorating	14	3	1207	2	decorating
decorative	16	4	892	2	decorative
decorator	12	4	857	2	decorat_or
defloration	15	4	726	2	defloration
deformation	17	4	766	2	deformation
denotation	11	3	1108	2	denotation
deportation	14	4	930	2	deportation
derogation	12	4	1039	2	derogation
desolation	11	3	1140	2	desolation
desorption	13	4	622	2	desorption
detonation	11	3	1094	2	detonation
peroration	12	3	1600	2	peroration
recordation	14	4	926	2	recordation
redecoration	15	4	601	2	redecoration
adoration	10	3	1131	3	_adoration
aeration	8	3	1993	3	ae__ration
coloration	12	9	1318	3	coloration
conation	10	14	2088	3	__conation
deaerations	12	3	1167	3	deaerations
dealation	10	3	1300	3	de_alation
debarkation	18	4	424	3	debarkation
decantation	14	4	894	3	decantation
deceleration	15	4	717	3	deceleration
deception	14	4	832	3	dec_eption
decimations	16	4	1016	3	decimations
declamation	16	4	610	3	declamation
declarations	15	4	680	3	declarations
declination	14	4	1187	3	declination
decoctions	15	4	714	3	deco_ctions
decollations	15	4	736	3	decollations
decondition	15	4	541	3	decondition
decorate	11	3	1519	3	decorat__e
decorated	13	3	1220	3	decorat_ed
decorates	12	3	1474	3	decorat_es
decorators	13	4	787	3	decorators
decortication	18	5	753	3	decor~~tic~~ation
decryption	18	4	373	3	decryption
decurion	11	4	662	3	decur__ion
decussation	14	4	430	3	decussation
dedication	14	3	1196	3	dedication
defamation	16	4	684	3	defamation
defecation	16	7	980	3	defecation
deflation	13	3	1065	3	de_flation
deflorations	16	4	606	3	deflorations
defoliation	15	4	831	3	defoliation
deformations	18	4	684	3	deformations
dehydration	19	5	406	3	dehydration
delation	9	23	1808	3	de__lation
delegation	12	3	888	3	delegation
demarcation	16	4	702	3	demarcation
demolition	13	7	698	3	demolition
demotion	11	6	907	3	demo__tion
denegation	12	4	941	3	denegation
denervation	15	6	794	3	denervation
denigration	13	4	846	3	denigration
denotations	12	3	985	3	denotations
dentation	10	3	1524	3	de_ntation
denudation	12	4	730	3	denudation
depilation	13	3	1203	3	depilation
deportations	15	4	846	3	deportations
deposition	13	10	783	3	deposition
deputation	13	3	939	3	deputation
derivation	14	7	1278	3	derivation
derogations	13	4	939	3	derogations
desecration	14	4	1007	3	desecration
desertion	10	4	1020	3	deser_tion
desolations	12	3	1059	3	desolations
desorptions	14	4	599	3	desorptions
desperation	14	5	1011	3	desperation
detonations	12	3	937	3	detonations
detraction	13	13	858	3	de_traction
detrition	10	4	913	3	de_trition
deuteration	12	4	910	3	deuteration
deviation	13	3	1239	3	de_viation
devolution	14	8	628	3	devolution
devotion	12	5	676	3	devo__tion
dictation	12	8	1056	3	dic_tation
donation	9	15	1378	3	d__onation
dotation	9	14	1273	3	d__otation
duration	9	3	1269	3	d__uration
evocation	14	20	1029	3	_evocation
excoriation	20	4	843	3	excoriation
execration	19	4	983	3	exec_ration
federation	14	4	957	3	federation
generation	11	3	1242	3	generation
laceration	12	4	957	3	laceration
maceration	14	4	961	3	maceration
melioration	13	6	818	3	melioration
mercuration	15	4	749	3	mercuration
oration	7	16	1771	3	___oration
peculation	14	3	1199	3	peculation
percolation	15	4	922	3	percolation
perforation	16	4	900	3	perforation
perorations	13	3	1406	3	perorations
proration	11	4	1598	3	_proration
recitation	12	3	1594	3	recitation
recordations	15	4	864	3	recordations
recreation	12	4	1361	3	recreation
redecorations	16	4	508	3	redecorations
reformation	16	4	841	3	reformation
relocation	12	3	1211	3	relocation
renovation	13	5	878	3	renovation
reparation	12	6	1272	3	reparation
resorption	12	4	725	3	resorption
restoration	11	4	1209	3	restoration
retortion	9	4	967	3	retor_tion
revocation	15	4	1081	3	revocation
secretion	11	11	830	3	sec_retion
separation	12	5	1043	3	separation
serration	9	4	1406	3	se_rration
ulceration	12	4	726	3	ulceration
veneration	13	4	1234	3	veneration

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	140603	0.406	440125.6
2	DLD Change Limit	140603	119	5.690	24710.5
3	Display Results	119	119	0.060	1983.3
	(SQL Overall)	178691	119	6.156	29027.1