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

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

97 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
yesses	9	36	1581	(None)
cesses	8	42	2136	1	cesses
esses	5	64	2297	1	_esses
fesses	9	48	2025	1	fesses
jesses	13	52	1595	1	jesses
messes	8	49	2434	1	messes
nesses	6	47	1832	1	nesses
oyesses	10	3	733	1	oyesses
yeses	8	51	1932	1	ye_ses
yessed	10	45	1116	1	yessed
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
cyeses	11	5	1012	2	cye_ses
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
eyases	9	45	1368	2	eyases
eyasses	10	38	802	2	eyasses
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
jesse	12	60	1283	2	jesse_
jessed	14	41	1230	2	jessed
josses	13	51	1768	2	josses
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
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
yeasts	9	64	1305	2	yeasts
yentes	9	55	1760	2	yentes
yester	9	34	1798	2	yester

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.156	1145455.1
2	DLD Change Limit	82551	97	2.530	32628.9
3	Display Results	97	97	0.030	3233.3
	(SQL Overall)	178691	97	2.716	65792.0