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

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

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.

77 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
renovation	13	5	878	(None)
renovations	14	4	842	1	renovations
denotation	11	3	1108	2	denotation
innovation	13	4	564	2	innovation
novation	11	17	1001	2	__novation
relocation	12	3	1211	2	relocation
renovating	14	4	742	2	renovating
renovative	16	4	543	2	renovative
renovator	12	4	490	2	renovat_or
revocation	15	4	1081	2	revocation
annotation	10	4	775	3	annotation
crenation	11	4	1292	3	cren__ation
crenelation	13	4	685	3	crenelation
crenulation	13	4	757	3	crenulation
decoration	13	3	1442	3	decoration
denegation	12	4	941	3	denegation
denervation	15	6	794	3	denervation
denotations	12	3	985	3	denotations
dentation	10	3	1524	3	den_tation
denudation	12	4	730	3	denudation
derivation	14	7	1278	3	derivation
derogation	12	4	1039	3	derogation
desolation	11	3	1140	3	desolation
detonation	11	3	1094	3	detonation
elevation	12	3	923	3	_elevation
enation	7	34	1923	3	_en__ation
enervation	13	6	947	3	_enervation
evocation	14	20	1029	3	_evocation
generation	11	3	1242	3	generation
innovations	14	4	526	3	innovations
mentation	11	3	1398	3	men_tation
nervation	12	6	1024	3	ne_rvation
notation	8	14	1460	3	__notation
novations	12	13	900	3	__novations
ovation	10	15	1002	3	___ovation
peroration	12	3	1600	3	peroration
prenotion	11	4	917	3	preno__tion
reanimation	13	5	963	3	reanimation
recitation	12	3	1594	3	recitation
recordation	14	4	926	3	recordation
recreation	12	4	1361	3	recreation
reflation	12	4	1233	3	re_flation
reformation	16	4	841	3	reformation
refutation	13	4	991	3	refutation
regulation	11	3	1205	3	regulation
reinflation	14	4	720	3	reinflation
reinvasion	13	4	301	3	reinvasion
relation	8	26	1977	3	re__lation
relaxation	17	4	645	3	relaxation
relegation	11	6	1002	3	relegation
relocations	13	3	1114	3	relocations
remotion	10	4	1023	3	remo__tion
remotivation	17	4	743	3	remotivation
rendition	10	5	893	3	ren_dition
renomination	14	9	918	3	renomination
renovate	11	3	855	3	renovat__e
renovated	13	4	717	3	renovat_ed
renovates	12	4	845	3	renovat_es
renovators	13	4	484	3	renovators
reparation	12	6	1272	3	reparation
reposition	12	10	1014	3	reposition
reprobation	15	4	850	3	reprobation
reputation	12	4	1188	3	reputation
reservation	14	8	914	3	reservation
resolution	10	9	773	3	resolution
resorption	12	4	725	3	resorption
restation	9	3	1691	3	re_station
restoration	11	4	1209	3	restoration
retortion	9	4	967	3	reto_rtion
revelation	13	4	1092	3	revelation
revocations	16	4	1031	3	revocations
revolution	13	11	756	3	revolution
rogation	9	16	1205	3	r__ogation
rotation	8	16	1545	3	r__otation
sensation	9	5	1058	3	sen_sation
venation	11	5	1350	3	ven__ation
veneration	13	4	1234	3	veneration

Search took 8 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.403	443402.0
2	DLD Change Limit	140603	77	6.910	20347.8
3	Display Results	77	77	0.043	1790.7
	(SQL Overall)	178691	77	7.356	24291.9