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

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

102 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
jesses	13	52	1595	(None)
cesses	8	42	2136	1	cesses
esses	5	64	2297	1	_esses
fesses	9	48	2025	1	fesses
jesse	12	60	1283	1	jesse_
jessed	14	41	1230	1	jessed
josses	13	51	1768	1	josses
messes	8	49	2434	1	messes
nesses	6	47	1832	1	nesses
yesses	9	36	1581	1	yesses
asses	5	56	2928	2	_asses
basses	8	54	2830	2	basses
beses	7	58	3072	2	be_ses
blesses	9	38	1239	2	blesses
bosses	8	59	2540	2	bosses
busses	8	50	2338	2	busses
ceases	8	44	2707	2	ceases
censes	8	37	2180	2	censes
cessed	9	46	1561	2	cessed
chesses	12	41	1263	2	chesses
cresses	9	42	1981	2	cresses
cusses	8	45	2277	2	cusses
disses	7	52	2596	2	disses
dosses	7	61	2627	2	dosses
dresses	8	37	1617	2	dresses
eases	5	60	4161	2	_eases
erses	5	58	2680	2	_erses
eses	4	53	3610	2	_e_ses
esnes	5	48	1736	2	_esnes
feases	9	54	2292	2	feases
fesse	8	61	1633	2	fesse_
fessed	10	45	1506	2	fessed
fosses	9	60	2208	2	fosses
fusses	9	49	2055	2	fusses
gasses	7	57	2478	2	gasses
gessoes	8	3	829	2	gessoes
gestes	7	57	2139	2	gestes
guesses	8	16	937	2	guesses
hisses	9	47	1935	2	hisses
jees	11	59	3854	2	je__es
jefes	15	56	1367	2	je_fes
jersey	16	3	633	2	jersey
jerseys	17	3	324	2	jerseys
jess	11	60	2203	2	je_s_s
jested	14	44	1650	2	jested
jester	13	43	1915	2	jester
jesters	14	41	1819	2	jesters
jests	12	59	2245	2	je_sts
jetes	12	49	2284	2	je_tes
joshes	16	51	1485	2	joshes
kisses	10	42	1733	2	kisses
lasses	6	48	2759	2	lasses
leases	6	54	2811	2	leases
lenses	6	46	2089	2	lenses
leses	5	49	3081	2	le_ses
lessee	6	41	1636	2	lessee
lessees	7	35	1024	2	lessees
lessen	6	42	1243	2	lessen
lessens	7	40	938	2	lessens
lesser	6	35	1485	2	lesser
loesses	7	3	1003	2	loesses
losses	6	59	2523	2	losses
masses	8	50	2871	2	masses
menses	8	42	2245	2	menses
meshes	11	50	1944	2	meshes
mesnes	8	52	1621	2	mesnes
messed	9	50	1818	2	messed
misses	8	51	3087	2	misses
mosses	8	55	2768	2	mosses
musses	8	46	2478	2	musses
oyesses	10	3	733	2	oyesses
passes	8	60	3047	2	passes
peases	8	52	2947	2	peases
peises	8	41	2504	2	peises
perses	8	54	2806	2	perses
pisses	8	45	2508	2	pisses
posses	8	51	2880	2	posses
presses	9	35	2315	2	presses
pusses	8	43	2284	2	pusses
resees	6	38	2748	2	resees
reshes	9	41	2436	2	reshes
reuses	6	60	2552	2	reuses
sasses	6	41	2439	2	sasses
seises	6	40	2671	2	seises
senses	6	39	2394	2	senses
sepses	8	45	1588	2	sepses
sisses	6	45	2060	2	sisses
susses	6	42	2105	2	susses
tasses	6	48	2676	2	tasses
teases	6	54	2627	2	teases
tenses	6	47	2255	2	tenses
testes	6	51	2582	2	testes
tosses	6	52	2539	2	tosses
tresses	7	37	1954	2	tresses
tusses	6	49	2124	2	tusses
verses	9	42	2376	2	verses
vessel	9	3	795	2	vessel
vessels	10	3	593	2	vessels
wisses	9	46	1960	2	wisses
wusses	9	33	1489	2	wusses
yeses	8	51	1932	2	ye_ses
yessed	10	45	1116	2	yessed

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	82551	0.110	1624463.6
2	DLD Change Limit	82551	102	2.156	38289.0
3	Display Results	102	102	0.030	3400.0
	(SQL Overall)	178691	102	2.296	77827.1