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

Here are the results of your fuzzy-string dictionary search for “fletch” 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
fletch	14	38	819	(None)
fetch	13	49	1347	1	f_etch
fleech	14	36	734	1	fleech
flench	14	40	1081	1	flench
flitch	14	92	817	1	flitch
letch	10	52	1580	1	_letch
bleach	13	36	1140	2	bleach
blench	13	37	1045	2	blench
blotch	13	19	714	2	blotch
clench	13	39	1005	2	clench
clutch	13	36	775	2	clutch
etch	9	54	1914	2	__etch
fetich	14	7	969	2	f_etich
fitch	13	48	1687	2	f_itch
fleche	14	29	930	2	fle_che
fleck	14	82	1359	2	fle_ck
fleece	11	36	990	2	fleece
fleecy	14	26	648	2	fleecy
flesh	11	50	1374	2	fle_sh
fletched	17	30	669	2	fletched
fletcher	16	30	666	2	fletcher
fletches	16	30	885	2	fletches
flinch	14	40	1010	2	flinch
flysch	17	3	289	2	flysch
french	14	35	1121	2	french
glitch	12	28	635	2	glitch
ketch	14	49	1202	2	_ketch
klatch	15	44	593	2	klatch
kvetch	18	3	299	2	kvetch
latch	10	46	2046	2	_latch
leach	10	54	2252	2	_leach
lech	9	68	2544	2	_le_ch
leech	10	49	1321	2	_leech
pleach	13	42	1124	2	pleach
plench	13	40	1081	2	plench
retch	10	48	1830	2	_retch
sketch	15	3	536	2	sketch
slatch	11	45	1053	2	slatch
vetch	13	44	1184	2	_vetch
wretch	14	32	653	2	wretch
aitch	10	52	1616	3	_aitch
alec	6	64	3006	3	ale_c_
alecs	7	66	2073	3	ale_cs
aleph	10	3	1139	3	ale_ph
batch	12	46	2010	3	_batch
beach	12	46	2389	3	_beach
beech	12	43	1550	3	_beech
belch	12	44	1550	3	_belch
bench	12	56	1950	3	_bench
beth	9	66	2923	3	_bet_h
bitch	12	50	1776	3	_bitch
blanch	13	34	1085	3	blanch
blet	6	62	4767	3	blet__
blets	7	53	2494	3	blet_s
blotchy	17	29	397	3	blotchy
botch	12	67	1745	3	_botch
breach	13	42	1372	3	breach
breech	13	34	826	3	breech
butch	12	54	1654	3	_butch
catch	12	51	2037	3	_catch
chetah	14	39	958	3	chetah
cheth	13	50	1382	3	chet_h
clach	12	46	1782	3	cl_ach
clinch	13	39	1035	3	clinch
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
daleth	10	3	863	3	dalet_h
detach	12	3	1041	3	_detach
ditch	11	50	1509	3	_ditch
doeth	9	4	1198	3	doet_h
dreich	12	37	772	3	dreich
drench	12	36	959	3	drench
dutch	11	47	1382	3	_dutch
each	9	55	3058	3	__each
elect	7	43	2703	3	ele_ct
elects	8	33	1500	3	elects
elenchi	12	4	471	3	elenchi
eth	6	66	3098	3	__et_h
faith	11	56	2085	3	fait_h
feck	13	49	2343	3	f_e_ck
feet	7	53	5221	3	feet__
feh	9	61	3609	3	f_e__h
fellah	12	49	1077	3	fellah
felt	7	51	4693	3	felt__
felted	10	37	1465	3	felted
felts	8	53	2454	3	felt_s
fence	10	53	1991	3	f_ence
fet	6	64	7163	3	f_et__
feta	7	65	2890	3	f_et_a
fetal	8	56	2337	3	f_etal
fetas	8	56	2440	3	f_etas
fetched	16	37	1047	3	f_etched
fetcher	15	35	1039	3	f_etcher
fetches	15	34	1389	3	f_etches
fete	7	57	3492	3	f_et_e
feted	9	44	2093	3	f_eted
fetes	8	56	3014	3	f_etes
fetid	9	37	1598	3	f_etid
fetish	12	3	1037	3	f_etish
fetor	8	12	1453	3	f_etor
fets	7	53	4594	3	f_et_s
fetus	8	58	1654	3	f_etus
fierce	11	34	891	3	fierce
fifth	14	52	1092	3	fift_h
filch	13	48	1332	3	f_ilch
filet	8	55	4016	3	filet__
fileted	11	5	909	3	fileted
filets	9	47	1895	3	filet_s
filth	11	50	1582	3	filt_h
finch	13	54	1697	3	f_inch
firth	11	58	1953	3	firt_h
fitchy	17	43	762	3	f_itchy
flack	14	45	1941	3	fl_ack
flash	11	57	1621	3	fl_ash
flat	7	71	4782	3	flat__
flatcap	14	6	365	3	flatcap
flatcar	12	7	461	3	flatcar
flatly	12	31	1021	3	flatly
flats	8	64	2974	3	flat_s
flatus	9	43	1078	3	flatus
flea	7	56	2849	3	fle__a
fleam	10	60	1728	3	fle_am
fleams	11	50	1194	3	fleams
fleas	8	64	2366	3	fle_as
fleches	15	34	1144	3	fle_ches
flecks	15	43	1080	3	flecks
flecky	18	38	765	3	flecky
fled	8	54	2977	3	fle__d
fledge	11	43	929	3	fledge
fledgy	14	41	491	3	fledgy
flee	7	62	3879	3	fle__e
fleeced	13	35	815	3	fleeced
fleecer	12	36	803	3	fleecer
fleeces	12	39	964	3	fleeces
fleeched	17	34	582	3	fleeched
fleeches	16	28	708	3	fleeches
fleer	8	60	2077	3	fle_er
fleers	9	60	1579	3	fleers
flees	8	58	2875	3	fle_es
fleet	8	59	3233	3	fle_et
fleeted	11	33	1023	3	fleeted
fleeter	10	32	1036	3	fleeter
fleetly	13	3	631	3	fleetly
fleets	9	69	1506	3	fleets
flemish	15	3	637	3	flemish
flenched	17	26	796	3	flenched
flenches	16	34	1053	3	flenches
flense	9	3	890	3	flense
fleshy	15	40	628	3	fleshy
fletchers	17	33	553	3	fletch~~ers~~
fletching	18	25	614	3	fletch~~ing~~
fleury	12	41	735	3	fleury
flew	10	58	2425	3	fle__w
flews	11	53	1644	3	fle_ws
flex	14	61	2347	3	fle__x
flexed	17	41	908	3	flexed
flexes	16	45	1295	3	flexes
flexor	16	3	450	3	flexor
fley	10	66	2685	3	fle__y
fleyed	13	40	881	3	fleyed
fleys	11	70	1560	3	fle_ys
flic	9	62	2373	3	fl_ic_
flick	14	50	1721	3	fl_ick
flics	10	54	1836	3	fl_ics
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
floc	9	59	2212	3	fl_oc_
flocci	13	3	502	3	flocci
flock	14	47	1742	3	fl_ock
flocs	10	55	1923	3	fl_ocs
flota	8	53	1564	3	flot_a
flotas	9	40	1300	3	flotas
fluency	15	4	535	3	fluency
fluish	12	3	933	3	fluish
flush	11	51	1607	3	fl_ush
flute	8	68	2375	3	flut_e
fluted	10	49	1716	3	fluted
fluter	9	53	1686	3	fluter
flutes	9	54	2178	3	flutes
flutey	12	52	1252	3	flutey
fluty	11	44	1564	3	flut_y
flyte	11	57	1394	3	flyt_e
flyted	13	37	877	3	flyted
flytes	12	39	1156	3	flytes
foetal	9	3	1188	3	foetal
foetid	10	5	1051	3	foetid
foetor	9	3	956	3	foetor
foetus	9	5	852	3	foetus
forth	11	62	2267	3	fort_h
fresco	11	3	647	3	fresco
fresh	11	50	1220	3	fre_sh
fret	7	58	4504	3	fret__
frets	8	55	2340	3	fret_s
fretty	12	4	922	3	fretty
frith	11	59	2203	3	frit_h
froth	11	59	1928	3	frot_h
glitchy	16	28	308	3	glitchy
glunch	12	5	535	3	glunch
grutch	12	28	556	3	grutch
hatch	13	57	1959	3	_hatch
heth	10	70	2802	3	_het_h
heuch	13	53	1233	3	_heuch
hitch	13	45	1547	3	_hitch
hootch	14	38	641	3	hootch
hotch	13	62	1473	3	_hotch
hutch	13	54	1409	3	_hutch
ileac	7	58	1417	3	ileac_
itch	9	56	1917	3	__itch
kench	14	55	1392	3	_kench
kheth	15	50	975	3	khet_h
klatsch	16	5	168	3	klatsch
kvetchy	22	4	180	3	kvetchy
laich	10	59	2071	3	_laich
larch	10	59	1979	3	_larch
lath	7	66	4038	3	_lat_h
leachy	14	41	973	3	_leachy
leash	8	55	1921	3	_leash
let	3	64	8147	3	_let__
letched	13	39	1205	3	_letched
letches	12	40	1548	3	_letches
lethe	8	57	1730	3	_lethe
lets	4	71	4794	3	_let_s
letup	7	37	1216	3	_letup
lich	9	62	3084	3	_l_ich
litchi	11	3	789	3	_litchi
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
merch	12	54	1796	3	_merch
meth	9	58	2784	3	_met_h
mutch	12	50	1617	3	_mutch
natch	10	50	1822	3	_natch
nautch	11	4	481	3	nautch
notch	10	56	1332	3	_notch
oleic	7	3	1333	3	oleic_
patch	12	52	2122	3	_patch
peach	12	54	2249	3	_peach
pech	11	61	2545	3	_pe_ch
perch	12	45	1883	3	_perch
pitch	12	50	1841	3	_pitch
planch	13	37	1144	3	planch
preach	13	36	1392	3	preach
quench	20	3	663	3	quench
quitch	20	3	641	3	quitch
ratch	10	42	2136	3	_ratch
reach	10	51	2388	3	_reach
rotch	10	58	1593	3	_rotch
scotch	13	20	752	3	scotch
scutch	13	24	708	3	scutch
sheuch	14	26	704	3	sheuch
sketchy	19	4	305	3	sketchy
sleigh	10	25	820	3	sleigh
sleuth	9	3	723	3	sleuth
sloth	8	50	1945	3	slot_h
slouch	11	43	852	3	slouch
smutch	13	20	584	3	smutch
snatch	11	43	1060	3	snatch
snitch	11	35	794	3	snitch
speech	13	4	756	3	speech
splotch	14	4	285	3	splotch
stench	11	41	1116	3	stench
stitch	11	41	910	3	stitch
stretch	12	3	641	3	stretch
swatch	14	54	928	3	swatch
switch	14	45	891	3	switch
teach	10	52	2112	3	_teach
tech	9	59	2544	3	_te_ch
teeth	8	73	1585	3	teet_h
tench	10	56	2000	3	_tench
tetchy	14	3	600	3	_tetchy
teth	7	63	2789	3	_tet_h
teuch	10	52	1485	3	_teuch
thatch	14	3	561	3	thatch
trench	11	42	1161	3	trench
twitch	14	40	616	3	twitch
unlatch	12	4	505	3	unlatch
watch	13	56	1706	3	_watch
welch	13	44	1149	3	_welch
wench	13	62	1478	3	_wench
witch	13	45	1756	3	_witch
wrench	14	43	935	3	wrench
yecch	15	55	809	3	_yecch
yech	12	72	2053	3	_ye_ch
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.140	1276364.3
2	DLD Change Limit	112716	300	4.966	22697.5
3	Display Results	300	300	0.096	3125.0
	(SQL Overall)	178691	300	5.202	34350.4