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

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

73 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
deviance	14	7	708	(None)
defiance	14	7	763	1	defiance
deviances	15	6	649	1	deviances
deviancy	17	5	418	1	deviancy
defiances	15	5	703	2	defiances
deviancies	16	4	459	2	deviancies
deviant	11	3	1131	2	devian_t
deviants	12	3	673	2	deviants
deviate	11	3	1271	2	devia_te
device	12	45	1216	2	devi__ce
evince	11	3	776	2	_evi_nce
reliance	10	3	1047	2	reliance
advance	13	4	604	3	adv_ance
affiance	16	4	565	3	affiance
alliance	10	9	726	3	alliance
ambiance	14	4	606	3	ambiance
bechance	17	4	773	3	bechance
dalliance	12	4	420	3	dalliance
dance	8	52	2313	3	d___ance
decane	9	38	1887	3	de_can_e
deciare	10	7	1066	3	decia_re
deface	12	31	1386	3	de_fa_ce
defence	13	3	989	3	de_fence
defiant	11	3	1192	3	defian_t
define	10	47	1814	3	defi_n_e
dehisce	13	10	427	3	dehi_sce
deice	8	43	2003	3	de_i__ce
delaine	8	3	1479	3	delain_e
deniable	11	3	1208	3	deniable
denounce	11	4	510	3	denounce
deplane	10	3	1141	3	deplan_e
derange	9	3	981	3	de_range
designee	10	8	775	3	designee
desinence	12	5	750	3	desinence
desistance	13	4	458	3	desistance
detainee	9	25	1172	3	detainee
detinue	8	50	1003	3	deti_nue
devalue	11	3	601	3	dev_alue
deviated	13	3	1104	3	deviated
deviates	12	3	1273	3	deviates
deviative	16	4	772	3	deviative
deviator	12	4	831	3	deviator
devices	13	32	1258	3	devi__ces
devisable	15	4	685	3	devisable
devise	10	42	1575	3	devi__se
devisee	11	38	1271	3	devi_see
devoice	13	34	734	3	dev_oice
dezinc	18	3	605	3	dezi_nc_
dezinced	21	8	390	3	dezi_nced
dezincs	19	3	375	3	dezi_ncs
distance	11	3	1185	3	distance
divine	10	35	1446	3	divi_n_e
dominance	14	4	621	3	dominance
durance	10	5	911	3	d_urance
enhance	12	3	969	3	_enhance
evidence	14	4	655	3	_evidence
evinced	13	3	540	3	_evi_nced
evinces	12	3	780	3	_evi_nces
feasance	13	4	582	3	feasance
fiance	11	3	1074	3	__fiance
hesitance	14	4	555	3	hesitance
lenience	10	4	833	3	lenience
leviable	13	3	751	3	leviable
penance	11	3	1344	3	pe_nance
radiance	11	4	812	3	radiance
refinance	14	11	764	3	refinance
reliances	11	3	962	3	reliances
revanche	16	4	500	3	rev_anche
seance	8	37	1668	3	se__ance
severance	14	4	732	3	severance
tendance	11	4	752	3	tendance
valiance	13	9	738	3	valiance
variance	13	9	741	3	variance

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	146162	0.406	440125.6
2	DLD Change Limit	146162	73	6.376	22923.8
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	6.812	26231.8