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

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

85 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
motors	8	46	1660	(None)
moors	7	49	2314	1	mo_ors
motor	7	53	1729	1	motor_
rotors	6	49	1795	1	rotors
actors	8	10	1677	2	actors
boors	7	43	2501	2	bo_ors
colors	8	66	2237	2	colors
doctors	10	3	999	2	doctors
dolors	7	51	1531	2	dolors
donors	7	51	1579	2	donors
doors	6	50	2213	2	do_ors
doters	7	44	2391	2	doters
emoters	9	47	1287	2	emoters
fetors	9	10	1447	2	fetors
foetors	10	3	976	2	foetors
gators	7	41	1584	2	gators
honors	9	48	1679	2	honors
kotos	9	57	1770	2	koto_s
kotows	13	44	652	2	kotows
lotos	5	47	2463	2	loto_s
majors	15	45	1109	2	majors
manors	8	44	2088	2	manors
maters	8	50	3239	2	maters
mayors	11	57	1419	2	mayors
mentors	9	3	1499	2	mentors
meteors	9	46	1001	2	meteors
meters	8	56	2583	2	meters
metols	8	41	1577	2	metols
metros	8	42	1780	2	metros
minors	8	51	1710	2	minors
miters	8	43	2878	2	miters
mohurs	11	3	593	2	mohurs
mojoes	15	39	952	2	mojoes
mojos	14	53	1446	2	mojo_s
molars	8	55	1732	2	molars
molters	9	38	1697	2	molters
monitors	10	3	1082	2	monitors
monos	7	59	3086	2	mono_s
moods	8	52	2462	2	mo_ods
mools	7	60	2717	2	mo_ols
moons	7	53	3100	2	mo_ons
moor	6	66	2855	2	mo_or_
moory	10	51	1579	2	mo_ory
moos	6	60	5130	2	mo_o_s
mooters	9	38	1862	2	mooters
moots	7	58	3166	2	mo_ots
mopers	10	42	2037	2	mopers
morons	8	49	1954	2	morons
morros	8	37	1467	2	morros
mors	6	59	5006	2	m__ors
mortars	9	34	1152	2	mortars
motels	8	36	1690	2	motels
motes	7	59	4400	2	mot_es
motets	8	42	1619	2	motets
mothers	12	37	1762	2	mothers
moths	10	60	2155	2	mot_hs
motifs	11	3	967	2	motifs
motions	9	42	1500	2	motions
motmots	11	6	613	2	motmots
motorbus	12	4	444	2	motorbus
motored	10	3	993	2	motored
motoric	11	3	1223	2	motoric
motorise	10	3	1152	2	motorise
motorist	10	3	1441	2	motorist
mots	6	68	5316	2	mot__s
mottes	8	55	2369	2	mottes
mottoes	9	34	1219	2	mottoes
mottos	8	46	1524	2	mottos
motts	7	65	2700	2	mot_ts
moutons	9	4	1031	2	moutons
movers	11	51	1719	2	movers
mowers	11	32	1940	2	mowers
mozos	16	55	1633	2	mozo_s
mucors	10	44	1085	2	mucors
mutons	8	43	1436	2	mutons
noters	6	40	2100	2	noters
odors	6	45	1428	2	_odors
rotor	5	55	1973	2	rotor_
rotos	5	60	2788	2	roto_s
sopors	8	52	1520	2	sopors
sotols	6	37	1447	2	sotols
tors	4	61	5738	2	__tors
toters	6	50	2636	2	toters
tutors	6	9	1233	2	tutors
voters	9	50	1744	2	voters

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.376	475242.0
2	DLD Change Limit	82551	85	2.203	37472.1
3	Display Results	85	85	0.013	6538.5
	(SQL Overall)	178691	85	2.592	68939.4