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

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

59 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
chesses	12	41	1263	(None)
cesses	8	42	2136	1	c_esses
chasses	12	40	1750	1	chasses
cheeses	12	36	1310	1	cheeses
cresses	9	42	1981	1	cresses
accesses	12	8	749	2	accesses
blesses	9	38	1239	2	blesses
caresses	10	3	1406	2	caresses
ceases	8	44	2707	2	c_eases
censes	8	37	2180	2	c_enses
cessed	9	46	1561	2	c_essed
chaises	12	43	1749	2	chaises
chaoses	12	47	1512	2	chaoses
chases	11	51	2823	2	ch_ases
chasse	11	51	1460	2	chasse_
chassed	13	47	1213	2	chassed
chassis	12	39	1066	2	chassis
chausses	13	4	596	2	chausses
cheese	11	38	1276	2	cheese_
cheesed	13	39	1068	2	cheesed
chegoes	13	3	733	2	chegoes
chemises	15	32	1198	2	chemises
cheques	21	3	686	2	cheques
chess	10	50	1692	2	che_s_s
chessmen	15	4	446	2	chessmen
chested	13	38	1167	2	chested
chests	11	49	1626	2	che_sts
chevies	15	35	1144	2	chevies
chevres	15	37	979	2	chevres
chooses	12	57	1742	2	chooses
choses	11	58	2513	2	ch_oses
chouses	12	51	1781	2	chouses
chowses	15	56	1128	2	chowses
classes	9	47	1794	2	classes
creases	9	40	2096	2	creases
creeses	9	39	1462	2	creeses
cresset	9	33	1994	2	cresset
cressets	10	30	910	2	cressets
crosses	9	42	2079	2	crosses
cuisses	9	31	988	2	cuisses
cusses	8	45	2277	2	c_usses
cyeses	11	5	1012	2	cye_ses
dresses	8	37	1617	2	dresses
duchesses	15	4	413	2	duchesses
esses	5	64	2297	2	__esses
fesses	9	48	2025	2	_fesses
guesses	8	16	937	2	guesses
hisses	9	47	1935	2	_hisses
jesses	13	52	1595	2	_jesses
loesses	7	3	1003	2	loesses
messes	8	49	2434	2	_messes
nesses	6	47	1832	2	_nesses
oyesses	10	3	733	2	oyesses
presses	9	35	2315	2	presses
rhesuses	11	3	489	2	rhesuses
schusses	13	3	421	2	schusses
theses	9	65	1797	2	the_ses
tresses	7	37	1954	2	tresses
yesses	9	36	1581	2	_yesses

Search took 4 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	107671	0.390	458182.1
2	DLD Change Limit	107671	59	3.143	34257.4
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	3.563	50151.8