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

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

332 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
flecky	18	38	765	(None)
fleck	14	82	1359	1	fleck_
flecks	15	43	1080	1	flecks
flocky	18	46	842	1	flocky
blocky	17	38	835	2	blocky
drecky	16	48	633	2	drecky
feck	13	49	2343	2	f_eck_
feckly	18	33	596	2	f_eckly
fecks	14	54	1785	2	f_ecks
flack	14	45	1941	2	flack_
flacks	15	41	1453	2	flacks
flaky	15	57	1558	2	fl_aky
fleche	14	29	930	2	fleche
flecked	17	35	807	2	flecked
fledgy	14	41	491	2	fledgy
fleecy	14	26	648	2	fleecy
fleshy	15	40	628	2	fleshy
fleury	12	41	735	2	fleury
fley	10	66	2685	2	fle__y
flick	14	50	1721	2	flick_
flicks	15	45	1299	2	flicks
flock	14	47	1742	2	flock_
flocks	15	47	1353	2	flocks
fluky	15	45	1229	2	fl_uky
flunky	16	40	809	2	flunky
freaky	16	43	923	2	freaky
freckly	19	12	459	2	freckly
leaky	12	52	1772	2	_leaky
lucky	14	55	1501	2	_lucky
pecky	16	55	1509	2	_pecky
plucky	17	40	658	2	plucky
sleeky	13	39	896	2	sleeky
alack	11	48	2006	3	alack_
alec	6	64	3006	3	alec__
alecs	7	66	2073	3	alec_s
alky	11	59	2034	3	al__ky
beaky	14	61	1802	3	_beaky
beck	12	62	2657	3	_beck_
becks	13	55	2201	3	_becks
beechy	16	39	750	3	beechy
befleck	18	4	394	3	befleck_
beflecks	19	4	375	3	beflecks
black	13	47	1907	3	black_
blackly	18	3	525	3	blackly
blacks	14	49	1495	3	blacks
bleak	11	59	1538	3	bleak_
bleakly	16	3	466	3	bleakly
bleaks	12	51	1243	3	bleaks
bleary	11	51	1255	3	bleary
blebby	12	3	374	3	blebby
blenny	11	5	620	3	blenny
block	13	49	1784	3	block_
blocks	14	45	1394	3	blocks
bricky	17	48	909	3	bricky
check	16	47	1471	3	check_
checks	17	49	1270	3	checks
cheeky	18	44	861	3	cheeky
chucky	20	41	800	3	chucky
clack	13	47	2017	3	clack_
clacks	14	45	1634	3	clacks
clanky	15	46	907	3	clanky
cleek	11	55	1491	3	cleek_
cleeks	12	50	1054	3	cleeks
clergy	12	3	499	3	clergy
clerk	11	58	1245	3	clerk_
clerkly	16	4	357	3	clerkly
clerks	12	45	884	3	clerks
click	13	52	1795	3	click_
clicks	14	53	1511	3	clicks
clock	13	49	1798	3	clock_
clocks	14	49	1623	3	clocks
cluck	13	49	1489	3	cluck_
clucks	14	45	1207	3	clucks
clunky	15	44	789	3	clunky
cocky	16	42	1593	3	_cocky
colicky	18	3	578	3	colicky
cracky	17	50	1022	3	cracky
creaky	15	49	1155	3	creaky
decay	11	47	1848	3	_decay
deck	11	58	2775	3	_deck_
decks	12	48	2219	3	_decks
decoy	11	57	1631	3	_decoy
decry	11	55	1435	3	_decry
dicky	15	48	1624	3	_dicky
dreck	12	48	1280	3	dreck_
drecks	13	45	920	3	drecks
ducky	15	42	1611	3	_ducky
elect	7	43	2703	3	elec_t
elects	8	33	1500	3	elects
elegy	9	3	930	3	ele_gy
faecal	11	35	981	3	faecal
faeces	11	47	1312	3	faeces
faery	11	60	1548	3	fae_ry
fancy	13	46	1548	3	fanc_y
farcy	13	52	1709	3	farc_y
fecal	10	51	1921	3	f_ecal
feces	10	56	2536	3	f_eces
feebly	14	3	665	3	feebly
felly	11	49	2280	3	f_elly
felony	12	37	1032	3	felony
fenny	11	51	1513	3	f_enny
ferly	11	55	1735	3	f_erly
ferny	11	58	1618	3	f_erny
ferry	11	60	2080	3	f_erry
fey	9	59	4088	3	f_e__y
feyly	14	42	951	3	f_eyly
fezzy	19	98	1145	3	f_ezzy
fickly	18	31	853	3	f_ickly
fiery	11	47	1479	3	fie_ry
finicky	19	4	371	3	finicky
fitchy	17	43	762	3	fitchy
flabby	16	3	457	3	flabby
flacked	17	37	1158	3	flacked
flackery	20	29	524	3	flackery
flacon	11	3	863	3	flacon
flaggy	14	41	592	3	flaggy
flak	11	60	2617	3	fl_ak_
flake	12	51	1997	3	fl_ake
flakey	16	44	1051	3	flakey
flamy	13	52	1747	3	fl_amy
flank	12	46	1809	3	flank_
flanks	13	39	1340	3	flanks
flappy	16	5	448	3	flappy
flashy	15	49	817	3	flashy
flask	12	55	1242	3	flask_
flasks	13	48	867	3	flasks
flatly	12	31	1021	3	flatly
flawy	14	59	1338	3	fl_awy
flaxy	18	90	1229	3	fl_axy
flay	10	63	3280	3	fl__ay
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	fleches
flecking	18	40	823	3	flecking
fled	8	54	2977	3	fle__d
fledge	11	43	931	3	fledge
flee	7	62	3879	3	fle__e
fleece	11	36	990	3	fleece
fleeced	13	35	815	3	fleeced
fleecer	12	36	803	3	fleecer
fleeces	12	39	964	3	fleeces
fleech	14	36	734	3	fleech
fleecily	16	4	401	3	fleecily
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
fleetly	13	3	632	3	fleetly
fleets	9	69	1506	3	fleets
flench	14	40	1081	3	flench
flense	9	3	890	3	flense
flesh	11	50	1374	3	fle_sh
fleshly	16	34	609	3	fleshly
fletch	14	38	819	3	fletch
flew	10	58	2425	3	fle__w
flews	11	53	1644	3	fle_ws
flex	14	61	2347	3	fle__x
flexed	17	41	909	3	flexed
flexes	16	45	1295	3	flexes
flexor	16	3	450	3	flexor
fleyed	13	40	881	3	fleyed
fleys	11	70	1560	3	fle_ys
flic	9	62	2373	3	flic__
flicked	17	46	1067	3	flicked
flicker	16	36	1062	3	flicker
flickery	20	36	510	3	flickery
flics	10	54	1836	3	flic_s
flimsy	14	34	556	3	flimsy
flinty	12	61	1249	3	flinty
flippy	16	5	461	3	flippy
flirty	12	49	914	3	flirty
floaty	12	42	1094	3	floaty
floc	9	59	2212	3	floc__
flocci	13	3	502	3	flocci
flocked	17	45	1025	3	flocked
flocs	10	55	1923	3	floc_s
flooey	12	39	1017	3	flooey
floosy	12	36	815	3	floosy
floozy	21	35	661	3	floozy
floppy	16	5	487	3	floppy
flossy	12	51	770	3	flossy
floury	12	44	957	3	floury
fluency	15	4	535	3	fluency
fluffy	14	31	578	3	fluffy
fluke	12	50	1689	3	fl_uke
flukey	16	45	981	3	flukey
flunk	12	50	1438	3	flunk_
flunkey	17	40	579	3	flunkey
flunks	13	46	986	3	flunks
flurry	12	39	711	3	flurry
flutey	12	52	1252	3	flutey
fluty	11	44	1564	3	fl_uty
fly	9	71	2495	3	fl___y
flyboy	17	11	391	3	flyboy
flyby	16	7	600	3	fl_yby
flyway	18	13	469	3	flyway
foley	11	52	2230	3	fole__y
folky	15	92	1471	3	f_olky
forky	15	61	1964	3	f_orky
freak	12	51	1524	3	freak_
freaks	13	47	1306	3	freaks
freckle	16	10	664	3	freckle
freely	12	3	1096	3	freely
frenzy	21	3	588	3	frenzy
fretty	12	4	922	3	fretty
frisky	16	40	667	3	frisky
frock	14	53	1465	3	frock_
frocks	15	41	1121	3	frocks
frolicky	20	4	230	3	frolicky
fuck	13	49	2463	3	f_uck_
fucks	14	44	1925	3	f_ucks
funky	15	43	1513	3	f_unky
geck	11	57	2199	3	_geck_
gecko	12	45	1111	3	_gecko
gecks	12	51	1709	3	_gecks
geeky	13	47	1073	3	_geeky
gleamy	12	39	811	3	gleamy
gleek	10	53	1510	3	gleek_
gleeks	11	48	967	3	gleeks
gleety	10	47	919	3	gleety
glegly	11	3	487	3	glegly
gley	8	57	2465	3	gle__y
heck	13	58	2649	3	_heck_
hecks	14	52	2065	3	_hecks
icky	13	63	1575	3	__icky
jacky	21	54	1234	3	_jacky
jerky	19	67	1242	3	_jerky
keck	9	49	2071	3	_keck_
kecks	10	54	1657	3	_kecks
kicky	13	50	1233	3	_kicky
klick	10	53	1143	3	klick_
klicks	11	46	872	3	klicks
kolacky	15	4	320	3	kolacky
lacey	10	58	2091	3	_lacey
lack	10	58	3768	3	_lack_
lackey	15	48	1335	3	_lackey
lacks	11	61	2920	3	_lacks
lacy	9	58	2963	3	_lac_y
laky	11	67	2582	3	_l_aky
lanky	12	55	1748	3	_lanky
larky	12	52	1887	3	_larky
leachy	14	41	973	3	_leachy
leady	9	56	1860	3	_leady
leafy	11	63	1621	3	_leafy
leak	8	62	3371	3	_leak_
leaks	9	59	2391	3	_leaks
leary	8	59	2738	3	_leary
leavy	11	57	1577	3	_leavy
lech	9	68	2544	3	_lec_h
ledgy	10	57	1202	3	_ledgy
leek	8	53	3173	3	_leek_
leeks	9	53	1889	3	_leeks
leery	8	59	1913	3	_leery
lefty	11	56	1356	3	_lefty
leggy	10	52	1024	3	_leggy
lek	7	56	4030	3	_le_k_
leke	8	55	2740	3	_le_ke
leks	8	54	2760	3	_le_ks
leku	8	65	1991	3	_le_ku
levy	10	64	1850	3	_le_vy
ley	6	62	4681	3	_le__y
lezzy	16	60	808	3	_lezzy
lick	10	69	3507	3	_lick_
licks	11	53	2539	3	_licks
linky	12	76	2238	3	_linky
lock	10	61	3436	3	_lock_
locks	11	51	2692	3	_locks
luck	10	53	2982	3	_luck_
lucks	11	57	2356	3	_lucks
mucky	16	50	1525	3	_mucky
neck	10	54	2366	3	_neck_
necks	11	51	1933	3	_necks
peaky	14	57	1815	3	_peaky
peck	12	57	3068	3	_peck_
pecks	13	57	2443	3	_pecks
perky	14	53	1948	3	_perky
pesky	14	59	1156	3	_pesky
picky	16	54	1694	3	_picky
plack	13	50	1784	3	plack_
placks	14	44	1415	3	placks
plenty	11	3	1141	3	plenty
plisky	15	3	371	3	plisky
pluck	13	42	1230	3	pluck_
plucks	14	37	973	3	plucks
plunky	15	37	795	3	plunky
pocky	16	53	1460	3	_pocky
pricky	17	42	1034	3	pricky
quacky	24	37	696	3	quacky
reck	10	61	3056	3	_reck_
recks	11	56	2513	3	_recks
reechy	14	36	782	3	reechy
reeky	12	54	1626	3	_reeky
rocky	14	45	1385	3	_rocky
shlocky	19	31	450	3	shlocky
slack	11	50	2176	3	slack_
slackly	16	3	526	3	slackly
slacks	12	44	1653	3	slacks
sleazy	18	26	739	3	sleazy
sleek	9	46	1904	3	sleek_
sleekly	14	32	519	3	sleekly
sleeks	10	45	1246	3	sleeks
sleepy	11	47	941	3	sleepy
sleety	9	41	1265	3	sleety
slick	11	55	2052	3	slick_
slickly	16	3	585	3	slickly
slicks	12	48	1611	3	slicks
slinky	13	39	910	3	slinky
sneaky	13	42	784	3	sneaky
sneck	11	47	1366	3	sneck_
snecks	12	44	1003	3	snecks
speck	13	51	1565	3	speck_
specks	14	43	1270	3	specks
sticky	15	47	1134	3	sticky
stocky	15	36	915	3	stocky
sucky	14	44	1550	3	_sucky
tacky	14	56	1744	3	_tacky
talcky	15	29	472	3	talcky
techy	13	56	1201	3	_techy
tricky	15	42	1147	3	tricky
tweaky	16	3	402	3	tweaky
unlucky	16	4	322	3	unlucky
wacky	17	47	1493	3	_wacky
whacky	21	55	649	3	whacky
whelky	19	31	497	3	whelky
wreck	14	46	1104	3	wreck_
wrecks	15	41	888	3	wrecks
yechy	16	51	908	3	_yechy
yeuky	15	54	703	3	_yeuky
yucky	17	54	1169	3	_yucky
zincky	24	40	496	3	zincky

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.393	454684.5
2	DLD Change Limit	112716	332	5.200	21676.2
3	Display Results	332	332	0.110	3018.2
	(SQL Overall)	178691	332	5.703	31332.8