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

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

385 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
patchy	16	50	957	(None)
catchy	16	55	958	1	catchy
patch	12	52	2122	1	patch_
pitchy	16	47	967	1	pitchy
achy	12	63	1609	2	_a_chy
apathy	14	3	703	2	apat_hy
batch	12	46	2010	2	batch_
bitchy	16	47	920	2	bitchy
botchy	16	53	782	2	botchy
catch	12	51	2037	2	catch_
datcha	12	6	656	2	datcha
eparchy	17	20	475	2	eparchy
fitchy	17	43	762	2	fitchy
hatch	13	57	1959	2	hatch_
itchy	13	44	901	2	_itchy
latch	10	46	2046	2	latch_
lathy	11	52	1506	2	lat_hy
match	12	56	2110	2	match_
natch	10	50	1822	2	natch_
pacey	12	67	2028	2	pa_cey
pacha	12	65	1806	2	pa_cha
pacy	11	53	2868	2	pa_c_y
parch	12	51	2300	2	parch_
patched	15	35	1462	2	patched
patcher	14	35	1514	2	patcher
patches	14	33	2038	2	patches
patchily	18	8	581	2	patchily
path	9	91	3491	2	pat_h_
paths	10	55	2138	2	pat_hs
patly	10	50	2058	2	pat_ly
patsy	10	57	1720	2	pat_sy
patty	10	47	2361	2	pat_ty
paty	9	52	3456	2	pat__y
paunchy	17	32	444	2	paunchy
peachy	16	45	1084	2	peachy
pitch	12	50	1841	2	pitch_
pithy	13	56	1446	2	pit_hy
poachy	16	38	896	2	poachy
pouchy	16	53	866	2	pouchy
punchy	16	39	852	2	punchy
ratch	10	42	2136	2	ratch_
snatchy	15	35	529	2	snatchy
tetchy	14	3	600	2	tetchy
thatchy	18	3	330	2	thatchy
watch	13	56	1706	2	watch_
witchy	17	46	859	2	witchy
ache	9	68	2982	3	_a_che
aitch	10	52	1616	3	aitch_
anarchy	15	4	493	3	anarchy
ancho	10	45	1530	3	_ancho
apache	13	42	1077	3	apache
aptly	10	51	1181	3	apt_ly
arch	9	86	2844	3	_arch_
archly	14	3	735	3	_archly
ashy	10	77	1735	3	_a_shy
ataxy	15	3	731	3	_ataxy
atomy	10	74	1519	3	_atomy
atony	8	72	1885	3	_atony
atopy	10	68	1339	3	_atopy
bach	11	61	3139	3	ba_ch_
batboy	13	8	753	3	batboy
batched	15	41	1424	3	batched
batcher	14	44	1485	3	batcher
batches	14	40	1961	3	batches
bath	9	59	4008	3	bat_h_
bathe	10	58	2288	3	bat_he
baths	10	59	2292	3	bat_hs
batty	10	54	2224	3	bat_ty
beachy	16	40	1125	3	beachy
beechy	16	39	750	3	beechy
bitch	12	50	1776	3	bitch_
blotchy	17	29	397	3	blotchy
botch	12	67	1745	3	botch_
bothy	13	67	1396	3	bot_hy
branchy	17	35	791	3	branchy
bunchy	16	43	746	3	bunchy
butch	12	54	1654	3	butch_
cache	12	51	2248	3	ca_che
cancha	13	44	1161	3	cancha
catcher	14	31	1582	3	catcher
catches	14	43	2077	3	catches
catchfly	21	4	333	3	catchfly
catchup	16	4	479	3	catchup
catechu	14	4	447	3	catechu
catty	10	45	2041	3	cat_ty
clutchy	17	32	389	3	clutchy
conchy	16	37	1022	3	conchy
cratch	13	41	1079	3	cratch_
cutch	12	51	1619	3	cutch_
dacha	11	48	1257	3	da_cha
dashy	12	56	1238	3	da_shy
datary	10	3	1024	3	datary
datchas	13	4	742	3	datchas
deathy	13	42	1023	3	deat_hy
diarchy	16	4	467	3	diarchy
ditch	11	50	1509	3	ditch_
duchy	14	43	1087	3	_duchy
dutch	11	47	1382	3	dutch_
dyarchy	19	4	250	3	dyarchy
each	9	55	3058	3	ea_ch_
earthy	12	39	994	3	earthy
eatery	9	53	1635	3	eatery
eath	7	57	3566	3	eat_h_
empathy	17	4	348	3	empat_hy
eparch	13	25	842	3	eparch_
eparchs	14	19	624	3	eparchs
etch	9	54	1914	3	_etch_
exarchy	22	19	369	3	exarchy
fancy	13	46	1548	3	fanc_y
farcy	13	52	1709	3	farc_y
fatly	11	57	1680	3	fat_ly
fatty	11	51	1741	3	fat_ty
fetch	13	49	1347	3	fetch_
fitch	13	48	1687	3	fitch_
gauche	12	3	855	3	gauche
gaucho	12	5	622	3	gaucho
glitchy	16	28	308	3	glitchy
gotcha	12	3	463	3	gotcha
hatched	16	34	1446	3	hatched
hatchel	15	35	1075	3	hatchel
hatcher	15	33	1472	3	hatcher
hatchery	19	32	638	3	hatchery
hatches	15	34	2027	3	hatches
hatchet	15	33	1756	3	hatchet
hatchway	22	4	329	3	hatchway
hath	10	59	3391	3	hat_h_
heathy	15	61	1121	3	heat_hy
hitch	13	45	1547	3	hitch_
hotch	13	62	1473	3	hotch_
hutch	13	54	1409	3	hutch_
itch	9	56	1917	3	_itch_
jacky	21	54	1234	3	ja_cky
ketch	14	49	1202	3	ketch_
kitschy	19	4	198	3	kitschy
klatch	15	44	593	3	klatch_
kvetchy	22	4	180	3	kvetchy
lacey	10	58	2091	3	la_cey
lacy	9	58	2963	3	la_c_y
laich	10	59	2071	3	laich_
laichs	11	51	1089	3	laichs
larch	10	59	1979	3	larch_
latched	13	39	1406	3	latched
latches	12	33	2012	3	latches
latchet	12	31	1790	3	latchet
latchkey	20	4	291	3	latchkey
lately	9	34	1384	3	lately
lath	7	66	4038	3	lat_h_
lathe	8	56	2671	3	lat_he
lathi	8	54	1720	3	lat_hi
laths	8	60	2240	3	lat_hs
leachy	14	41	973	3	leachy
letch	10	52	1580	3	letch_
litchi	11	3	789	3	litchi
mach	11	61	3448	3	ma_ch_
mache	12	59	2530	3	ma_che
macho	12	61	2015	3	ma_cho
machs	12	57	2256	3	ma_chs
manche	13	35	1510	3	manche
march	12	56	2289	3	march_
marshy	14	55	833	3	marshy
mashy	13	60	1650	3	ma_shy
matched	15	35	1396	3	matched
matcher	14	32	1428	3	matcher
matches	14	32	1978	3	matches
matchup	16	4	351	3	matchup
matey	10	70	2266	3	mat_ey
math	9	54	3745	3	mat_h_
maths	10	56	2402	3	mat_hs
mothy	13	62	1455	3	mot_hy
mutch	12	50	1617	3	mutch_
mythy	16	56	867	3	myt_hy
nacho	10	54	1438	3	na_cho
nancy	10	52	1492	3	nanc_y
natty	8	57	1914	3	nat_ty
nautch	11	4	481	3	nautch_
notch	10	56	1332	3	notch_
oath	7	61	3215	3	oat_h_
oaths	8	61	1731	3	oat_hs
outcry	11	3	799	3	outcry
pac	7	90	5408	3	pa_c__
paca	8	51	3224	3	pa_c_a
pacas	9	60	2940	3	pa_cas
pace	8	63	4577	3	pa_c_e
paced	10	69	3168	3	pa_ced
pacer	9	61	3161	3	pa_cer
paces	9	67	4111	3	pa_ces
pachas	13	50	1714	3	pa_chas
pacify	16	6	747	3	pacify
pack	12	55	3544	3	pa_c_k
packly	17	22	833	3	packly
packs	13	55	2893	3	pa_cks
pacs	8	58	4218	3	pa_c_s
pact	8	66	4872	3	pa_c_t
pacts	9	51	2580	3	pa_cts
paddy	12	59	1359	3	pa_ddy
pah	8	88	5359	3	pa__h_
painch	13	35	1132	3	painch_
painty	11	47	1475	3	painty
pakeha	15	3	393	3	pakeha
palely	11	3	1193	3	palely
pally	10	57	2712	3	pa_lly
palmy	12	60	1673	3	pa_lmy
palsy	10	54	1746	3	pa_lsy
paltry	11	49	1040	3	paltry
paly	9	58	3553	3	pa__ly
panache	14	5	842	3	panache
panchax	21	3	498	3	panchax
pandy	11	50	2117	3	pa_ndy
panfry	14	45	641	3	panfry
panicky	18	3	385	3	panicky
panocha	14	4	498	3	panocha
panoche	14	5	638	3	panoche
pansy	10	57	1797	3	pa_nsy
pantry	11	50	1410	3	pantry
panty	10	59	2930	3	pa_nty
papacy	15	4	749	3	papacy
papery	13	48	1274	3	papery
pappy	11	47	1380	3	pa_ppy
parcel	10	39	1547	3	parcel
parched	15	40	1369	3	parched
parches	14	37	2000	3	parches
pardy	11	55	2395	3	pa_rdy
parity	11	47	1987	3	parity
parlay	11	37	1399	3	parlay
parley	11	67	1836	3	parley
parody	12	4	1009	3	parody
parry	10	53	2375	3	pa_rry
partly	11	63	1547	3	partly
partway	15	3	592	3	partway
party	10	66	3061	3	pa_rty
pascal	10	8	1237	3	pascal
paschal	14	15	724	3	paschal
pash	9	56	3813	3	pa_sh_
pasha	10	54	1718	3	pa_sha
pastiche	15	4	693	3	pastiche
pastry	11	49	1303	3	pastry
pasty	10	57	2505	3	pa_sty
pat	5	80	8946	3	pat___
pataca	10	3	1119	3	pataca
patacas	11	3	1100	3	patacas
patchers	15	34	1330	3	patchers
patchier	15	31	966	3	patchier
patching	16	32	1275	3	patching
patchouly	19	4	292	3	patch~~oul~~y
pate	6	53	5046	3	pat__e
pated	8	52	3784	3	pat_ed
paten	7	48	2734	3	pat_en
patency	14	6	631	3	patency
patens	8	48	2086	3	patens
patent	8	45	2492	3	patent
pater	7	47	4072	3	pat_er
paters	8	49	3583	3	paters
pates	7	60	4789	3	pat_es
pathos	11	55	1669	3	pathos
pathway	18	4	485	3	pathway
patin	7	68	3285	3	pat_in
patina	8	60	2219	3	patina
patine	8	53	2812	3	patine
patins	8	75	2878	3	patins
patio	7	44	2635	3	pat_io
patios	8	52	2178	3	patios
patois	8	43	1936	3	patois
patrol	8	32	1302	3	patrol
patron	8	40	1804	3	patron
pats	6	64	6085	3	pat__s
patted	9	47	2468	3	patted
pattee	8	43	2338	3	pattee
patten	8	44	1819	3	patten
patter	8	46	2826	3	patter
pattie	8	40	2096	3	pattie
patzer	17	31	1164	3	patzer
paucity	14	3	582	3	paucity
paughty	16	29	432	3	paughty
paunch	13	36	985	3	paunch_
pawky	17	38	1015	3	pa_wky
pay	8	84	6118	3	pa___y
payday	15	3	661	3	payday
peach	12	54	2249	3	peach_
peaty	10	57	2569	3	peat__y
pech	11	61	2545	3	p_ech_
pechs	12	55	1620	3	p_echs
pecky	16	55	1509	3	p_ecky
perch	12	45	1883	3	perch_
petty	10	53	2029	3	pet_ty
picky	16	54	1694	3	p_icky
pinch	12	56	1930	3	pinch_
pitched	15	35	1292	3	pitched
pitcher	14	38	1371	3	pitcher
pitches	14	36	1775	3	pitches
pitchily	18	5	501	3	pitchily
pith	9	54	3269	3	pit_h_
piths	10	58	1754	3	pit_hs
pity	9	60	3193	3	pit__y
planch	13	37	1144	3	planch_
planche	14	29	975	3	planche
plashy	14	44	887	3	plashy
platy	10	50	2166	3	plat__y
plucky	17	40	658	3	plucky
plushy	14	40	697	3	plushy
poach	12	49	1786	3	poach_
pocky	16	53	1460	3	p_ocky
poncho	13	33	1012	3	poncho
pooch	12	48	1530	3	pooch_
porch	12	59	1862	3	porch_
potboy	13	9	781	3	potboy
potiche	14	3	804	3	potiche
potsy	10	58	1561	3	pot_sy
potty	10	56	2100	3	pot_ty
pouch	12	46	1708	3	pouch_
preachy	17	30	731	3	preachy
pricey	13	44	1263	3	pricey
pricky	17	42	1034	3	pricky
pricy	12	48	1456	3	pric_y
psych	15	5	496	3	psych_
psyche	16	7	429	3	psyche
psycho	16	7	453	3	psycho
psychs	16	5	365	3	psychs
punch	12	51	1842	3	punch_
pushy	13	46	1435	3	p_ushy
putsch	13	3	493	3	putsch_
putty	10	47	2140	3	put_ty
racy	9	58	2568	3	ra_c_y
ranch	10	50	1979	3	ranch_
rancho	11	43	1085	3	rancho
ratany	9	34	1187	3	ratany
ratches	12	36	2046	3	ratches
ratchet	12	42	1833	3	ratchet
rath	7	60	3766	3	rat_h_
rathe	8	58	2192	3	rat_he
ratify	12	26	1004	3	ratify
rattly	9	41	1154	3	rattly
ratty	8	48	1959	3	rat_ty
raunchy	15	28	431	3	raunchy
reechy	14	36	782	3	reechy
repatch	14	3	584	3	repatch_
retch	10	48	1830	3	retch_
rotch	10	58	1593	3	rotch_
rotche	11	43	1198	3	rotche
satay	8	47	1846	3	sat_ay
satchel	12	33	1030	3	satchel
satiny	9	38	1798	3	satiny
sauch	10	49	1877	3	sauch_
sauchs	11	51	1223	3	sauchs
saucy	10	46	1516	3	sauc_y
saughy	13	50	746	3	saughy
scratchy	18	4	365	3	scratchy
sketchy	19	4	305	3	sketchy
slatch	11	45	1053	3	slatch_
smutchy	17	19	315	3	smutchy
snatch	11	43	1060	3	snatch_
spacey	13	62	1253	3	spa_cey
spacy	12	54	1562	3	spa_c_y
spathe	11	51	1569	3	spat_he
splotchy	18	4	179	3	splotchy
starchy	15	28	674	3	starchy
swatch	14	54	928	3	swatch_
tach	9	61	3275	3	ta_ch_
tache	10	62	2237	3	ta_che
tachs	10	58	2093	3	ta_chs
tacky	14	56	1744	3	ta_cky
talcky	15	29	472	3	talcky
tatty	8	47	2018	3	tat_ty
techy	13	56	1201	3	_techy
thatch	14	3	561	3	thatch_
thy	9	70	2291	3	__t_hy
torchy	14	54	953	3	torchy
touchy	14	50	1050	3	touchy
twitchy	18	39	357	3	twitchy
uncatchy	18	4	256	3	uncatchy
vetch	13	44	1184	3	vetch_
vichy	16	3	904	3	_vichy
wacky	17	47	1493	3	wa_cky
washy	14	59	1184	3	wa_shy
watchcry	21	4	236	3	watchcry
watched	16	30	1282	3	watched
watcher	15	31	1340	3	watcher
watches	15	30	1737	3	watches
watcheye	19	10	427	3	watcheye
watery	12	39	1449	3	watery
waucht	14	39	941	3	waucht
witch	13	45	1756	3	witch_
withy	14	48	1376	3	wit_hy
wrathy	15	37	785	3	wrat_hy
yacht	13	4	1739	3	ya_cht
yechy	16	51	908	3	_yechy

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.750	238254.7
2	DLD Change Limit	112716	385	5.843	19290.8
3	Display Results	385	385	0.110	3500.0
	(SQL Overall)	178691	385	6.703	26658.4