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

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

300 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
switch	14	45	891	(None)
snitch	11	35	794	1	snitch
stitch	11	41	910	1	stitch
swatch	14	54	928	1	swatch
swith	11	59	1740	1	swit_h
twitch	14	40	616	1	twitch
witch	13	45	1756	1	_witch
aitch	10	52	1616	2	_aitch
bewitch	17	4	332	2	bewitch
bitch	12	50	1776	2	_bitch
ditch	11	50	1509	2	_ditch
fitch	13	48	1687	2	_fitch
flitch	14	92	817	2	flitch
glitch	12	28	635	2	glitch
hitch	13	45	1547	2	_hitch
itch	9	56	1917	2	__itch
pitch	12	50	1841	2	_pitch
quitch	20	3	641	2	quitch
saith	8	58	2655	2	sait_h
scotch	13	20	752	2	scotch
scutch	13	24	708	2	scutch
sith	7	54	3515	2	s_it_h
sketch	15	3	536	2	sketch
slatch	11	45	1053	2	slatch
smirch	13	5	646	2	smirch
smith	10	78	1805	2	smit_h
smutch	13	20	584	2	smutch
snatch	11	43	1060	2	snatch
stich	10	41	1792	2	sti_ch
swath	11	59	2038	2	swat_h
swish	11	51	1482	2	swi_sh
switched	17	15	713	2	switched
switcher	16	17	768	2	switcher
switches	16	15	913	2	switches
swithe	12	40	1068	2	swithe
twitchy	18	39	357	2	twitchy
watch	13	56	1706	2	_watch
wich	12	57	2474	2	_wi_ch
winch	13	50	1666	2	_winch
witchy	17	46	859	2	_witchy
with	10	57	3047	2	_wit_h
baith	10	80	2313	3	bait_h
batch	12	46	2010	3	_batch
birch	12	49	1402	3	_birch
bitchy	16	47	920	3	_bitchy
blotch	13	19	714	3	blotch
botch	12	67	1745	3	_botch
brith	10	49	2437	3	brit_h
butch	12	54	1654	3	_butch
catch	12	51	2037	3	_catch
chinch	16	39	1123	3	chinch
cinch	12	45	1624	3	_cinch
clinch	13	39	1035	3	clinch
clutch	13	36	775	3	clutch
cratch	13	41	1079	3	cratch
crotch	13	34	1008	3	crotch
crutch	13	40	824	3	crutch
cultch	13	38	595	3	cultch
cutch	12	51	1619	3	_cutch
dutch	11	47	1382	3	_dutch
etch	9	54	1914	3	__etch
faith	11	56	2085	3	fait_h
fetch	13	49	1347	3	_fetch
fetich	14	7	969	3	fetich
filch	13	48	1332	3	_filch
finch	13	54	1697	3	_finch
fitchy	17	43	762	3	_fitchy
fletch	14	38	819	3	fletch
flinch	14	40	1010	3	flinch
frith	11	59	2203	3	frit_h
glitchy	16	28	308	3	glitchy
grinch	12	3	848	3	grinch
grith	9	55	2037	3	grit_h
grutch	12	28	556	3	grutch
hatch	13	57	1959	3	_hatch
hootch	14	38	641	3	hootch
hotch	13	62	1473	3	_hotch
hutch	13	54	1409	3	_hutch
ich	8	62	2774	3	__i_ch
inch	9	54	2082	3	__inch
itchy	13	44	901	3	__itchy
ketch	14	49	1202	3	_ketch
kith	11	58	2636	3	_kit_h
kitsch	15	3	335	3	_kitsch
klatch	15	44	593	3	klatch
kvetch	18	3	299	3	kvetch
laich	10	59	2071	3	lai_ch
laith	8	57	2210	3	lait_h
latch	10	46	2046	3	_latch
letch	10	52	1580	3	_letch
lich	9	62	3084	3	_li_ch
litchi	11	3	789	3	_litchi
match	12	56	2110	3	_match
milch	12	44	1337	3	_milch
mutch	12	50	1617	3	_mutch
natch	10	50	1822	3	_natch
nautch	11	4	481	3	nautch
notch	10	56	1332	3	_notch
painch	13	35	1132	3	painch
patch	12	52	2122	3	_patch
pinch	12	56	1930	3	_pinch
pitchy	16	47	967	3	_pitchy
pith	9	54	3269	3	_pit_h
ratch	10	42	2136	3	_ratch
restitch	13	4	469	3	restitch
retch	10	48	1830	3	_retch
rich	9	70	2554	3	_ri_ch
rotch	10	58	1593	3	_rotch
saice	7	54	2405	3	sai_ce
saithe	9	47	1391	3	saithe
samech	13	27	703	3	samech
sauch	10	49	1877	3	s_auch
scooch	13	22	812	3	scooch
scootch	14	3	446	3	scootch
scorch	13	19	809	3	scorch
scratch	14	4	601	3	scratch
sculch	13	22	621	3	sculch
scultch	14	8	354	3	scultch
search	11	33	1242	3	search
seiche	11	8	1183	3	sei_che
seitan	6	26	1323	3	seitan
sheuch	14	26	704	3	sheuch
shibah	14	38	747	3	shibah
shit	7	67	4594	3	shit__
shits	8	47	3117	3	shit_s
shittah	13	8	515	3	shittah
shitty	12	41	1006	3	shitty
shivah	15	48	854	3	shivah
shtick	15	30	802	3	shtick
sic	5	58	4787	3	s_i_c_
sice	6	55	4559	3	s_i_ce
sick	10	64	3557	3	s_i_ck
sics	6	52	3409	3	s_i_cs
sidh	8	62	2299	3	s_i_dh
sigh	8	56	2589	3	s_i_gh
since	7	50	2417	3	s_ince
sinh	7	62	3804	3	s_i_nh
sit	3	58	7775	3	s_it__
sitar	5	48	2054	3	s_itar
sitcom	10	3	690	3	s_itcom
site	4	70	5241	3	s_it_e
sited	6	51	3074	3	s_ited
sites	5	60	4543	3	s_ites
sits	4	50	5020	3	s_it_s
situp	7	44	1406	3	s_itup
situs	5	50	1923	3	s_itus
sixth	15	55	1223	3	s_ixth
sketchy	19	4	305	3	sketchy
skit	8	54	3753	3	skit__
skite	9	51	2005	3	skit_e
skited	11	43	1348	3	skited
skites	10	44	1804	3	skites
skits	9	47	2186	3	skit_s
slice	7	49	2582	3	sli_ce
slick	11	55	2052	3	sli_ck
slit	4	62	5010	3	slit__
slits	5	61	2885	3	slit_s
slitty	9	32	916	3	slitty
sloth	8	50	1945	3	slot_h
slouch	11	43	852	3	slouch
smit	6	51	3841	3	smit__
smite	7	52	2487	3	smit_e
smiter	8	36	1641	3	smiter
smites	8	39	2192	3	smites
smiths	11	47	1102	3	smiths
smithy	14	50	827	3	smithy
smooch	13	26	680	3	smooch
smutchy	17	19	315	3	smutchy
snatchy	15	35	529	3	snatchy
snath	8	64	1980	3	snat_h
snick	11	44	1601	3	sni_ck
snit	4	63	4247	3	snit__
snitched	14	16	686	3	snitched
snitcher	13	15	737	3	snitcher
snitches	13	14	898	3	snitches
snits	5	41	2483	3	snit_s
sooth	8	59	2406	3	soot_h
soth	7	59	3252	3	s_ot_h
south	8	52	2357	3	sout_h
speech	13	4	756	3	speech
spic	8	52	2743	3	spi_c_
spica	9	47	1794	3	spi_ca
spice	9	55	2881	3	spi_ce
spick	13	45	1907	3	spi_ck
spics	9	41	2324	3	spi_cs
spicy	12	54	1771	3	spi_cy
spilth	11	46	973	3	spilth
spinach	14	3	540	3	spinach
spit	6	55	4508	3	spit__
spital	8	38	1387	3	spital
spite	7	54	3066	3	spit_e
spited	9	48	2044	3	spited
spites	8	41	2733	3	spites
spits	7	44	2955	3	spit_s
spitz	16	60	1797	3	spit_z
splotch	14	4	285	3	splotch
squinch	21	3	483	3	squinch
stanch	11	38	1237	3	stanch
starch	11	30	1320	3	starch
stench	11	41	1116	3	stench
stichs	11	45	1165	3	sti_chs
stick	11	51	2156	3	sti_ck
stitched	14	14	820	3	stitched
stitcher	13	16	839	3	stitcher
stitches	13	14	1059	3	stitches
stithy	12	39	821	3	stithy
stretch	12	3	641	3	stretch
such	9	64	2481	3	s__uch
suit	4	56	4987	3	suit__
suite	5	48	2956	3	suit_e
suited	7	40	1942	3	suited
suiter	6	41	2181	3	suiter
suites	6	37	2740	3	suites
suitor	6	33	1105	3	suitor
suits	5	50	2805	3	suit_s
sumach	13	53	1011	3	sumach
swarth	12	60	1208	3	swarth
swash	11	63	1675	3	sw_ash
swat	7	72	4444	3	swat__
swatches	16	16	996	3	swatches
swathe	12	55	1411	3	swathe
swaths	12	53	1264	3	swaths
swats	8	57	2686	3	swat_s
swift	11	68	1805	3	swi_ft
swifter	13	31	805	3	swifter
swiftly	16	3	373	3	swiftly
swifts	12	40	817	3	swifts
swig	8	58	1802	3	swi__g
swigs	9	62	1366	3	swi_gs
swill	8	34	1737	3	swi_ll
swills	9	42	1336	3	swills
swim	9	62	2140	3	swi__m
swimmy	16	23	435	3	swimmy
swims	10	55	1414	3	swi_ms
swine	8	56	2530	3	swi_ne
swing	9	61	2484	3	swi_ng
swinge	10	56	1438	3	swinge
swings	10	47	1445	3	swings
swingy	13	48	987	3	swingy
swinish	13	4	720	3	swinish
swink	12	51	1635	3	swi_nk
swinks	13	46	1065	3	swinks
swipe	10	52	1708	3	swi_pe
swiped	12	38	1109	3	swiped
swipes	11	41	1433	3	swipes
swiple	11	37	923	3	swiple
swirl	8	45	1414	3	swi_rl
swirls	9	40	1013	3	swirls
swirly	12	43	925	3	swirly
swishy	15	36	584	3	swishy
swiss	8	67	1290	3	swi_ss
switchers	17	14	663	3	switch~~ers~~
switching	18	3	570	3	switch~~ing~~
switchman	19	6	220	3	switch~~man~~
switchmen	19	6	242	3	switch~~men~~
swither	13	37	1099	3	swither
swithly	16	3	444	3	swithly
swive	11	53	1619	3	swi_ve
swived	13	36	1063	3	swived
swivel	12	36	932	3	swivel
swives	12	39	1518	3	swives
swivet	12	36	1547	3	swivet
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
twice	10	47	1112	3	twi_ce
twit	7	63	2906	3	twit__
twitched	17	15	503	3	twitched
twitcher	16	13	534	3	twitcher
twitches	16	15	637	3	twitches
twits	8	60	1579	3	twit_s
unhitch	15	4	305	3	unhitch
unstitch	13	4	359	3	unstitch
vetch	13	44	1184	3	_vetch
welch	13	44	1149	3	_welch
wench	13	62	1478	3	_wench
which	16	39	1008	3	_which
wicca	12	4	725	3	_wicca
wick	13	57	2630	3	_wi_ck
width	12	3	1096	3	_width
wilco	10	3	944	3	_wilco
wince	10	52	2088	3	_wince
wish	10	72	2873	3	_wi_sh
wit	6	65	6377	3	_wit__
witan	8	38	1650	3	_witan
witched	16	30	1219	3	_witched
witches	15	27	1579	3	_witches
wite	7	54	4327	3	_wit_e
wited	9	47	2714	3	_wited
wites	8	55	3696	3	_wites
withe	11	52	2023	3	_withe
withy	14	48	1376	3	_withy
wits	7	60	4487	3	_wit_s
witty	11	47	1701	3	_witty
wretch	14	32	653	3	wretch
wych	15	40	1188	3	_w_ych
zilch	19	43	812	3	_zilch

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	112716	0.376	475242.0
2	DLD Change Limit	112716	300	5.843	19290.8
3	Display Results	300	300	0.093	3225.8
	(SQL Overall)	178691	300	6.312	28309.7