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

Here are the results of your fuzzy-string dictionary search for “smoochy” with Change Limit: [1] [2] [3] [4]

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.

95 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
smoochy	17	22	386	(None)
smooch	13	26	680	1	smooch_
smoothy	15	20	508	1	smoothy
mooch	12	53	1361	2	_mooch_
scooch	13	22	812	2	scooch_
slouchy	15	45	484	2	slouchy
smooched	16	18	598	2	smooched
smoocher	15	20	550	2	smoocher
smooches	15	21	726	2	smooches
smoosh	11	23	673	2	smoosh_
smooth	11	25	920	2	smooth_
smoothly	16	20	364	2	smoothly
smooths	12	21	632	2	smooths
smutchy	17	19	315	2	smutchy
blotchy	17	29	397	3	blotchy
botchy	16	53	782	3	_botchy
brooch	13	36	844	3	brooch_
conchy	16	37	1022	3	_conchy
cooch	12	49	1683	3	_cooch_
grouchy	16	29	424	3	grouchy
hooch	13	58	1370	3	_hooch_
mocha	12	4	992	3	_m_ocha
moloch	13	5	648	3	_moloch_
molochs	14	3	522	3	_molochs
mooched	15	39	1053	3	_mooched
moocher	14	36	1067	3	_moocher
mooches	14	37	1445	3	_mooches
moody	11	50	1749	3	_moo_dy
mooley	11	3	1163	3	_mooley
moony	10	48	1827	3	_moo_ny
moory	10	51	1579	3	_moo_ry
mothy	13	62	1455	3	_m_othy
mouch	12	47	1580	3	_mouch_
mouthy	14	40	906	3	_mouthy
poachy	16	38	896	3	_poachy
pooch	12	48	1530	3	_pooch_
pouchy	16	53	866	3	_pouchy
scooched	16	20	668	3	scooched
scooches	15	18	841	3	scooches
scootch	14	3	446	3	scootch_
scorch	13	19	809	3	scorch_
scotch	13	20	752	3	scotch_
scrooch	14	4	496	3	scrooch_
shlocky	19	31	450	3	shlocky
shoofly	16	3	435	3	shoofly
sketchy	19	4	305	3	sketchy
sloshy	12	36	662	3	s_loshy
slouch	11	43	852	3	slouch_
sloughy	14	53	580	3	sloughy
smirch	13	5	646	3	smirch_
smithy	14	50	827	3	sm_ithy
smock	13	53	1167	3	sm_oc_k
smocks	14	57	1001	3	sm_ocks
smoggy	13	5	428	3	sm_oggy
smokey	15	39	865	3	sm_okey
smokily	16	3	537	3	smokily
smoky	14	38	868	3	sm_o_ky
smoochers	16	18	483	3	smoochers
smooching	17	3	488	3	smooching
smooshed	14	18	599	3	smooshed
smooshes	13	20	686	3	smooshes
smoothed	14	23	647	3	smoothed
smoothen	13	20	496	3	smoothen
smoother	13	19	667	3	smoother
smoothes	13	21	854	3	smoothes
smoothie	13	4	489	3	smoothie
smutch	13	20	584	3	smutch_
snatchy	15	35	529	3	snatchy
snoopy	11	44	947	3	snoo_py
snooty	9	42	1151	3	snoo_ty
snoozy	18	51	723	3	snoo_zy
sooey	8	45	2243	3	s_oo_ey
sooth	8	59	2406	3	s_ooth_
soothe	9	42	1485	3	s_oothe
soothly	13	18	692	3	s_oothly
sooths	9	57	1559	3	s_ooths
sooty	8	49	2484	3	s_oo_ty
sophy	13	66	1176	3	s__ophy
soroche	12	3	718	3	soroche
splotchy	18	4	179	3	splotchy
spoofy	14	49	855	3	spoo_fy
spooky	15	41	809	3	spoo_ky
spooney	12	41	824	3	spooney
spoony	11	41	1179	3	spoo_ny
squooshy	23	8	127	3	squooshy
starchy	15	28	674	3	starchy
stenchy	15	25	621	3	stenchy
stocky	15	36	915	3	s_tocky
stomachy	18	4	382	3	stomachy
swoony	12	40	826	3	swoo_ny
swoopy	14	48	728	3	swoo_py
swoosh	12	19	521	3	swoosh_
toothy	12	52	969	3	_toothy
torchy	14	54	953	3	_torchy
touchy	14	50	1050	3	_touchy

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	95	5.970	22450.1
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	6.406	27894.3