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

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

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

105 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
fesse	8	61	1633	(None)
fease	8	48	2487	1	fease
fess	7	65	2916	1	fess_
fessed	10	45	1506	1	fessed
fesses	9	48	2025	1	fesses
fosse	8	61	1946	1	fosse
jesse	12	60	1283	1	jesse
beses	7	58	3072	2	beses
cease	7	52	2765	2	cease
cense	7	51	2140	2	cense
cess	6	53	2605	2	cess_
cessed	9	46	1561	2	cessed
cesses	8	42	2136	2	cesses
dense	6	59	2350	2	dense
ease	4	50	4233	2	_ease
else	4	59	2308	2	_else
eses	4	53	3610	2	_eses
esne	4	70	1879	2	_esne
ess	3	60	3088	2	_ess_
esses	5	64	2297	2	_esses
false	8	48	1812	2	false
feased	10	57	1871	2	feased
feases	9	54	2292	2	feases
feast	8	59	3272	2	feast
feaze	17	52	1631	2	feaze
feces	10	56	2536	2	feces
feds	8	52	3432	2	feds_
fee	6	68	6201	2	fe__e
fees	7	64	5060	2	fees_
feeze	17	49	1382	2	feeze
fehs	10	65	2238	2	fehs_
feist	8	62	3007	2	feist
feme	9	61	3054	2	fe_me
femes	10	56	2622	2	femes
femme	12	50	1143	2	femme
fems	9	64	2870	2	fems_
fence	10	53	1991	2	fence
fens	7	61	3976	2	fens_
fere	7	63	4223	2	fe_re
feres	8	60	3818	2	feres
fes	6	65	5167	2	fe_s_
fescue	11	3	749	2	fescue
fest	7	49	4944	2	fe_st
fester	9	47	2351	2	fester
fests	8	58	2804	2	fests
fete	7	57	3492	2	fe_te
fetes	8	56	3014	2	fetes
fets	7	53	4594	2	fets_
feus	7	58	3075	2	feus_
fezes	17	52	2002	2	fezes
finesse	10	18	764	2	finesse
flense	9	3	890	2	flense
foss	7	64	3164	2	foss_
fossa	8	58	1263	2	fossa
fossae	9	55	1037	2	fossae
fosses	9	60	2208	2	fosses
frise	8	53	2245	2	frise
fuse	7	64	2999	2	f_use
fusee	8	62	2458	2	fusee
fuses	8	56	2842	2	fuses
fuss	7	60	2793	2	fuss_
fussed	10	46	1380	2	fussed
fusser	9	48	1377	2	fusser
fusses	9	49	2055	2	fusses
fussy	11	56	1395	2	fussy
geese	6	43	1600	2	geese
gesso	6	4	960	2	gesso
geste	6	59	2069	2	geste
jess	11	60	2203	2	jess_
jessed	14	41	1230	2	jessed
jesses	13	52	1595	2	jesses
lease	5	52	3026	2	lease
lense	5	45	2343	2	lense
leses	5	49	3081	2	leses
less	4	56	3510	2	less_
lessee	6	41	1636	2	lessee
lessen	6	42	1243	2	lessen
lesser	6	35	1485	2	lesser
masse	7	51	2529	2	masse
mense	7	50	2563	2	mense
mesne	7	51	1629	2	mesne
mess	6	59	3243	2	mess_
messed	9	50	1818	2	messed
messes	8	49	2434	2	messes
messy	10	49	1383	2	messy
ness	4	55	2656	2	ness_
nesses	6	47	1832	2	nesses
passe	7	55	2569	2	passe
pease	7	52	3111	2	pease
peise	7	58	2577	2	peise
perse	7	54	2952	2	perse
posse	7	47	2227	2	posse
resee	5	43	3633	2	resee
reuse	5	60	2536	2	reuse
seise	5	47	2785	2	seise
sense	5	55	2682	2	sense
tasse	5	48	2184	2	tasse
tease	5	54	2871	2	tease
tense	5	52	2584	2	tense
terse	5	50	2682	2	terse
verse	8	47	2358	2	verse
vessel	9	3	795	2	vessel
yeses	8	51	1932	2	yeses
yessed	10	45	1116	2	yessed
yesses	9	36	1581	2	yesses

Search took 3 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	53800	0.330	541487.9
2	DLD Change Limit	53800	105	1.763	30516.2
3	Display Results	105	105	0.033	3181.8
	(SQL Overall)	178691	105	2.126	84050.3