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

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

324 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
panfry	14	45	641	(None)
pantry	11	50	1410	1	pantry
angry	9	3	1087	2	_angry
canary	11	3	1469	2	canary
gantry	10	38	1011	2	gantry
palfrey	15	3	334	2	palfrey
paltry	11	49	1040	2	paltry
pandy	11	50	2117	2	pan_dy
panful	11	7	974	2	panful
pansy	10	57	1797	2	pan_sy
panty	10	59	2930	2	pan_ty
papery	13	48	1274	2	papery
parry	10	53	2375	2	pa_rry
pastry	11	49	1303	2	pastry
penury	11	4	810	2	penury
pinery	11	52	1429	2	pinery
aery	7	72	3168	3	_a_ery
affray	15	3	497	3	_affray
airy	7	57	3416	3	_a_iry
alary	8	61	2344	3	_alary
ambry	12	35	1210	3	_ambry
andro	6	3	1416	3	_andro
anergy	10	15	686	3	_anergy
angary	10	3	1132	3	_angary
annoy	8	6	971	3	_annoy
anomy	10	51	1339	3	_anomy
antra	5	65	2192	3	_antra
antre	5	52	2452	3	_antre
antsy	8	57	1279	3	_antsy
any	6	84	4049	3	_an__y
apery	10	65	1790	3	_apery
apiary	11	39	1038	3	apiary
awry	10	76	1968	3	_a_wry
baffy	16	55	1192	3	ba_ffy
bakery	15	59	1100	3	bakery
bandy	11	48	2419	3	ban_dy
banty	10	66	2400	3	ban_ty
barfly	14	33	965	3	barfly
bawdry	15	51	646	3	bawdry
beanery	12	3	756	3	beanery
belfry	14	3	507	3	belfry
binary	11	3	1222	3	binary
calory	11	3	1284	3	calory
canard	9	3	1476	3	canard
candy	11	51	1982	3	can_dy
caner	7	53	3477	3	caner_
caners	8	46	2920	3	caners
canful	11	6	1026	3	canful
cannery	12	36	1001	3	cannery
canny	10	58	1769	3	can_ny
canonry	12	3	592	3	canonry
canopy	13	3	773	3	canopy
canty	10	52	2680	3	can_ty
carry	10	58	2378	3	ca_rry
chantry	15	38	822	3	chantry
daffy	15	55	1028	3	da_ffy
dairy	9	70	1630	3	da_iry
dandy	10	44	1670	3	dan_dy
dangly	11	42	1227	3	dangly
dankly	14	41	946	3	dankly
datary	10	3	1024	3	datary
daubry	12	44	548	3	daubry
dayfly	16	3	381	3	dayfly
deanery	11	3	761	3	deanery
denary	10	53	1686	3	denary
eatery	9	53	1635	3	eatery
entry	8	24	1426	3	_entry
faery	11	60	1548	3	fa_ery
fairy	11	53	1828	3	fa_iry
fakery	16	50	926	3	fakery
fancy	13	46	1548	3	fan_cy
fanfare	13	3	667	3	fanfare
fanfic	14	3	631	3	fanfic
fanny	11	48	1604	3	fan_ny
finery	12	45	1289	3	finery
fry	9	62	2650	3	___fry
gadfly	14	3	466	3	gadfly
gangly	11	39	1159	3	gangly
gauntry	11	5	411	3	gauntry
gentry	10	34	1044	3	gentry
granary	11	5	779	3	granary
hairy	11	53	1683	3	ha_iry
handy	12	55	2087	3	han_dy
hanky	15	54	1829	3	han_ky
harry	11	53	2295	3	ha_rry
henry	11	40	1447	3	hen_ry
hungry	13	3	497	3	hungry
infra	8	3	864	3	_infra
jangly	17	43	1061	3	jangly
janty	15	68	1696	3	jan_ty
japery	18	43	914	3	japery
kaury	12	42	976	3	ka_ury
knarry	13	3	461	3	knarry
lanely	9	39	1448	3	lanely
laniary	10	6	801	3	laniary
lankly	13	43	962	3	lankly
lanky	12	55	1748	3	lan_ky
laundry	11	3	351	3	laundry
manful	11	6	1021	3	manful
mangey	12	36	1453	3	mangey
mangy	11	50	2125	3	man_gy
manly	10	50	2295	3	man_ly
manor	7	80	2393	3	manor_
manors	8	44	2088	3	manors
mantra	8	41	1609	3	mantra
manuary	12	3	777	3	manuary
manure	8	3	1365	3	manure
many	9	57	3186	3	man__y
marry	10	48	2169	3	ma_rry
mayfly	17	3	440	3	mayfly
nancy	10	52	1492	3	nan_cy
nanny	8	48	1381	3	nan_ny
napery	11	48	981	3	napery
nary	7	69	3122	3	__nary
onery	8	4	1412	3	_onery
ornery	9	3	846	3	ornery
pacer	9	61	3161	3	pacer_
pacers	10	51	2454	3	pacers
pacey	12	67	2028	3	pa_cey
pacify	16	6	747	3	pacify
packly	17	22	833	3	packly
pacy	11	53	2868	3	pa__cy
paddy	12	59	1359	3	pa_ddy
padre	8	60	1816	3	pa_dre
padri	8	58	1517	3	pa_dri
pager	8	47	2820	3	pager_
pagers	9	44	2325	3	pagers
painful	12	4	641	3	painful
painty	11	47	1475	3	painty
pair	6	60	3151	3	pa_ir_
pairs	7	53	2583	3	pa_irs
pakora	12	4	728	3	pakora
palely	11	3	1193	3	palely
paler	7	54	3694	3	paler_
palfreys	16	4	200	3	palfreys
pally	10	57	2712	3	pa_lly
palmary	14	33	855	3	palmary
palmy	12	60	1673	3	pa_lmy
palsy	10	54	1746	3	pa_lsy
paly	9	58	3553	3	pa__ly
pan	5	84	6645	3	pan___
panada	9	41	1305	3	panada
panama	10	42	1335	3	panama
panda	8	50	2261	3	pan_da
pandas	9	55	2196	3	pandas
pander	9	37	2553	3	pander
panders	10	34	2374	3	panders
pandit	9	38	2075	3	pandit
pandora	10	3	954	3	pandora
pandore	10	4	1185	3	pandore
pandura	10	3	714	3	pandura
pane	6	49	5029	3	pan__e
paned	8	54	3718	3	pan_ed
panel	7	60	2362	3	pan_el
panels	8	47	1652	3	panels
panes	7	61	4869	3	pan_es
panfish	15	22	998	3	panfish
panfried	14	13	493	3	panfried
panfries	13	14	921	3	panfries
panfrying	18	4	299	3	panfry~~ing~~
panfuls	12	3	718	3	panfuls
pang	7	53	3630	3	pan__g
panga	8	53	2354	3	pan_ga
pangas	9	99	2111	3	pangas
panged	10	47	2234	3	panged
pangen	9	41	1592	3	pangen
pangram	12	3	902	3	pangram
pangs	8	46	2867	3	pan_gs
panic	9	39	2390	3	pan_ic
panicky	18	3	385	3	panicky
panics	10	38	1536	3	panics
panier	8	44	2550	3	panier
paniers	9	47	1733	3	paniers
panini	8	3	1427	3	panini
panino	8	3	1568	3	panino
panne	7	66	2365	3	pan_ne
panned	9	41	2343	3	panned
panner	8	42	2476	3	panner
panners	9	36	2127	3	panners
pannes	8	55	2285	3	pannes
panoply	14	3	471	3	panoply
pans	6	58	5573	3	pan__s
pant	6	60	6126	3	pan__t
panted	9	50	2482	3	panted
pantie	8	43	2647	3	pantie
panto	7	61	2941	3	pan_to
pantos	8	52	2274	3	pantos
pants	7	65	3692	3	pan_ts
panzer	17	42	1323	3	panzer
panzers	18	40	1201	3	panzers
papacy	15	4	749	3	papacy
paper	9	51	2866	3	paper_
papers	10	51	2532	3	papers
pappy	11	47	1380	3	pa_ppy
papyri	13	3	490	3	papyri
par	5	74	6702	3	pa__r_
para	6	52	4218	3	pa__ra
pard	7	64	4132	3	pa__rd
pardy	11	55	2395	3	pa_rdy
pare	6	67	6084	3	pa__re
parer	7	58	3990	3	parer_
parers	8	55	3074	3	parers
parity	11	47	1987	3	parity
park	10	52	3749	3	pa__rk
parlay	11	37	1400	3	parlay
parley	11	67	1836	3	parley
parody	12	4	1009	3	parody
parr	6	57	3115	3	pa__rr
parrs	7	59	2867	3	pa_rrs
pars	6	75	6079	3	pa__rs
part	6	59	6746	3	pa__rt
partly	11	63	1547	3	partly
party	10	66	3061	3	pa_rty
parura	8	3	1059	3	parura
parure	8	3	1252	3	parure
pasty	10	57	2505	3	pa_sty
patchy	16	50	957	3	patchy
pater	7	47	4073	3	pater_
paters	8	49	3584	3	paters
patly	10	50	2058	3	pa_tly
patsy	10	57	1720	3	pa_tsy
patty	10	47	2361	3	pa_tty
paty	9	52	3456	3	pa__ty
paunchy	17	32	444	3	paunchy
paver	10	42	2583	3	paver_
pavers	11	50	2182	3	pavers
pawer	10	44	2297	3	pawer_
pawers	11	48	1878	3	pawers
pawky	17	38	1015	3	pa_wky
pawner	11	42	1292	3	pawner_
pawners	12	43	1107	3	pawners
pawnor	11	35	724	3	pawnor_
pawnors	12	29	720	3	pawnors
pay	8	84	6118	3	pa___y
payday	15	3	661	3	payday
payer	10	51	2572	3	payer_
payers	11	46	2182	3	payers
payor	10	54	1384	3	payor_
payors	11	43	1264	3	payors
pedantry	14	4	405	3	pedantry
peery	10	57	1944	3	p_eery
peltry	11	28	865	3	peltry
penny	10	51	1945	3	pen_ny
perry	10	52	2271	3	p_erry
piney	10	57	2750	3	pin_ey
pinkey	15	43	1467	3	pinkey
pinkly	15	50	1224	3	pinkly
pinky	14	58	2340	3	pin_ky
pinny	10	52	2206	3	pin_ny
piny	9	118	3836	3	pin__y
planar	8	42	1271	3	planar_
planer	8	41	2266	3	planer_
planers	9	45	1795	3	planers
planform	15	4	476	3	planform
plenary	12	3	754	3	plenary
poetry	11	3	938	3	poetry
pony	9	64	3405	3	pon__y
poofy	13	62	1327	3	poof_y
popery	13	45	1170	3	popery
pouffy	17	39	588	3	pouffy
predry	12	3	787	3	predry
priory	11	41	1026	3	priory
pry	8	57	2805	3	p___ry
psaltry	12	21	380	3	psaltry
puffery	18	23	511	3	puffery
puffy	16	44	1075	3	p_uffy
puggry	13	37	482	3	puggry
punchy	16	39	852	3	punchy
punily	11	3	1177	3	punily
punkey	15	40	1117	3	punkey
punky	14	44	1939	3	pun_ky
punny	10	42	1771	3	pun_ny
punty	10	60	2161	3	pun_ty
puny	9	55	2699	3	pun__y
randy	9	50	2208	3	ran_dy
rangy	9	53	2039	3	ran_gy
rankly	13	39	1045	3	rankly
refry	11	44	1246	3	_refry
salary	9	5	1521	3	salary
sandfly	14	3	564	3	sandfly
sandy	9	42	2113	3	san_dy
sanely	9	31	1461	3	sanely
saner	5	43	3432	3	saner_
sanity	9	3	1620	3	sanity
saury	8	43	1722	3	sa_ury
savory	12	43	1056	3	savory
sawfly	15	3	513	3	sawfly
senary	9	37	1607	3	senary
sentry	9	29	1205	3	sentry
spangly	13	3	647	3	spangly
sparry	11	51	1130	3	spa_rry
sundry	10	5	794	3	sundry
taffy	14	51	1082	3	ta_ffy
tangly	10	44	1393	3	tangly
tangy	9	45	1995	3	tan_gy
tannery	10	38	866	3	tannery
tannoy	9	5	836	3	tannoy
tansy	8	45	1494	3	tan_sy
tantra	6	37	1336	3	tantra
tarry	8	54	2251	3	ta_rry
tawdry	13	39	525	3	tawdry
unary	8	3	1599	3	_unary
vagary	13	3	733	3	vagary
vanity	12	3	1194	3	vanity
vapory	14	39	876	3	vapory
vary	10	52	2606	3	va__ry
venery	12	37	1066	3	venery
vinery	12	49	1260	3	vinery
wafery	15	39	870	3	wafery
waffly	18	30	543	3	waffly
waney	11	51	2032	3	wan_ey
wanly	11	51	1802	3	wan_ly
wany	10	64	3236	3	wan__y
wary	10	67	4001	3	wa__ry
wastry	12	38	877	3	wastry
watery	12	39	1450	3	watery
wavery	15	46	1006	3	wavery
winery	12	50	1428	3	winery
wintry	12	49	892	3	wintry
yantra	9	44	962	3	yantra
zaffre	21	35	466	3	zaffre
zanily	18	3	1018	3	zanily
zany	16	73	1699	3	zan__y
zonary	18	3	879	3	zonary

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.393	454684.5
2	DLD Change Limit	112716	324	5.576	20214.5
3	Display Results	324	324	0.093	3483.9
	(SQL Overall)	178691	324	6.062	29477.2