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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

320 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
scotch	13	20	752	(None)
scooch	13	22	812	1	scooch
scootch	14	3	446	1	scootch
scorch	13	19	809	1	scorch
scutch	13	24	708	1	scutch
blotch	13	19	714	2	blotch
botch	12	67	1745	2	_botch
catch	12	51	2037	2	_catch
coach	12	59	1945	2	_coach
conch	12	46	2007	2	_conch
cooch	12	49	1683	2	_cooch
couch	12	53	2011	2	_couch
crotch	13	34	1008	2	crotch
cutch	12	51	1619	2	_cutch
hootch	14	38	641	2	hootch
hotch	13	62	1473	2	_hotch
notch	10	56	1332	2	_notch
rotch	10	58	1593	2	_rotch
sconce	10	47	1172	2	sconce
scot	6	62	4261	2	scot__
scotched	16	18	793	2	scotched
scotches	15	17	947	2	scotches
scoter	8	38	1548	2	scoter
scotia	8	3	1080	2	scotia
scots	7	40	2591	2	scot_s
scouth	11	50	1115	2	scouth
scratch	14	4	601	2	scratch
scrooch	14	4	496	2	scrooch
scrootch	15	4	281	2	scrootch
sculch	13	22	621	2	sculch
scultch	14	8	354	2	scultch
sketch	15	3	536	2	sketch
slatch	11	45	1053	2	slatch
sloth	8	50	1945	2	slot_h
slouch	11	43	852	2	slouch
smooch	13	26	680	2	smooch
smutch	13	20	584	2	smutch
snatch	11	43	1060	2	snatch
snitch	11	35	794	2	snitch
sooth	8	59	2406	2	soot_h
soth	7	59	3252	2	s_ot_h
splotch	14	4	285	2	splotch
stitch	11	41	910	2	stitch
swatch	14	54	928	2	swatch
switch	14	45	891	2	switch
acock	13	21	1021	3	aco_ck
aitch	10	52	1616	3	_aitch
ascot	7	65	2251	3	ascot__
ascots	8	53	1251	3	ascot_s
avouch	14	3	483	3	avouch
azoth	17	38	990	3	azot_h
batch	12	46	2010	3	_batch
bescorch	17	4	258	3	bescorch
biotech	14	10	449	3	biotech
bitch	12	50	1776	3	_bitch
blotchy	17	29	397	3	blotchy
booth	10	55	2201	3	boot_h
botchy	16	53	782	3	_botchy
both	9	65	3343	3	_bot_h
broach	13	36	1111	3	broach
brooch	13	36	844	3	brooch
broth	10	65	2109	3	brot_h
butch	12	54	1654	3	_butch
bycatch	19	4	206	3	bycatch
catchy	16	55	958	3	_catchy
cinch	12	45	1624	3	_cinch
clach	12	46	1782	3	_clach
cloth	10	58	1754	3	clot_h
clutch	13	36	775	3	clutch
coact	9	61	3058	3	_coact
coca	8	80	3064	3	_co_ca
cocci	8	28	1267	3	_cocci
cock	12	63	3290	3	_co_ck
coco	8	73	3060	3	_co_co
concha	13	42	1328	3	_concha
concho	13	44	1426	3	_concho
conchs	13	47	1490	3	_conchs
conchy	16	37	1022	3	_conchy
cosh	9	61	2762	3	_co_sh
cot	5	104	8322	3	_cot__
cotan	7	15	2178	3	_cotan
cote	6	66	4873	3	_cot_e
coted	8	50	3385	3	_coted
cotes	7	63	4784	3	_cotes
cots	6	80	5484	3	_cot_s
cotta	7	58	1857	3	_cotta
cough	11	58	1964	3	_cough
couth	10	61	2249	3	_couth
cratch	13	41	1079	3	cratch
crouch	13	39	1020	3	crouch
crutch	13	40	824	3	crutch
culch	12	45	1283	3	_culch
cultch	13	38	595	3	cultch
curch	12	44	1541	3	_curch
ditch	11	50	1509	3	_ditch
doth	8	62	2571	3	_dot_h
dutch	11	47	1382	3	_dutch
epoch	12	4	820	3	epo_ch
escot	7	53	2008	3	escot__
escoted	10	3	818	3	escoted
escots	8	42	1174	3	escot_s
etch	9	54	1914	3	__etch
fetch	13	49	1347	3	_fetch
fitch	13	48	1687	3	_fitch
fletch	14	38	819	3	fletch
flitch	14	92	817	3	flitch
froth	11	59	1928	3	frot_h
glitch	12	28	635	3	glitch
gotcha	12	3	463	3	_gotcha
goth	8	68	2508	3	_got_h
grouch	12	31	847	3	grouch
grutch	12	28	556	3	grutch
hatch	13	57	1959	3	_hatch
hitch	13	45	1547	3	_hitch
hooch	13	58	1370	3	_hooch
hopscotch	21	5	149	3	~~hop~~scotch
hutch	13	54	1409	3	_hutch
isotach	12	4	495	3	isotach
itch	9	56	1917	3	__itch
ketch	14	49	1202	3	_ketch
klatch	15	44	593	3	klatch
kvetch	18	3	299	3	kvetch
latch	10	46	2046	3	_latch
letch	10	52	1580	3	_letch
loach	10	51	1636	3	_loach
loch	9	55	2713	3	_lo_ch
lotah	8	53	1585	3	_lotah
loth	7	61	3213	3	_lot_h
match	12	56	2110	3	_match
mooch	12	53	1361	3	_mooch
moth	9	67	3133	3	_mot_h
mouch	12	47	1580	3	_mouch
mutch	12	50	1617	3	_mutch
natch	10	50	1822	3	_natch
nautch	11	4	481	3	nautch
ouch	9	57	2463	3	__ouch
patch	12	52	2122	3	_patch
pitch	12	50	1841	3	_pitch
poach	12	49	1786	3	_poach
pooch	12	48	1530	3	_pooch
porch	12	59	1862	3	_porch
pouch	12	46	1708	3	_pouch
quitch	20	3	641	3	quitch
quoth	17	33	1035	3	quot_h
ratch	10	42	2136	3	_ratch
retch	10	48	1830	3	_retch
roach	10	57	1700	3	_roach
rotche	11	43	1198	3	_rotche
saith	8	58	2655	3	sait_h
samech	13	27	703	3	samech
sauch	10	49	1877	3	s_auch
scarce	10	40	1363	3	scarce
scarph	13	42	960	3	scarph
scat	6	58	4837	3	scat__
scathe	11	44	1499	3	scathe
scats	7	59	3060	3	scat_s
scatt	7	60	3009	3	scat_t
scatts	8	59	1466	3	scatts
scatty	11	53	1065	3	scatty
schtick	18	19	452	3	schtick
schtik	15	18	542	3	schtik
scoff	13	44	1334	3	sco_ff
scoffs	14	34	750	3	scoffs
scold	8	54	1486	3	sco_ld
scolds	9	50	1123	3	scolds
scolex	15	3	824	3	scolex
sconced	12	35	917	3	sconced
sconces	11	38	1145	3	sconces
scone	7	46	2183	3	sco_ne
scones	8	45	2130	3	scones
scooched	16	20	668	3	scooched
scooches	15	18	841	3	scooches
scoop	9	56	1716	3	sco_op
scoops	10	54	1436	3	scoops
scoot	7	57	2915	3	sco_ot
scootched	17	6	396	3	scootched
scootches	16	3	500	3	scootches
scooted	10	36	1228	3	scooted
scooter	9	33	1287	3	scooter
scoots	8	53	1594	3	scoots
scop	8	59	2552	3	sco__p
scope	9	48	2148	3	sco_pe
scoped	11	51	1665	3	scoped
scopes	10	47	1959	3	scopes
scops	9	58	2019	3	sco_ps
scorched	16	18	719	3	scorched
scorcher	15	19	678	3	scorcher
scorches	15	18	914	3	scorches
score	7	55	2674	3	sco_re
scored	9	46	2113	3	scored
scorer	8	48	1826	3	scorer
scores	8	47	2592	3	scores
scoria	8	5	1350	3	scoria
scorn	7	58	1745	3	sco_rn
scorns	8	57	1302	3	scorns
scotching	17	3	565	3	scotch~~ing~~
scoters	9	33	1381	3	scoters
scotias	9	3	975	3	scotias
scotoma	11	5	596	3	scotoma
scottie	9	3	746	3	scottie
scour	7	53	1553	3	sco_ur
scours	8	49	1359	3	scours
scouse	8	41	1363	3	scouse
scout	7	50	3145	3	sco_ut
scouted	10	41	1203	3	scouted
scouter	9	33	1332	3	scouter
scouths	12	52	789	3	scouths
scouts	8	48	1794	3	scouts
scow	9	60	2142	3	sco__w
scowed	12	44	1383	3	scowed
scowl	10	120	1297	3	sco_wl
scowls	11	54	959	3	scowls
scows	10	66	1780	3	sco_ws
scraich	14	3	676	3	scraich
scratchy	18	4	365	3	scratchy
screech	14	3	522	3	screech
scrota	8	3	1020	3	scrot_a
scrotal	9	3	849	3	scrotal
scrotum	11	4	513	3	scrotum
scrunch	14	4	403	3	scrunch
scut	6	58	3554	3	scut__
scuta	7	58	1575	3	scut_a
scutched	16	18	689	3	scutched
scutcher	15	17	696	3	scutcher
scutches	15	16	888	3	scutches
scute	7	55	2094	3	scut_e
scutes	8	52	1919	3	scutes
scuts	7	45	2252	3	scut_s
scutum	10	3	637	3	scutum
scythe	14	46	601	3	scythe
search	11	33	1242	3	search
seecatch	15	4	269	3	seecatch
sheuch	14	26	704	3	sheuch
shock	14	49	1703	3	sho_ck
shot	7	61	5026	3	shot__
shote	8	55	2610	3	shot_e
shotes	9	53	2191	3	shotes
shots	8	47	3085	3	shot_s
shott	8	53	3219	3	shot_t
shotts	9	36	1470	3	shotts
sith	7	54	3515	3	s_it_h
sixth	15	55	1223	3	sixt_h
sketchy	19	4	305	3	sketchy
skosh	12	40	727	3	sko_sh
slosh	8	45	1448	3	slo_sh
slot	4	60	4983	3	slot__
sloths	9	49	1189	3	sloths
slots	5	48	3053	3	slot_s
slouchy	15	45	484	3	slouchy
slough	10	53	923	3	slough
smirch	13	5	646	3	smirch
smith	10	78	1805	3	smit_h
smock	13	53	1167	3	smo_ck
smoochy	17	22	386	3	smoochy
smoosh	11	23	673	3	smoosh
smooth	11	25	920	3	smooth
smote	7	58	2028	3	smot_e
smutchy	17	19	315	3	smutchy
snatchy	15	35	529	3	snatchy
snath	8	64	1980	3	snat_h
snot	4	47	4545	3	snot__
snots	5	52	2512	3	snot_s
snotty	9	48	920	3	snotty
soca	6	63	3005	3	s_o_ca
sock	10	52	3321	3	s_o_ck
soot	4	57	6106	3	soot__
sooted	7	39	2259	3	sooted
soothe	9	42	1485	3	soothe
sooths	9	57	1559	3	sooths
soots	5	55	3621	3	soot_s
sooty	8	49	2484	3	soot_y
soph	9	70	2420	3	s_o_ph
sot	3	103	8430	3	s_ot__
soths	8	62	1863	3	s_oths
sotol	5	49	1765	3	s_otol
sots	4	55	5245	3	s_ot_s
sough	9	53	2046	3	s_ough
south	8	52	2357	3	s_outh
speech	13	4	756	3	speech
splotchy	18	4	179	3	splotchy
spot	6	55	4069	3	spot__
spots	7	44	2411	3	spot_s
spotty	11	44	858	3	spotty
stanch	11	38	1237	3	stanch
starch	11	30	1320	3	starch
stench	11	41	1116	3	stench
stich	10	41	1792	3	s_tich
stock	11	44	1756	3	sto_ck
stoic	7	3	1725	3	stoic_
stoics	8	3	1111	3	stoics
stomach	14	3	603	3	stomach
stot	4	63	4733	3	stot__
stotin	6	32	1506	3	stotin
stots	5	48	2855	3	stot_s
stott	5	69	2979	3	stot_t
stotts	6	46	1286	3	stotts
stretch	12	3	641	3	stretch
succoth	14	4	509	3	succot_h
such	9	64	2481	3	s__uch
sumach	13	53	1011	3	sumach
swath	11	59	2038	3	swat_h
swith	11	59	1740	3	swit_h
swoosh	12	19	521	3	swoosh
swot	7	51	3466	3	swot__
swots	8	55	1843	3	swot_s
synch	13	50	1179	3	s_ynch
synth	11	37	1182	3	synt_h
thatch	14	3	561	3	thatch
tooth	8	80	2018	3	toot_h
torch	10	74	2093	3	_torch
touch	10	65	1939	3	_touch
troth	8	56	2220	3	trot_h
twitch	14	40	616	3	twitch
vetch	13	44	1184	3	_vetch
vouch	13	46	1190	3	_vouch
watch	13	56	1706	3	_watch
witch	13	45	1756	3	_witch
wretch	14	32	653	3	wretch
wroth	11	68	1588	3	wrot_h
zlotych	24	4	141	3	zlotych

Search took 6 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	112716	0.376	475242.0
2	DLD Change Limit	112716	320	4.906	22975.1
3	Display Results	320	320	0.110	2909.1
	(SQL Overall)	178691	320	5.392	33140.0