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

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

263 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
whelky	19	31	497	(None)
whelk	15	43	1106	1	whelk_
whelks	16	36	732	1	whelks
chalky	18	46	877	2	chalky
cheeky	18	44	861	2	cheeky
hulky	15	53	1247	2	_hulky
shelly	12	44	1447	2	shelly
shelty	12	40	1155	2	shelty
shelvy	15	37	786	2	shelvy
weekly	16	3	531	2	weekly
welly	11	46	2001	2	w_elly
whacky	21	55	649	2	whacky
wheezy	24	24	452	2	wheezy
whelm	13	46	1198	2	whel_m
whelms	14	37	757	2	whelms
whelp	13	60	1209	2	whel_p
whelps	14	43	784	2	whelps
wherry	15	47	733	2	wherry
whey	13	50	1871	2	whe__y
wheyey	18	3	432	2	wheyey
whisky	19	45	590	2	whisky
wholly	15	36	657	2	wholly
wieldy	13	47	618	2	wieldy
alky	11	59	2034	3	__alky
balky	14	54	1824	3	_balky
baulky	15	44	631	3	baulky
beaky	14	61	1802	3	_beaky
belay	10	50	2152	3	_belay
belly	10	46	2549	3	_belly
bulky	14	62	1557	3	_bulky
chalk	14	48	1460	3	chalk_
chalks	15	54	1214	3	chalks
chally	14	43	1429	3	chally
check	16	47	1471	3	check_
checks	17	49	1270	3	checks
cheek	14	51	1571	3	cheek_
cheeks	15	47	1278	3	cheeks
cheery	14	49	1315	3	cheery
cheesy	14	41	919	3	cheesy
chela	10	39	1680	3	chel_a
chelae	11	36	1460	3	chelae
chelas	11	38	1720	3	chelas
cherry	14	48	1076	3	cherry
cherty	14	46	1247	3	cherty
chesty	14	46	1050	3	chesty
chevy	16	47	999	3	che_vy
chewy	16	50	1190	3	che_wy
chilly	14	41	1322	3	chilly
chinky	18	56	1054	3	chinky
choky	17	57	1122	3	ch_oky
chucky	20	41	800	3	chucky
chunky	18	46	827	3	chunky
creaky	15	49	1155	3	creaky
delay	9	48	2063	3	_delay
delly	9	60	2387	3	_delly
drecky	16	48	633	3	drecky
eely	7	77	2521	3	_eel_y
elk	7	67	2612	3	__elk_
elks	8	58	2003	3	__elks
elmy	9	56	1679	3	__elmy
felly	11	49	2280	3	_felly
flecky	18	38	765	3	flecky
folky	15	92	1471	3	_folky
freaky	16	43	923	3	freaky
geeky	13	47	1073	3	_geeky
hanky	15	54	1829	3	_hanky
heady	12	51	1726	3	_heady
heapy	13	59	1498	3	_heapy
heavy	14	48	1418	3	_heavy
heck	13	58	2649	3	_heck_
hecks	14	52	2065	3	_hecks
hedgy	13	45	1075	3	_hedgy
hefty	14	61	1213	3	_hefty
held	8	53	3040	3	_hel_d
helio	8	53	2119	3	_helio
helix	15	44	1301	3	_helix
hell	7	56	3789	3	_hel_l
hello	8	65	2298	3	_hello
hells	8	50	3204	3	_hells
helm	9	55	3002	3	_hel_m
helms	10	56	1946	3	_helms
helo	7	53	3285	3	_hel_o
helos	8	49	2806	3	_helos
helot	8	53	3268	3	_helot
help	9	53	2892	3	_hel_p
helps	10	52	1934	3	_helps
helve	11	50	1809	3	_helve
hempy	15	49	1276	3	_hempy
henley	12	3	748	3	_henley
henry	11	40	1447	3	_henry
herby	13	47	1531	3	_herby
herry	11	49	2247	3	_herry
hey	9	67	4106	3	_he__y
hilly	11	44	2216	3	_hilly
hinky	15	56	1875	3	_hinky
holey	11	56	2690	3	_holey
holk	11	60	2794	3	_holk_
holks	12	47	2056	3	_holks
holly	11	48	2443	3	_holly
holy	10	63	3343	3	_hol_y
honky	15	62	1852	3	_honky
hooky	15	52	2026	3	_hooky
hulk	11	53	2161	3	_hulk_
hulks	12	57	1548	3	_hulks
hunky	15	54	1773	3	_hunky
husky	15	61	1256	3	_husky
jelly	15	42	1825	3	_jelly
jerky	19	67	1242	3	_jerky
kelly	12	46	1702	3	_kelly
kelpy	14	51	1068	3	_kelpy
leaky	12	52	1772	3	_leaky
meekly	15	3	519	3	meekly
melty	10	49	1836	3	_melty
milky	14	40	1444	3	_milky
nelly	8	46	1881	3	_nelly
peaky	14	57	1815	3	_peaky
pecky	16	55	1509	3	_pecky
perky	14	53	1948	3	_perky
pesky	14	59	1156	3	_pesky
reeky	12	54	1626	3	_reeky
relay	8	44	2467	3	_relay
rely	7	54	2895	3	_rel_y
rheumy	14	3	335	3	rheumy
seely	8	45	2263	3	seel_y
shaky	15	46	1684	3	sh_aky
shaley	12	37	1499	3	shaley
shaly	11	43	2286	3	shal_y
sheeny	12	49	1219	3	sheeny
sheik	12	25	1466	3	sheik_
sheikh	16	20	699	3	sheikh
sheiks	13	25	1001	3	sheiks
shelf	11	52	2111	3	shel_f
shell	8	44	2412	3	shel_l
shells	9	43	1952	3	shells
shelta	9	31	1179	3	shelta
shelve	12	40	1276	3	shelve
sherry	12	45	1041	3	sherry
shily	11	52	2201	3	shil_y
shyly	14	48	1157	3	shyl_y
silky	12	53	1582	3	_silky
sleeky	13	39	896	3	sleeky
smelly	11	41	1036	3	smelly
sneaky	13	42	784	3	sneaky
stalky	13	49	930	3	stalky
sulky	12	47	1536	3	_sulky
talky	12	62	1568	3	_talky
telly	8	49	2082	3	_telly
theory	12	109	836	3	theory
thewy	14	63	1185	3	the_wy
they	10	72	2375	3	the__y
tweaky	16	3	402	3	tweaky
wacky	17	47	1493	3	w_acky
walk	11	56	2561	3	w_alk_
walks	12	62	1850	3	w_alks
wally	11	46	2509	3	w_ally
waly	10	58	3090	3	w_al_y
wanly	11	51	1802	3	wanl_y
waylay	15	3	545	3	waylay
weak	11	71	2630	3	w_eak_
weakly	16	3	648	3	w_eakly
weary	11	56	2061	3	w_eary
webby	15	3	715	3	w_ebby
wedgy	13	47	980	3	w_edgy
weedy	12	51	1500	3	w_eedy
week	11	64	2815	3	w_eek_
weeks	12	50	1786	3	w_eeks
weel	7	58	3408	3	weel__
weensy	12	41	682	3	weensy
weeny	11	53	1616	3	w_eeny
weepy	13	42	1259	3	w_eepy
weka	11	70	1387	3	w_e_ka
welch	13	44	1149	3	w_elch
weld	8	47	2773	3	w_el_d
welds	9	47	1916	3	w_elds
welkin	13	3	731	3	w_elkin
well	7	58	3204	3	w_el_l
wells	8	54	2619	3	w_ells
welsh	11	31	1036	3	w_elsh
welt	7	55	4786	3	w_el_t
welts	8	52	2519	3	w_elts
wenny	11	44	1246	3	w_enny
wetly	11	45	1171	3	w_etly
whack	17	48	1302	3	whack_
whacko	18	47	703	3	whacko
whacks	18	46	1048	3	whacks
whale	11	55	1743	3	whal_e
whaled	13	46	1203	3	whaled
whaler	12	46	1197	3	whaler
whales	12	47	1694	3	whales
whammy	19	37	529	3	whammy
wheal	11	57	1618	3	whe_al
wheals	12	45	1252	3	wheals
wheat	11	49	2457	3	whe_at
wheats	12	50	1322	3	wheats
whee	10	54	2959	3	whe__e
wheel	11	55	1533	3	whe_el
wheeled	14	31	846	3	wheeled
wheeler	13	29	877	3	wheeler
wheelie	13	3	619	3	wheelie
wheels	12	38	1171	3	wheels
wheen	11	50	1605	3	whe_en
wheens	12	46	1061	3	wheens
wheep	13	62	1435	3	whe_ep
wheeps	14	43	995	3	wheeps
wheeze	21	27	681	3	wheeze
whelkier	18	3	325	3	whelkier
whelmed	16	37	515	3	whelmed
whelped	16	35	563	3	whelped
when	10	57	2304	3	whe__n
whenas	12	46	1046	3	whenas
whence	14	18	792	3	whence
whens	11	46	1876	3	whe_ns
where	11	70	1942	3	whe_re
whereby	18	4	291	3	whereby
wheres	12	59	1743	3	wheres
wherve	15	56	811	3	wherve
whet	10	51	3378	3	whe__t
whets	11	50	1961	3	whe_ts
whew	13	76	1878	3	whe__w
whews	14	51	1449	3	whe_ws
wheylike	21	4	340	3	wheylike
wheys	14	59	1155	3	whe_ys
while	11	54	1869	3	whil_e
whiled	13	45	1413	3	whiled
whiles	12	44	1801	3	whiles
whilom	14	3	613	3	whilom
whilst	12	3	914	3	whilst
whimsy	17	37	522	3	whimsy
whiney	15	50	1264	3	whiney
whinny	15	58	749	3	whinny
whiny	14	49	1557	3	wh_iny
whippy	19	38	584	3	whippy
whirly	15	44	886	3	whirly
whirry	15	47	706	3	whirry
whisk	15	45	1014	3	whisk_
whiskey	20	44	558	3	whiskey
whisks	16	49	735	3	whisks
whitely	16	34	647	3	whitel_y
whitey	15	49	1188	3	whitey
whity	14	55	1347	3	wh_ity
whizzy	23	27	407	3	whizzy
whole	11	44	1809	3	whol_e
wholes	12	46	1677	3	wholes
why	12	69	2001	3	wh___y
widely	13	33	1103	3	widel_y
wield	9	52	1391	3	wiel_d
wields	10	46	962	3	wields
wifely	15	42	942	3	wifel_y
willy	11	53	2191	3	w_illy
wily	10	64	2881	3	w_il_y
wisely	12	27	1171	3	wisel_y
wonky	15	40	1177	3	w_onky
woolly	12	40	851	3	woolly
wooly	11	44	1767	3	wool_y
wreak	12	55	1327	3	wreak_
wreaks	13	47	1111	3	wreaks
wreck	14	46	1104	3	wreck_
wrecks	15	41	888	3	wrecks
wryly	14	35	670	3	wryl_y
yelk	11	53	2000	3	_yelk_
yelks	12	64	1362	3	_yelks
yeuky	15	54	703	3	_yeuky
yolky	15	52	952	3	_yolky

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.390	458182.1
2	DLD Change Limit	112716	263	4.623	24381.6
3	Display Results	263	263	0.080	3287.5
	(SQL Overall)	178691	263	5.093	35085.6