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

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

510 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
pottery	12	30	1107	(None)
lottery	10	38	983	1	lottery
potter	8	39	2698	1	potter_
potters	9	40	2434	1	potters
tottery	10	38	848	1	tottery
battery	12	49	1181	2	battery
bootery	12	3	898	2	bootery
buttery	12	43	1119	2	buttery
cattery	12	38	1160	2	cattery
cotter	8	49	2667	2	cotter_
cotters	9	43	2344	2	cotters
dotter	7	44	1934	2	dotter_
dotters	8	37	1597	2	dotters
guttery	11	42	776	2	guttery
hotter	9	47	2008	2	hotter_
jittery	17	34	644	2	jittery
jotter	13	43	1563	2	jotter_
jotters	14	34	1380	2	jotters
littery	10	37	1049	2	littery
lotter	6	40	2560	2	lotter_
lotters	7	39	2106	2	lotters
mattery	12	38	1071	2	mattery
mothery	15	37	1051	2	mothery
otter	5	44	2397	2	_otter_
otters	6	40	2151	2	_otters
patter	8	46	2826	2	patter_
pattern	9	37	1205	2	pattern
patters	9	48	2519	2	patters
petter	8	39	2477	2	petter_
petters	9	37	2236	2	petters
plotter	9	41	1366	2	plotter_
plotters	10	40	1155	2	plotters
poetry	11	3	938	2	poet_ry
popery	13	45	1170	2	po_pery
porter	8	42	2441	2	porter_
porters	9	37	2270	2	porters
poster	8	41	2917	2	poster_
postern	9	36	1561	2	postern
posters	9	39	2801	2	posters
potatory	13	4	841	2	potatory
pother	11	38	1885	2	pother_
potherb	14	35	868	2	potherb
pothers	12	38	1862	2	pothers
potted	9	46	2401	2	potte_d
potteen	9	31	967	2	potteen
pottered	11	23	1166	2	pottered
potterer	10	23	1026	2	potterer
pottier	9	35	1649	2	pottier_
potty	10	56	2100	2	pott__y
potzer	17	44	1121	2	potzer_
potzers	18	40	1054	2	potzers
pouter	8	39	2398	2	pouter_
pouters	9	42	2187	2	pouters
powdery	16	39	612	2	powdery
powter	11	41	1603	2	powter_
powters	12	40	1566	2	powters
putter	8	39	2144	2	putter_
putters	9	42	1919	2	putters
rotter	6	43	2546	2	rotter_
rotters	7	44	2139	2	rotters
spotter	9	45	1488	2	spotter_
spotters	10	43	1338	2	spotters
sputtery	13	36	647	2	sputtery
totter	6	50	2146	2	totter_
totters	7	46	1873	2	totters
artery	9	9	1145	3	_artery
batter	8	49	2887	3	batter_
batters	9	46	2601	3	batters
better	8	47	2370	3	better_
betters	9	44	2209	3	betters
bitter	8	46	2267	3	bitter_
bitterly	13	3	560	3	bitterly
bittern	9	48	1068	3	bittern
bitters	9	49	2036	3	bitters
blotter	9	46	1285	3	blotter_
blotters	10	41	1098	3	blotters
boater	8	46	2209	3	boater_
boaters	9	34	1924	3	boaters
bobbery	13	43	835	3	bobbery
bolter	8	39	2075	3	bolter_
bolters	9	40	1780	3	bolters
botchery	18	36	676	3	botchery
bother	11	52	1806	3	bother_
bothers	12	43	1775	3	bothers
bottler	9	42	1188	3	bottler_
bottlers	10	38	1001	3	bottlers
bottomry	15	4	204	3	bottomry
bowery	14	60	1211	3	bo_wery
butlery	12	36	942	3	butlery
butter	8	47	2423	3	butter_
butters	9	45	2172	3	butters
cautery	12	34	959	3	cautery
chattery	16	35	727	3	chattery
cittern	9	33	914	3	cittern
clattery	13	37	819	3	clattery
cluttery	13	34	632	3	cluttery
coater	8	43	2957	3	coater_
coaters	9	35	2579	3	coaters
colter	8	46	2509	3	colter_
colters	9	35	2244	3	colters
cookery	16	42	1039	3	cookery
coopery	14	39	1027	3	coopery
cooter	8	51	2861	3	cooter_
cooters	9	45	2572	3	cooters
coppery	16	40	939	3	coppery
copter	10	98	2201	3	copter_
copters	11	36	2128	3	copters
coster	8	43	3129	3	coster_
costers	9	41	2833	3	costers
cottar	8	46	1381	3	cottar_
cottars	9	44	1224	3	cottars
cottered	11	25	1173	3	cottered
cottier	9	38	1417	3	cottier_
cottiers	10	39	915	3	cottiers
cottony	12	3	725	3	cottony
couter	8	49	3022	3	couter_
couters	9	38	2730	3	couters
cutlery	12	44	839	3	cutlery
cutter	8	45	2100	3	cutter_
cutters	9	42	1896	3	cutters
dithery	14	31	894	3	dithery
doddery	13	51	685	3	doddery
dodgery	13	62	778	3	dodgery
doggery	13	44	826	3	doggery
doter	6	54	2862	3	do_ter_
doters	7	44	2391	3	do_ters
dotier	7	39	1703	3	dotier_
dotted	8	47	1752	3	dotte_d
dottel	7	36	1089	3	dotte_l
dottels	8	32	778	3	dottels
dotterel	9	4	506	3	dotterel
dottier	8	39	1092	3	dottier_
dottily	11	4	728	3	dottily
dottrel	8	3	446	3	dottrel
dotty	9	45	1610	3	dott__y
dowery	13	43	1166	3	do_wery
eatery	9	53	1635	3	_eatery
fatter	9	45	2321	3	fatter_
fetter	9	41	2038	3	fetter_
fetters	10	35	1790	3	fetters
fitter	9	41	2003	3	fitter_
fitters	10	45	1775	3	fitters
flattery	14	33	829	3	flattery
fluttery	14	37	614	3	fluttery
foolery	13	3	669	3	foolery
footer	9	43	2077	3	footer_
footers	10	46	1833	3	footers
foppery	17	38	562	3	foppery
forgery	14	41	930	3	forgery
foster	9	43	2222	3	foster_
fosters	10	42	2010	3	fosters
getter	7	41	1761	3	getter_
getters	8	42	1610	3	getters
gittern	8	33	750	3	gittern
glittery	12	37	561	3	glittery
goiter	7	41	1620	3	goiter_
goiters	8	40	1444	3	goiters
gotten	7	34	1011	3	gotte_n
gutter	7	38	1771	3	gutter_
gutters	8	37	1551	3	gutters
hatter	9	47	2487	3	hatter_
hatters	10	42	2152	3	hatters
hitter	9	44	1986	3	hitter_
hitters	10	47	1759	3	hitters
hooter	9	41	2393	3	hooter_
hooters	10	45	2047	3	hooters
hosiery	13	33	718	3	hosiery
hostelry	14	4	391	3	hostelry
hotted	10	43	1994	3	hotte_d
hottest	10	4	1138	3	hottest
jitter	13	33	1499	3	jitter_
jitters	14	43	1447	3	jitters
jobbery	21	36	601	3	jobbery
joinery	17	36	659	3	joinery
jolter	13	35	1309	3	jolter_
jolters	14	37	1199	3	jolters
jotted	14	36	1517	3	jotte_d
jotty	15	50	1260	3	jott__y
knotter	11	31	764	3	knotter_
knotters	12	27	615	3	knotters
lathery	13	39	1112	3	lathery
latter	6	50	2789	3	latter_
latterly	11	3	606	3	latterly
letter	6	37	2258	3	letter_
letters	7	38	1985	3	letters
litter	6	43	2485	3	litter_
litters	7	34	2257	3	litters
lofter	9	46	1472	3	lofter_
lofters	10	39	1290	3	lofters
loiter	6	46	1917	3	loiter_
loiters	7	41	1661	3	loiters
looter	6	42	2232	3	looter_
looters	7	44	1916	3	looters
lotte	5	49	2385	3	lotte__
lotted	7	42	2240	3	lotte_d
lottes	6	53	2275	3	lotte_s
lowery	12	41	1271	3	lo_wery
mastery	12	42	1432	3	mastery
matter	8	43	2534	3	matter_
matters	9	44	2175	3	matters
mockery	18	37	691	3	mockery
molter	8	41	1942	3	molter_
molters	9	38	1697	3	molters
monkery	16	31	745	3	monkery
montero	9	3	1013	3	montero
mooter	8	39	2109	3	mooter_
mooters	9	38	1862	3	mooters
mopery	13	52	1097	3	mo_pery
mortary	12	36	904	3	mortary
motey	10	59	2295	3	mo_te_y
mother	11	37	1864	3	mother_
motherly	16	34	609	3	motherly
mothers	12	37	1762	3	mothers
motley	11	3	938	3	motle_y
motte	7	55	2697	3	motte__
mottes	8	55	2369	3	motte_s
mottler	9	44	1034	3	mottler_
mottlers	10	38	818	3	mottlers
mutter	8	44	1888	3	mutter_
mutters	9	41	1714	3	mutters
mystery	15	43	652	3	mystery
natter	6	44	2074	3	natter_
natters	7	37	1806	3	natters
netter	6	37	2202	3	netter_
netters	7	36	1858	3	netters
nitery	9	44	1217	3	_nitery
notary	9	23	1071	3	no_tary
noter	5	50	2564	3	no_ter_
noters	6	40	2100	3	no_ters
nother	9	38	1596	3	nother_
nutter	6	39	1805	3	nutter_
nutters	7	42	1543	3	nutters
oater	5	54	3373	3	_oater_
oaters	6	50	2979	3	_oaters
ochery	14	31	944	3	_ochery
ofter	8	41	1687	3	_ofter_
onery	8	4	1412	3	_o_nery
ornery	9	3	846	3	_ornery
orrery	9	3	678	3	_orrery
other	8	42	1910	3	_other_
others	9	39	1800	3	_others
ottar	5	43	1399	3	_ottar_
ottars	6	41	1222	3	_ottars
outcry	11	3	799	3	_outcry
outer	5	56	3330	3	_outer_
outers	6	42	3017	3	_outers
oxter	12	34	1409	3	_oxter_
oxters	13	48	1327	3	_oxters
palter	8	44	2326	3	palter_
palters	9	40	2168	3	palters
paltry	11	49	1040	3	palt_ry
pantry	11	50	1410	3	pant_ry
papery	13	48	1274	3	p_apery
paster	8	57	3437	3	paster_
pastern	9	44	1506	3	pastern
pasters	9	45	3173	3	pasters
pastry	11	49	1303	3	past_ry
pater	7	47	4072	3	p_ater_
paters	8	49	3583	3	p_aters
patted	9	47	2468	3	patte_d
pattee	8	43	2338	3	patte_e
patten	8	44	1819	3	patte_n
pattens	9	54	1492	3	pattens
pattered	11	27	1420	3	pattered
patterer	10	31	1217	3	patterer
patterns	10	43	994	3	patterns
patty	10	47	2361	3	patt__y
patzer	17	31	1164	3	patzer_
patzers	18	42	1057	3	patzers
pedlery	13	29	708	3	pedlery
peery	10	57	1944	3	p__eery
pelter	8	33	2162	3	pelter_
pelters	9	37	2031	3	pelters
peltry	11	28	865	3	pelt_ry
peppery	13	28	625	3	peppery
perter	8	44	2228	3	perter_
pester	8	48	2759	3	pester_
pesters	9	38	2709	3	pesters
peter	7	44	2759	3	p_eter_
peters	8	66	2459	3	p_eters
petted	9	41	2152	3	pette_d
pettedly	14	4	389	3	pettedly
pettier	9	42	1361	3	pettier_
pettily	12	3	817	3	pettily
petty	10	53	2029	3	pett__y
pewter	11	40	1367	3	pewter_
pewters	12	41	1335	3	pewters
phatter	12	38	1020	3	phatter_
piggery	14	26	619	3	piggery
pinery	11	52	1429	3	p_inery
pitier	8	40	1982	3	pitier_
pitiers	9	38	1265	3	pitiers
pitted	9	43	1959	3	pitte_d
plastery	13	27	970	3	plastery
plater	8	44	2769	3	plater_
platers	9	39	2409	3	platers
platter	9	39	1741	3	platter_
platters	10	34	1528	3	platters
plotted	10	46	1237	3	plotte_d
plottier	10	32	726	3	plottier_
plotty	11	20	885	3	plott__y
poesy	10	50	1406	3	po__esy
poetess	9	3	893	3	poetess
pogey	11	60	1789	3	po_ge_y
pointer	9	38	1493	3	pointer_
pointers	10	30	1372	3	pointers
poiser	8	42	1724	3	poiser_
poisers	9	42	1443	3	poisers
poitrel	9	3	619	3	poitrel
poker	11	51	2288	3	po_ker_
pokers	12	46	1792	3	po_kers
pokey	14	53	1897	3	po_ke_y
pokier	12	49	1463	3	pokier_
polder	9	40	1925	3	polder_
polders	10	36	1737	3	polders
poler	7	44	3179	3	po_ler_
polers	8	42	2564	3	po_lers
politely	13	4	709	3	politely
politer	9	24	1707	3	politer_
poller	8	39	2185	3	poller_
pollers	9	34	2002	3	pollers
polyteny	16	6	519	3	polyteny
ponder	9	45	2169	3	ponder_
ponders	10	36	1884	3	ponders
pontes	8	36	2785	3	ponte_s
poofter	12	3	716	3	poofter_
poofters	13	3	692	3	poofters
pooler	8	38	1984	3	pooler_
poolers	9	42	1742	3	poolers
poorer	8	26	1399	3	poorer_
popper	9	36	1596	3	popper_
poppers	10	34	1486	3	poppers
porker	12	49	1754	3	porker_
porkers	13	43	1493	3	porkers
ported	9	42	2324	3	porte_d
portend	10	34	1119	3	portend
portent	9	36	1964	3	portent
portered	11	23	1154	3	portered
portiere	10	3	877	3	portiere
portly	11	47	1340	3	port_ly
portray	12	3	748	3	portray
poser	7	51	2877	3	po_ser_
posers	8	42	2397	3	po_sers
posher	11	50	1816	3	posher_
postboy	14	7	667	3	postboy
posted	9	37	2249	3	poste_d
posteen	9	35	1262	3	posteen
posterity	14	4	869	3	posterity
posterns	10	27	1372	3	posterns
postteen	10	5	569	3	postteen
posttest	10	4	1023	3	posttest
posture	9	3	1325	3	posture
potbelly	15	4	421	3	potbelly
potboy	13	9	781	3	po_tboy
poteen	8	35	1426	3	po_teen
poteens	9	29	1088	3	poteens
potency	14	5	743	3	potency
potent	8	42	2335	3	po_tent
pothead	13	38	1039	3	pothead
potheen	12	25	789	3	potheen
potherbs	15	38	712	3	potherbs
pothered	14	23	1104	3	pothered
potmen	10	27	1309	3	potme_n
potsherd	14	3	481	3	potsherd
potsy	10	58	1561	3	po_t_sy
pottage	10	33	1060	3	pottage
potteens	10	25	679	3	potteens
potterers	11	21	866	3	potterers
potteries	11	3	1359	3	potteries
pottering	12	26	1200	3	pottering
potties	9	37	2354	3	potties
pottiest	10	28	1597	3	pottiest
potting	10	37	2089	3	potting
pottle	8	44	1610	3	pott_le
pottles	9	38	1698	3	pottles
potto	7	53	2094	3	pott__o
pottos	8	46	1587	3	pott_os
poulter	9	37	1201	3	poulter_
poulters	10	39	1105	3	poulters
poultry	12	3	538	3	poultry
pourer	8	45	1604	3	pourer_
pourers	9	35	1367	3	pourers
pouted	9	40	2139	3	poute_d
poutier	9	32	1532	3	poutier_
pouty	10	70	1881	3	pout__y
poverty	15	3	643	3	po_verty
powder	12	36	1190	3	powder_
powders	13	41	1155	3	powders
power	10	53	2595	3	po_wer_
powers	11	38	2232	3	po_wers
poxier	15	38	1211	3	poxier_
prater	8	48	2535	3	prater_
praters	9	49	2165	3	praters
preterm	11	3	1016	3	preterm
printery	13	31	843	3	printery
prudery	13	3	524	3	prudery
psaltery	13	22	473	3	psaltery
ptooey	11	34	641	3	ptooe_y
puckery	18	30	626	3	puckery
puffery	18	23	511	3	puffery
punter	8	43	2002	3	punter_
punters	9	36	1704	3	punters
putrefy	15	4	331	3	putrefy
putted	9	42	2025	3	putte_d
puttee	8	59	1972	3	putte_e
puttees	9	36	1291	3	puttees
puttered	11	26	1114	3	puttered
putterer	10	20	991	3	putterer
puttier	9	33	1450	3	puttier_
puttiers	10	28	801	3	puttiers
putty	10	47	2140	3	putt__y
ratter	6	43	2631	3	ratter_
ratters	7	44	2247	3	ratters
ritter	6	38	2242	3	ritter_
ritters	7	40	2062	3	ritters
robbery	14	34	828	3	robbery
rockery	16	43	925	3	rockery
roguery	11	3	489	3	roguery
rookery	14	39	831	3	rookery
rooter	6	49	2603	3	rooter_
rooters	7	45	2293	3	rooters
ropery	11	43	1387	3	ro_pery
rosery	9	38	1328	3	ro_sery
roster	6	43	2908	3	roster_
rosters	7	37	2754	3	rosters
rotary	9	24	1130	3	ro_tary
rotatory	11	4	721	3	rotatory
rotte	5	46	2593	3	rotte__
rotted	7	45	2443	3	rotte_d
rotten	6	41	1543	3	rotte_n
rottenly	11	4	415	3	rottenly
rottes	6	45	2483	3	rotte_s
router	6	50	2584	3	router_
routers	7	48	2287	3	routers
setter	6	40	2372	3	setter_
setters	7	38	2206	3	setters
sitter	6	33	2338	3	sitter_
sitters	7	42	2155	3	sitters
skittery	15	31	510	3	skittery
slotter	7	33	1445	3	slotter_
slotters	8	40	1240	3	slotters
smothery	16	29	606	3	smothery
softer	9	40	1531	3	softer_
sorcery	12	3	703	3	sorcery
sorter	6	44	2509	3	sorter_
sorters	7	42	2113	3	sorters
sotted	7	41	2140	3	sotte_d
sottedly	12	4	430	3	sottedly
souter	6	42	2592	3	souter_
souters	7	44	2260	3	souters
spatter	9	40	1652	3	spatter_
spatters	10	39	1470	3	spatters
spitter	9	40	1518	3	spitter_
spitters	10	41	1338	3	spitters
spluttery	14	29	362	3	spluttery
spoofery	16	35	431	3	spoofery
spookery	17	26	414	3	spookery
sporter	9	36	1655	3	sporter_
sporters	10	37	1406	3	sporters
spotted	10	37	1314	3	spotte_d
spottier	10	20	731	3	spottier_
spottily	13	3	515	3	spottily
spotty	11	44	858	3	spott__y
spouter	9	42	1322	3	spouter_
spouters	10	40	1116	3	spouters
sputter	9	40	1405	3	sputter_
sputters	10	40	1287	3	sputters
swotter	10	39	947	3	swotter_
swotters	11	44	848	3	swotters
tatter	6	40	2457	3	tatter_
tatters	7	45	2048	3	tatters
tetter	6	43	2245	3	tetter_
tetters	7	43	2047	3	tetters
titter	6	34	2116	3	titter_
titters	7	42	1962	3	titters
toggery	12	50	592	3	toggery
tooter	6	44	2080	3	tooter_
tooters	7	38	1877	3	tooters
toter	5	59	3213	3	to_ter_
toters	6	50	2636	3	to_ters
tother	9	41	1714	3	tother_
totted	7	43	1995	3	totte_d
tottered	9	20	870	3	tottered
totterer	8	21	779	3	totterer
touter	6	38	2103	3	touter_
touters	7	40	1835	3	touters
towery	12	40	1209	3	to_wery
trotter	7	33	1225	3	trotter_
trotters	8	33	1024	3	trotters
twittery	14	30	389	3	twittery
utter	5	42	1876	3	_utter_
utterly	10	3	544	3	_utterly
utters	6	38	1712	3	_utters
vetter	9	34	1764	3	vetter_
vetters	10	40	1632	3	vetters
volery	12	3	787	3	vo_lery
votary	12	24	833	3	vo_tary
voter	8	51	2105	3	vo_ter_
voters	9	50	1744	3	vo_ters
wastery	13	46	1099	3	wastery
watery	12	39	1449	3	_watery
watter	9	32	2198	3	watter_
wetter	9	39	1944	3	wetter_
wetters	10	38	1775	3	wetters
wintery	13	39	975	3	wintery
wotted	10	41	1571	3	wotte_d
yatter	9	41	1621	3	yatter_
yatters	10	39	1462	3	yatters
zoster	15	37	1585	3	zoster_
zosters	16	30	1541	3	zosters

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	134027	0.406	440125.6
2	DLD Change Limit	134027	510	6.140	21828.5
3	Display Results	510	510	0.186	2741.9
	(SQL Overall)	178691	510	6.732	26543.5