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

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

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.

75 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
jesse	12	60	1283	(None)
fesse	8	61	1633	1	fesse
jess	11	60	2203	1	jess_
jessed	14	41	1230	1	jessed
jesses	13	52	1595	1	jesses
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
fease	8	48	2487	2	fease
fess	7	65	2916	2	fess_
fessed	10	45	1506	2	fessed
fesses	9	48	2025	2	fesses
fosse	8	61	1946	2	fosse
geese	6	43	1600	2	geese
gesso	6	4	960	2	gesso
geste	6	59	2069	2	geste
jee	10	66	4864	2	je__e
jees	11	59	3854	2	jees_
jefe	14	65	1688	2	je_fe
jefes	15	56	1367	2	jefes
jersey	16	3	633	2	jersey
jest	11	67	3850	2	je_st
jested	14	44	1650	2	jested
jester	13	43	1915	2	jester
jests	12	59	2245	2	jests
jete	11	59	2725	2	je_te
jetes	12	49	2284	2	jetes
jets	11	58	3410	2	jets_
jews	14	58	2208	2	jews_
joss	11	59	2559	2	joss_
josses	13	51	1768	2	josses
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 2 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.090	1985455.6
2	DLD Change Limit	53800	75	1.626	33087.3
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	1.749	102167.5