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

Here are the results of your fuzzy-string dictionary search for “mohels” 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
mohels	11	50	1133	(None)
models	9	42	1636	1	models
mohel	10	49	1483	1	mohel_
morels	8	48	2002	1	morels
motels	8	36	1690	1	motels
boheas	11	40	1321	2	boheas
botels	8	48	1580	2	botels
bowels	11	43	1559	2	bowels
dowels	10	48	1334	2	dowels
hosels	9	42	1861	2	hosels
hotels	9	45	1552	2	hotels
hovels	12	54	1334	2	hovels
isohels	10	3	539	2	isohels
koels	9	46	1390	2	ko_els
kohls	12	43	780	2	koh_ls
losels	6	47	1459	2	losels
mels	6	59	4153	2	m__els
modals	9	39	1446	2	modals
model	8	45	2169	2	model_
modems	11	46	1076	2	modems
modes	8	55	3741	2	mode_s
moghuls	13	4	362	2	moghuls
moguls	9	4	856	2	moguls
mohelim	14	4	476	2	mohelim
mohurs	11	3	593	2	mohurs
moils	7	61	2575	2	mo_ils
mokes	11	46	3103	2	moke_s
moles	7	47	4792	2	mole_s
molls	7	51	2978	2	mo_lls
mols	6	59	4857	2	mo__ls
momes	9	51	3447	2	mome_s
moneys	11	55	1362	2	moneys
mools	7	60	2717	2	mo_ols
mopeds	11	49	966	2	mopeds
mopers	10	42	2037	2	mopers
mopes	9	51	3498	2	mope_s
morals	8	53	2464	2	morals
morel	7	57	2909	2	morel_
mores	7	62	4964	2	more_s
morsels	9	41	1266	2	morsels
moseys	11	47	1171	2	moseys
moshers	12	40	1784	2	moshers
moshes	11	52	2287	2	moshe_s
motel	7	66	2324	2	motel_
motes	7	59	4400	2	mote_s
motets	8	42	1619	2	motets
mothers	12	37	1762	2	mothers
moues	7	57	3284	2	moue_s
movers	11	51	1719	2	movers
moves	10	61	2842	2	move_s
mowers	11	32	1940	2	mowers
noels	5	64	1870	2	no_els
novels	9	55	1250	2	novels
rowels	9	45	1545	2	rowels
sorels	6	39	2116	2	sorels
towels	9	43	1464	2	towels
vowels	12	44	1048	2	vowels
yodels	10	46	1007	2	yodels
yokels	13	48	806	2	yokels

Search took 8 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.720	248181.9
2	DLD Change Limit	82551	59	6.953	11872.7
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	7.703	23197.6