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

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

98 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
motets	8	42	1619	(None)
motels	8	36	1689	1	motels
motes	7	59	4400	1	mote_s
motet	7	56	4119	1	motet_
mottes	8	55	2369	1	mottes
motts	7	65	2700	1	mot_ts
botels	8	48	1580	2	botels
botts	7	52	2486	2	bot_ts
comets	10	58	2358	2	comets
cosets	8	58	2440	2	cosets
cotes	7	63	4784	2	cote_s
covets	11	48	1964	2	covets
doters	7	44	2391	2	doters
dotes	6	58	3669	2	dote_s
emoters	9	47	1287	2	emoters
emotes	8	46	2028	2	emote_s
godets	8	4	1093	2	godets
hotels	9	45	1551	2	hotels
lottes	6	53	2275	2	lottes
maters	8	50	3239	2	maters
mates	7	52	5136	2	mate_s
mateys	11	56	1094	2	mateys
mattes	8	56	2453	2	mattes
matts	7	68	2918	2	mat_ts
meets	7	42	2461	2	m_eets
meters	8	56	2583	2	meters
metes	7	47	3621	2	mete_s
miters	8	43	2878	2	miters
mites	7	51	4180	2	mite_s
mitts	7	55	2375	2	mit_ts
moats	7	58	2764	2	mo_ats
models	9	42	1635	2	models
modems	11	46	1076	2	modems
modes	8	55	3741	2	mode_s
modest	9	38	1845	2	modest
mohels	11	50	1132	2	mohels
moiety	11	4	822	2	moiety
mokes	11	46	3103	2	moke_s
moles	7	47	4792	2	mole_s
molest	8	50	2274	2	molest
molests	9	33	1156	2	molests
molters	9	38	1697	2	molters
molts	7	60	3209	2	mo_lts
moments	11	31	1312	2	moments
momes	9	51	3447	2	mome_s
moneys	11	55	1362	2	moneys
montes	8	42	2693	2	monte_s
mooters	9	38	1862	2	mooters
moots	7	58	3166	2	mo_ots
mopeds	11	49	966	2	mopeds
mopers	10	42	2037	2	mopers
mopes	9	51	3498	2	mope_s
moppets	13	30	716	2	moppets
morels	8	48	2001	2	morels
mores	7	62	4964	2	more_s
morts	7	55	3356	2	mo_rts
moseys	11	47	1170	2	moseys
mostest	9	3	1479	2	mostest
mostests	10	3	683	2	mostests
mosts	7	60	2854	2	mo_sts
mote	6	70	4808	2	mote__
motel	7	66	2324	2	mote_l
motey	10	59	2295	2	mote_y
mothers	12	37	1762	2	mothers
moths	10	60	2155	2	mot_hs
motifs	11	3	967	2	motifs
motleys	12	3	568	2	motleys
motmots	11	6	613	2	motmots
motors	8	46	1660	2	motors
mots	6	68	5316	2	mo__ts
mott	6	66	4844	2	mot_t_
motte	7	55	2697	2	mot_te
motto	7	61	1951	2	mot_to
mottos	8	46	1524	2	mottos
moues	7	57	3284	2	moue_s
moults	8	47	1370	2	moults
mounts	8	41	1507	2	mounts
movers	11	51	1719	2	movers
moves	10	61	2842	2	move_s
mowers	11	32	1940	2	mowers
mutes	7	50	3378	2	mute_s
mutest	8	42	1805	2	mutest
mutts	7	51	2025	2	mut_ts
nonets	6	41	1870	2	nonets
noters	6	40	2100	2	noters
notes	5	50	3458	2	note_s
octets	8	3	940	2	octets
poets	7	60	2444	2	po_ets
rosets	6	58	1995	2	rosets
rotes	5	61	4390	2	rote_s
rottes	6	45	2483	2	rottes
stets	5	54	2391	2	_stets
tets	4	58	4746	2	__tets
totems	8	68	1076	2	totems
toters	6	50	2636	2	toters
totes	5	51	3968	2	tote_s
voters	9	50	1744	2	voters
votes	8	46	2708	2	vote_s

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.360	496363.9
2	DLD Change Limit	82551	98	2.546	32423.8
3	Display Results	98	98	0.033	2969.7
	(SQL Overall)	178691	98	2.939	60799.9