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

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

256 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
glitch	12	28	635	(None)
flitch	14	92	817	1	flitch
glitchy	16	28	308	1	glitchy
aitch	10	52	1616	2	_aitch
bitch	12	50	1776	2	_bitch
blotch	13	19	714	2	blotch
clinch	13	39	1035	2	clinch
clutch	13	36	775	2	clutch
ditch	11	50	1509	2	_ditch
fitch	13	48	1687	2	_fitch
fletch	14	38	819	2	fletch
flinch	14	40	1010	2	flinch
glitches	14	29	666	2	glitches
glitz	15	49	1637	2	glit_z
glitzy	19	40	478	2	glitzy
glunch	12	5	535	2	glunch
grinch	12	3	848	2	grinch
grith	9	55	2037	2	grit_h
grutch	12	28	556	2	grutch
hitch	13	45	1547	2	_hitch
itch	9	56	1917	2	__itch
klatch	15	44	593	2	klatch
latch	10	46	2046	2	_latch
letch	10	52	1580	2	_letch
lich	9	62	3084	2	_li_ch
litchi	11	3	789	2	_litchi
pitch	12	50	1841	2	_pitch
quitch	20	3	641	2	quitch
slatch	11	45	1053	2	slatch
snitch	11	35	794	2	snitch
stitch	11	41	910	2	stitch
switch	14	45	891	2	switch
twitch	14	40	616	2	twitch
witch	13	45	1756	2	_witch
alit	4	61	5569	3	alit__
aliyah	12	39	749	3	aliyah
baith	10	80	2313	3	bait_h
batch	12	46	2010	3	_batch
bewitch	17	4	332	3	bewitch
birch	12	49	1402	3	_birch
bitchy	16	47	920	3	_bitchy
blanch	13	34	1085	3	blanch
bleach	13	36	1140	3	bleach
blench	13	37	1045	3	blench
blite	7	62	2535	3	blit_e
blites	8	47	2121	3	blites
blithe	11	58	1086	3	blithe
blitz	16	53	1813	3	blit_z
blotchy	17	29	397	3	blotchy
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	1124	3	chinch
cinch	12	45	1624	3	_cinch
clach	12	46	1782	3	cl_ach
clench	13	39	1005	3	clench
cliche	13	37	1245	3	cli_che
click	13	52	1795	3	cli_ck
clitic	10	33	1505	3	clitic
clitics	11	27	997	3	clitics
cloth	10	58	1754	3	clot_h
clutchy	17	32	389	3	clutchy
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
eldritch	14	4	148	3	eldritch
elite	5	62	3018	3	elit_e
elites	6	60	2712	3	elites
eolith	9	30	1390	3	eolit_h
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
filth	11	50	1582	3	filt_h
finch	13	54	1697	3	_finch
fitchy	17	43	762	3	_fitchy
fleech	14	36	734	3	fleech
flench	14	40	1081	3	flench
flic	9	62	2373	3	fli_c_
flick	14	50	1721	3	fli_ck
flics	10	54	1836	3	fli_cs
flit	7	65	3927	3	flit__
flitched	17	25	629	3	flitched
flitches	16	38	846	3	flitches
flite	8	54	2496	3	flit_e
flited	10	46	1658	3	flited
flites	9	51	2244	3	flites
flits	8	56	2522	3	flit_s
flysch	17	3	289	3	flysch
frith	11	59	2203	3	frit_h
gait	5	61	5019	3	gait__
gaited	8	44	1692	3	gaited
gaiter	7	38	1950	3	gaiter
gaits	6	57	2601	3	gait_s
garth	9	47	2022	3	gart_h
gilt	5	63	4854	3	gilt__
gilts	6	49	2426	3	gilt_s
girsh	9	53	1002	3	g_irsh
girth	9	56	1884	3	g_irth
git	4	62	6605	3	g_it__
gite	5	54	3861	3	g_it_e
gites	6	56	3018	3	g_ites
gits	5	57	4459	3	g_it_s
glace	8	74	2016	3	gl_ace
glance	9	43	1231	3	glance
glia	5	64	2315	3	gli__a
glial	6	67	1543	3	gli_al
glias	6	46	1849	3	gli_as
glib	7	94	2144	3	gli__b
glibly	12	3	629	3	glibly
glide	7	45	2159	3	gli_de
glided	9	45	1390	3	glided
glider	8	46	1426	3	glider
glides	8	45	1886	3	glides
gliff	12	49	1566	3	gli_ff
gliffs	13	43	632	3	gliffs
glim	7	60	2635	3	gli__m
glime	8	56	2019	3	gli_me
glimed	10	53	1228	3	glimed
glimes	9	47	1752	3	glimes
glims	8	74	1767	3	gli_ms
glint	6	68	3018	3	gli_nt
glinted	9	39	937	3	glinted
glints	7	57	1421	3	glints
glinty	10	69	1069	3	glinty
glioma	9	3	595	3	glioma
glisten	8	41	808	3	glisten
glister	8	40	1334	3	glister
glitchier	15	4	279	3	glitch~~ier~~
glitter	8	42	1180	3	glitter
glitzed	18	37	549	3	glitzed
glitzes	17	36	756	3	glitzes
glut	5	63	3129	3	glut__
glute	6	60	2090	3	glut_e
glutei	7	40	974	3	glutei
gluten	7	42	1075	3	gluten
glutes	7	45	1767	3	glutes
gluts	6	61	2013	3	glut_s
glyph	14	5	647	3	gl_yph
goiter	7	41	1620	3	goiter
goitre	7	34	900	3	goitre
goliath	11	4	593	3	goliath
gotcha	12	3	463	3	g_otcha
goth	8	68	2508	3	g_ot_h
grit	5	52	4724	3	grit__
griths	10	52	1165	3	griths
grits	6	55	2958	3	grit_s
gritty	10	33	840	3	gritty
grouch	12	31	847	3	grouch
guitar	7	11	744	3	guitar
gulch	11	38	1060	3	g_ulch
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
iliac	7	50	1349	3	iliac_
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
klatsch	16	5	168	3	klatsch
klick	10	53	1143	3	kli_ck
kvetch	18	3	299	3	kvetch
laich	10	59	2071	3	_laich
laith	8	57	2210	3	lait_h
larch	10	59	1979	3	_larch
lath	7	66	4038	3	_lat_h
leach	10	54	2252	3	_leach
lech	9	68	2544	3	_l_ech
leech	10	49	1321	3	_leech
lice	6	60	4506	3	_li_ce
lichi	10	44	1295	3	_li_chi
licht	10	47	2349	3	_li_cht
lick	10	69	3507	3	_li_ck
lit	3	93	7731	3	_lit__
litai	5	52	1636	3	_litai
litas	5	49	2377	3	_litas
litchis	12	3	837	3	_litchis
lite	4	70	5454	3	_lit_e
liter	5	47	3634	3	_liter
lithe	8	49	2201	3	_lithe
litho	8	65	1378	3	_litho
litre	5	54	2146	3	_litre
lits	4	62	5249	3	_lit_s
litu	4	76	3156	3	_lit_u
loach	10	51	1636	3	_loach
loch	9	55	2713	3	_l_och
lotah	8	53	1585	3	_lotah
loth	7	61	3213	3	_lot_h
lunch	10	49	1724	3	_lunch
lurch	10	48	1463	3	_lurch
lych	12	60	1576	3	_l_ych
lynch	13	46	898	3	_lynch
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
oolith	9	38	1324	3	oolit_h
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
planch	13	37	1144	3	planch
pleach	13	42	1124	3	pleach
plench	13	40	1081	3	plench
plica	9	6	1337	3	pli_ca
plinth	11	3	1045	3	plinth
ratch	10	42	2136	3	_ratch
retch	10	48	1830	3	_retch
rich	9	70	2554	3	_ri_ch
rotch	10	58	1593	3	_rotch
saith	8	58	2655	3	sait_h
scotch	13	20	752	3	scotch
scutch	13	24	708	3	scutch
sith	7	54	3515	3	_sit_h
sketch	15	3	536	3	sketch
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
smirch	13	5	646	3	smirch
smith	10	78	1805	3	smit_h
smutch	13	20	584	3	smutch
snatch	11	43	1060	3	snatch
splotch	14	4	285	3	splotch
stich	10	41	1792	3	sti_ch
swatch	14	54	928	3	swatch
swith	11	59	1740	3	swit_h
thatch	14	3	561	3	thatch
tilth	8	55	1536	3	tilt_h
twitchy	18	39	357	3	twitchy
unhitch	15	4	305	3	unhitch
unlatch	12	4	505	3	unlatch
vetch	13	44	1184	3	_vetch
watch	13	56	1706	3	_watch
which	16	39	1008	3	whi_ch
wich	12	57	2474	3	_wi_ch
winch	13	50	1666	3	_winch
witchy	17	46	859	3	_witchy
with	10	57	3047	3	_wit_h
wretch	14	32	653	3	wretch
zilch	19	43	812	3	_zilch
zlotych	24	4	141	3	zlotych

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.403	443402.0
2	DLD Change Limit	112716	256	5.533	20371.6
3	Display Results	256	256	0.076	3368.4
	(SQL Overall)	178691	256	6.012	29722.4