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

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

58 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
innovation	13	4	564	(None)
innovations	14	4	526	1	innovations
annotation	10	4	775	2	annotation
innervation	14	4	744	2	innervation
innovating	14	4	461	2	innovating
innovational	15	5	383	2	innovational
innovative	16	4	371	2	innovative
innovator	12	4	441	2	innovat_or
insolation	10	4	1021	2	insolation
intonation	10	4	1026	2	intonation
invocation	15	4	754	2	invocation
novation	11	17	1001	2	__novation
renovation	13	5	878	2	renovation
annexation	17	4	495	3	annexation
annotations	11	4	688	3	annotations
annulation	10	6	895	3	annulation
connotation	13	4	798	3	connotation
denotation	11	3	1108	3	denotation
enervation	13	6	947	3	enervation
immolation	14	4	610	3	immolation
incitation	12	3	1222	3	incitation
incubation	14	4	836	3	incubation
incurvation	16	4	698	3	incurvation
indagation	12	4	615	3	indagation
indexation	18	4	634	3	indexation
indication	13	3	1203	3	indication
induration	11	4	1061	3	induration
infixation	20	4	753	3	infixation
inflation	12	3	1109	3	i_nflation
information	16	14	771	3	information
inhalation	13	10	766	3	inhalation
inhumation	15	6	705	3	inhumation
initiation	10	4	1210	3	initiation
innervations	15	4	692	3	innervations
innovate	11	4	564	3	innovat__e
innovated	13	4	457	3	innovat_ed
innovates	12	4	552	3	innovat_es
innovators	13	4	414	3	innovators
innovatory	16	5	316	3	innovatory
insolations	11	4	918	3	insolations
insulation	10	3	1166	3	insulation
intimation	12	4	1304	3	intimation
intonations	11	4	952	3	intonations
intubation	12	4	777	3	intubation
inundation	11	11	617	3	inundation
invasion	11	11	547	3	i_n_vasion
invitation	13	4	1002	3	invitation
invocations	16	4	706	3	invocations
involution	13	4	594	3	involution
iodation	9	3	1038	3	i__odation
ionization	19	4	1127	3	ionization
isolation	9	3	1164	3	i_solation
nervation	12	6	1024	3	_nervation
notation	8	14	1460	3	__notation
novations	12	13	900	3	__novations
ovation	10	15	1002	3	___ovation
pinnation	11	3	801	3	pinn__ation
renovations	14	4	842	3	renovations

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.436	409841.7
2	DLD Change Limit	140603	58	7.190	19555.4
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	7.656	23340.0