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

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

322 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
puckery	18	30	626	(None)
pucker	14	38	1763	1	pucker_
puckers	15	35	1467	1	puckers
bucker	14	54	2046	2	bucker_
buckers	15	35	1745	2	buckers
ducker	13	43	1799	2	ducker_
duckers	14	32	1471	2	duckers
fucker	15	34	1442	2	fucker_
fuckers	16	36	1159	2	fuckers
mockery	18	37	691	2	mockery
mucker	14	38	1639	2	mucker_
muckers	15	36	1280	2	muckers
packer	14	42	2340	2	packer_
packers	15	38	1889	2	packers
pecker	14	46	1536	2	pecker_
peckers	15	33	1267	2	peckers
picker	14	44	2217	2	picker_
pickers	15	37	1809	2	pickers
plucker	15	36	824	2	plucker_
pluckers	16	31	655	2	pluckers
puckered	17	3	610	2	puckered
puckerer	16	4	579	2	puckerer
puffery	18	23	511	2	puffery
punker	12	37	1882	2	punker_
punkers	13	37	1485	2	punkers
punkey	15	40	1117	2	punke_y
quackery	26	3	311	2	quackery
rockery	16	43	925	2	rockery
sucker	12	41	2066	2	sucker_
suckers	13	37	1762	2	suckers
tucker	12	43	1695	2	tucker_
tuckers	13	40	1435	2	tuckers
archery	15	47	806	3	archery
backer	14	45	2552	3	backer_
backers	15	38	2188	3	backers
bakery	15	59	1100	3	_bakery
bicker	14	48	1917	3	bicker_
bickers	15	43	1655	3	bickers
bucked	15	51	2106	3	bucke_d
buckeen	15	3	670	3	buckeen
buckeroo	16	4	431	3	buckeroo
bucket	14	46	2073	3	bucke_t
buckets	15	38	1169	3	buckets
buckeye	18	3	568	3	buckeye
buckler	15	41	1203	3	buckler_
bucklers	16	34	950	3	bucklers
buckra	14	3	675	3	buck_ra
buggery	14	36	793	3	buggery
bunker	12	45	1937	3	bunker_
bunkers	13	37	1595	3	bunkers
burker	12	52	2117	3	burker_
burkers	13	37	1662	3	burkers
busker	12	55	1783	3	busker_
buskers	13	34	1409	3	buskers
butchery	18	32	625	3	butchery
butlery	12	36	942	3	butlery
buttery	12	43	1119	3	buttery
cocker	14	43	2039	3	cocker_
cockers	15	36	1833	3	cockers
cookery	16	42	1039	3	cookery
crockery	19	35	660	3	crockery
cutchery	18	26	517	3	cutchery
cutlery	12	44	839	3	cutlery
cyclery	17	6	349	3	cyclery
dacker	13	49	2075	3	dacker_
dackers	14	34	1704	3	dackers
decker	13	52	1599	3	decker_
deckers	14	44	1383	3	deckers
dicker	13	45	2140	3	dicker_
dickers	14	41	1766	3	dickers
dickey	16	59	1352	3	dicke_y
docker	13	44	1765	3	docker_
dockers	14	37	1500	3	dockers
ducked	14	47	1801	3	ducke_d
duckier	14	39	1179	3	duckier_
ducky	15	42	1611	3	duck__y
duiker	11	41	1059	3	duiker_
duikers	12	36	938	3	duikers
dunker	11	36	1646	3	dunker_
dunkers	12	35	1219	3	dunkers
dupery	12	37	874	3	du_pery
fakery	16	50	926	3	_fakery
flackery	20	29	524	3	flackery
flickery	20	36	510	3	flickery
fucked	16	41	1448	3	fucke_d
fullery	13	33	797	3	fullery
funker	13	39	1576	3	funker_
funkers	14	37	1206	3	funkers
gunnery	11	37	637	3	gunnery
guttery	11	42	776	3	guttery
hacker	15	48	2269	3	hacker_
hackers	16	46	1904	3	hackers
hickey	18	50	1199	3	hicke_y
hickory	19	4	390	3	hickory
hocker	15	51	1856	3	hocker_
hockers	16	39	1591	3	hockers
hockey	18	48	1315	3	hocke_y
hunker	13	39	1767	3	hunker_
hunkers	14	33	1433	3	hunkers
hunkey	16	42	1088	3	hunke_y
husker	13	42	1270	3	husker_
huskers	14	35	1004	3	huskers
icker	11	40	1844	3	_icker_
ickers	12	39	1418	3	_ickers
jacker	19	44	1758	3	jacker_
jackers	20	42	1445	3	jackers
jockey	22	40	803	3	jocke_y
junker	17	42	1365	3	junker_
junkers	18	40	1086	3	junkers
kicker	11	41	1618	3	kicker_
kickers	12	40	1329	3	kickers
knackery	16	28	366	3	knackery
lacker	12	53	2562	3	lacker_
lackers	13	41	2054	3	lackers
lackey	15	48	1335	3	lacke_y
lechery	15	25	764	3	lechery
licker	12	52	2204	3	licker_
lickers	13	41	1825	3	lickers
locker	12	40	1942	3	locker_
lockers	13	35	1692	3	lockers
lucern	8	4	610	3	luc_ern
lucked	13	51	1802	3	lucke_d
luckier	13	38	1153	3	luckier_
luckily	16	29	708	3	luckily
lucky	14	55	1501	3	luck__y
lunker	10	47	1834	3	lunker_
lunkers	11	34	1460	3	lunkers
lurker	10	36	1329	3	lurker_
lurkers	11	39	1008	3	lurkers
mickey	17	42	1185	3	micke_y
mocker	14	33	1544	3	mocker_
mockers	15	38	1294	3	mockers
monkery	16	31	745	3	monkery
mucked	15	38	1609	3	mucke_d
muckier	15	34	1148	3	muckier_
muckily	18	27	774	3	muckily
mucky	16	50	1525	3	muck__y
mummery	13	33	666	3	mummery
murker	12	37	1524	3	murker_
musketry	17	4	218	3	musketry
necker	12	40	1279	3	necker_
neckers	13	42	1046	3	neckers
nicker	12	38	1870	3	nicker_
nickers	13	44	1509	3	nickers
nunnery	10	35	530	3	nunnery
nursery	10	39	602	3	nursery
ochery	14	31	944	3	_ochery
ocker	11	39	1575	3	_ocker_
ockers	12	38	1390	3	_ockers
pacer	9	61	3161	3	pac_er_
pacers	10	51	2454	3	pac_ers
pacey	12	67	2028	3	pac_e_y
pacier	10	50	1868	3	pacier_
packed	15	48	2260	3	packe_d
packet	14	47	2650	3	packe_t
packets	15	51	1477	3	packets
packly	17	22	833	3	pack_ly
papery	13	48	1274	3	p_apery
parker	12	41	2137	3	parker_
parkers	13	38	1687	3	parkers
peccary	16	3	628	3	peccary
pecked	15	50	1910	3	pecke_d
peckier	15	39	1052	3	peckier_
pecky	16	55	1509	3	peck__y
pedlery	13	29	708	3	pedlery
peery	10	57	1944	3	p__eery
peppery	13	28	625	3	peppery
picked	15	44	2131	3	picke_d
pickeer	15	37	1011	3	pickeer
pickeers	16	34	724	3	pickeers
pickerel	16	4	527	3	pickerel
picket	14	49	2431	3	picke_t
pickets	15	43	1418	3	pickets
pickier	15	39	1297	3	pickier_
picky	16	54	1694	3	pick__y
piggery	14	26	619	3	piggery
piker	11	56	2284	3	p_iker_
pikers	12	47	1739	3	p_ikers
pinery	11	52	1429	3	p_inery
pinker	12	53	2244	3	pinker_
pinkers	13	41	1860	3	pinkers
pinkey	15	43	1467	3	pinke_y
plucked	16	36	796	3	plucke_d
pluckier	16	29	507	3	pluckier_
pluckily	19	6	341	3	pluckily
plucky	17	40	658	3	pluck__y
plumbery	17	31	553	3	plumbery
plunker	13	39	1065	3	plunker_
plunkers	14	32	833	3	plunkers
pocked	15	48	1898	3	pocke_d
pocket	14	46	2262	3	pocke_t
pockets	15	46	1225	3	pockets
pockier	15	39	1160	3	pockier_
pockily	18	4	623	3	pockily
pocky	16	53	1460	3	pock__y
poker	11	51	2288	3	p_oker_
pokers	12	46	1792	3	p_okers
pokey	14	53	1897	3	p_oke_y
popery	13	45	1170	3	p_opery
porker	12	49	1754	3	porker_
porkers	13	43	1493	3	porkers
pottery	12	30	1107	3	pottery
powdery	16	39	612	3	powdery
pricker	15	40	1341	3	pricker_
prickers	16	37	1067	3	prickers
prudery	13	3	524	3	prudery
puberty	14	4	478	3	pu_berty
puce	8	51	2788	3	puc_e__
puces	9	49	2463	3	puc_e_s
puck	12	49	2794	3	puck___
pucka	13	34	1280	3	puck__a
puckerers	17	4	451	3	puckerers
puckerier	17	5	431	3	puckerier
puckering	18	3	588	3	puckering
puckish	18	23	721	3	puckish
pucks	13	43	2210	3	puck__s
puffer	14	46	1073	3	puffer_
puffers	15	34	920	3	puffers
puggry	13	37	482	3	pu_ggry
puke	10	50	2546	3	pu_ke__
puked	12	47	1622	3	pu_ke_d
pukes	11	45	2302	3	pu_ke_s
puler	7	48	2662	3	pu_ler_
pulers	8	38	2028	3	pu_lers
puller	8	38	2081	3	puller_
pullers	9	36	1848	3	pullers
pulley	11	37	1340	3	pulle_y
pulper	10	35	1327	3	pulper_
pulpers	11	46	1228	3	pulpers
pulser	8	42	1519	3	pulser_
pulsers	9	42	1315	3	pulsers
pumper	12	44	1555	3	pumper_
pumpers	13	31	1367	3	pumpers
puncher	14	33	1167	3	puncher_
punchers	15	26	1007	3	punchers
punier	8	45	1922	3	punier_
punkest	13	26	1169	3	punkest
punkeys	16	36	649	3	punkeys
punkier	13	35	1279	3	punkier_
punky	14	44	1939	3	punk__y
punner	8	49	1815	3	punner_
punners	9	41	1423	3	punners
punter	8	43	2002	3	punter_
punters	9	36	1704	3	punters
puppetry	14	4	250	3	puppetry
purely	11	40	1363	3	pu_rely
purer	7	51	2790	3	pu_rer_
purger	9	47	1723	3	purger_
purgers	10	47	1400	3	purgers
purser	8	50	2047	3	purser_
pursers	9	39	1609	3	pursers
purvey	14	55	957	3	purve_y
pusher	11	43	1828	3	pusher_
pushers	12	38	1450	3	pushers
pusley	11	37	961	3	pusle_y
putrefy	15	4	331	3	putrefy
putter	8	39	2144	3	putter_
putters	9	42	1919	3	putters
quaker	19	38	1162	3	quaker_
quakers	20	30	969	3	quakers
quavery	22	22	548	3	quavery
query	17	42	1208	3	qu__ery
quicker	22	4	702	3	quicker_
quivery	22	26	546	3	quivery
racker	12	48	2455	3	racker_
rackers	13	43	2045	3	rackers
rackety	16	49	911	3	rackety
rickety	16	47	831	3	rickety
rickey	15	46	1397	3	ricke_y
rocker	12	43	1957	3	rocker_
rockers	13	39	1655	3	rockers
rocketry	17	4	450	3	rocketry
rookery	14	39	831	3	rookery
rubbery	14	33	759	3	rubbery
rucked	13	47	1876	3	rucke_d
rudery	10	41	903	3	ru_dery
sacker	12	51	2484	3	sacker_
sackers	13	38	2022	3	sackers
shucker	16	37	1010	3	shucker_
shuckers	17	38	813	3	shuckers
sicker	12	40	2390	3	sicker_
sickerly	17	3	403	3	sickerly
snickery	17	29	554	3	snickery
spicery	14	49	901	3	spic_ery
spookery	17	26	414	3	spookery
sputtery	13	36	647	3	sputtery
succory	14	4	464	3	succory
sucked	13	41	2049	3	sucke_d
suckered	15	3	783	3	suckered
suckier	13	36	1397	3	suckier_
suckler	13	34	1309	3	suckler_
sucklers	14	37	996	3	sucklers
sucky	14	44	1550	3	suck__y
sulker	10	40	1592	3	sulker_
sulkers	11	36	1334	3	sulkers
summery	14	32	941	3	summery
surgery	11	31	921	3	surgery
tacker	12	42	2450	3	tacker_
tackers	13	43	1962	3	tackers
tackey	15	46	1308	3	tacke_y
ticker	12	43	2150	3	ticker_
tickers	13	36	1772	3	tickers
trickery	17	29	734	3	trickery
trucker	13	40	1073	3	trucker_
truckers	14	27	901	3	truckers
tucked	13	40	1749	3	tucke_d
tuckered	15	3	596	3	tuckered
tucket	12	42	1948	3	tucke_t
tuckets	13	48	1033	3	tuckets
turkey	13	3	776	3	turke_y
turnery	10	35	742	3	turnery
tushery	13	3	563	3	tushery
tusker	10	42	1219	3	tusker_
tuskers	11	37	1004	3	tuskers
unpucker	16	23	427	3	unpucker_
unpuckers	17	24	312	3	unpuckers
wacker	15	49	2012	3	wacker_
wicker	15	45	1867	3	wicker_
wickers	16	41	1470	3	wickers
yucked	16	40	1356	3	yucke_d
yuckier	16	35	853	3	yuckier_
yucky	17	54	1169	3	yuck__y

Search took 8 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.410	435831.7
2	DLD Change Limit	134027	322	7.373	18178.1
3	Display Results	322	322	0.110	2927.3
	(SQL Overall)	178691	322	7.893	22639.2