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

Here are the results of your fuzzy-string dictionary search for “highly” 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
highly	16	3	682	(None)
bigly	11	48	1475	2	big_ly
eighty	13	37	1160	2	eighty
giggly	12	51	870	2	giggly
higgle	11	38	1174	2	higgle
high	11	66	1992	2	high__
highboy	19	4	339	2	highboy
higher	13	46	1089	2	higher
highs	12	54	1252	2	high_s
hight	12	53	2723	2	high_t
highth	12	38	915	2	highth
hights	13	37	1689	2	hights
highway	20	4	426	2	highway
hilly	11	44	2216	2	hi_lly
hiply	13	41	1361	2	hi_ply
hugely	13	3	680	2	hugely
jiggly	18	37	871	2	jiggly
lightly	14	36	902	2	lightly
mighty	15	43	1021	2	mighty
niggly	11	41	891	2	niggly
nightly	14	44	903	2	nightly
nighty	13	56	1127	2	nighty
richly	14	3	800	2	richly
rightly	14	38	904	2	rightly
righty	13	50	1183	2	righty
sightly	14	40	827	2	sightly
tightly	14	32	761	2	tightly
wiggly	14	55	968	2	wiggly
agly	8	68	2180	3	_ag_ly
airily	9	30	1482	3	airily
apishly	15	3	566	3	apishly
archly	14	3	735	3	archly
bialy	10	51	1932	3	bi_aly
bigamy	14	3	634	3	bigamy
biggy	12	44	1313	3	big_gy
bight	11	87	2884	3	bigh_t
bights	12	44	1796	3	bights
billy	10	55	2536	3	bi_lly
blighty	16	35	684	3	blighty
brightly	17	6	455	3	brightly
cagily	12	4	1156	3	cagily
chicly	16	42	920	3	chi_cly
chiefly	18	3	410	3	chiefly
childly	16	4	480	3	childly
chilly	14	41	1322	3	chi_lly
chimbly	19	7	459	3	chimbly
cicely	13	3	883	3	cicely
diddly	12	38	957	3	diddly
digamy	13	3	589	3	digamy
dight	10	40	2700	3	digh_t
dights	11	40	1696	3	dights
dilly	9	49	2378	3	di_lly
dimly	11	49	1348	3	di_mly
dimply	14	33	974	3	dimply
dinghy	14	47	696	3	dingh_y
dingily	12	3	810	3	dingily
dinkly	14	43	1108	3	dinkly
direly	10	3	1156	3	direly
dishy	12	57	1235	3	dish_y
edgily	11	3	606	3	edgily
eight	9	49	2805	3	eigh_t
eighth	13	33	1060	3	eighth
eighthly	18	4	370	3	eighthly
eights	10	36	1898	3	eights
fickly	18	31	853	3	fickly
fiddly	14	32	848	3	fiddly
fifthly	19	4	309	3	fifthly
fight	12	40	2709	3	figh_t
fights	13	38	1655	3	fights
filly	11	44	2490	3	fi_lly
finely	12	30	1156	3	finely
firmly	14	3	666	3	firmly
fishily	16	3	764	3	fishily
fishy	14	60	1166	3	fish_y
fitly	11	51	1497	3	fi_tly
flighty	17	34	743	3	flighty
giggle	9	43	1351	3	giggle
gighe	10	13	973	3	gigh_e
gigolo	8	3	653	3	gigolo
gilly	9	43	2163	3	gi_lly
gingely	12	37	821	3	gingely
girly	9	44	1529	3	gi_rly
goggly	12	33	705	3	goggly
hackly	18	29	873	3	hackly
haggle	11	35	1198	3	haggle
haply	13	59	1506	3	h_aply
hardly	13	51	1283	3	hardly
harshly	16	3	627	3	harshly
haughty	17	33	464	3	haughty
hazily	21	7	906	3	hazily
heigh	12	48	1254	3	heigh__
height	13	47	1343	3	heigh_t
heighth	13	36	634	3	heighth
heights	14	39	944	3	heights
hickey	18	50	1199	3	hickey
higgled	13	33	907	3	higgled
higgler	12	36	980	3	higgler
higgles	12	39	1180	3	higgles
highball	17	4	389	3	highball
highboys	20	4	299	3	highboys
highest	14	3	956	3	highest
highflyer	22	5	164	3	highflyer
highland	16	11	453	3	highland
highlife	18	4	300	3	highlife
highted	15	27	1016	3	highted
highths	13	35	800	3	highths
hightop	16	4	501	3	hightop
highways	21	4	412	3	highways
hila	7	62	2835	3	hi__la
hili	7	56	2663	3	hi__li
hill	7	64	3949	3	hi__ll
hillo	8	47	2165	3	hi_llo
hills	8	54	3135	3	hi_lls
hilt	7	58	5071	3	hi__lt
hinky	15	56	1875	3	hi_nky
hinny	11	56	1667	3	hi_nny
hippy	15	51	1279	3	hi_ppy
hirple	11	15	897	3	hirple
hirsle	9	15	957	3	hirsle
hissy	11	61	1212	3	hi_ssy
hither	12	44	1725	3	hither
hokily	16	40	909	3	hokily
holily	12	36	1295	3	holily
holly	11	48	2443	3	h_olly
holy	10	63	3343	3	h__oly
homely	14	53	1318	3	homely
homily	14	47	1233	3	homily
hooly	11	50	2222	3	h_ooly
hostly	12	42	1086	3	hostly
hotly	11	58	1548	3	h_otly
hourly	12	36	962	3	hourly
hubbly	16	47	841	3	hubbly
humbly	16	40	1052	3	humbly
hurly	11	58	1929	3	h_urly
icily	10	12	1169	3	_icily
idly	8	56	1732	3	_i_dly
iglu	5	108	1478	3	_ig_lu
illy	7	69	2533	3	_i_lly
imply	12	49	1184	3	_imply
inly	7	56	2221	3	_i_nly
jiggle	15	38	1199	3	jiggle
jiggy	17	54	914	3	jig_gy
jimply	20	39	748	3	jimply
jingly	17	41	1193	3	jingly
kindly	14	35	884	3	kindly
kingly	14	35	1130	3	kingly
knightly	19	5	301	3	knightly
laithly	13	3	565	3	laithly
lichtly	15	25	552	3	lichtly
liefly	12	6	636	3	liefly
light	9	44	2960	3	ligh_t
lights	10	45	1991	3	lights
ligula	7	35	967	3	ligula
ligule	7	40	1083	3	ligule
likely	13	32	813	3	likely
lily	7	67	3018	3	li__ly
limply	13	38	1003	3	limply
lithely	13	5	664	3	lithely
lively	12	33	1081	3	lively
logily	10	3	983	3	logily
lushly	12	24	734	3	lushly
miggle	10	40	1211	3	miggle
might	11	38	2708	3	migh_t
mightily	17	4	462	3	mightily
mights	12	35	1625	3	mights
mildly	12	31	824	3	mildly
mizzly	19	25	610	3	mizzly
muchly	16	8	620	3	muchly
muhly	13	5	852	3	_muhly
nicely	11	3	949	3	nicely
niggle	8	36	1282	3	niggle
nigh	8	52	2066	3	nigh__
nighed	11	38	1129	3	nighed
nigher	10	36	1275	3	nigher
nighs	9	50	1361	3	nigh_s
night	9	43	2785	3	nigh_t
nights	10	41	1772	3	nights
nimbly	13	38	877	3	nimbly
ninthly	13	4	421	3	ninthly
oilily	9	31	1172	3	oilily
oily	7	79	3225	3	oi__ly
piddly	13	31	914	3	piddly
piggy	12	40	1143	3	pig_gy
pigmy	13	29	943	3	pig_my
pigsty	12	3	593	3	pigsty
pily	9	61	3273	3	pi__ly
pimply	15	32	921	3	pimply
pinkly	15	50	1224	3	pinkly
pithily	15	6	703	3	pithily
pithy	13	56	1446	3	pith_y
poshly	14	3	772	3	poshly
rashly	12	34	1021	3	rashly
rifely	12	37	1003	3	rifely
right	9	44	3050	3	righ_t
righto	10	41	1109	3	righto
rights	10	40	1933	3	rights
rigidly	12	3	553	3	rigidly
ripely	11	25	1115	3	ripely
ripply	13	34	800	3	ripply
roughly	14	50	729	3	roughly
sagely	10	28	1138	3	sagely
shily	11	52	2201	3	shi__ly
shingly	14	32	1081	3	shingly
shinily	13	26	893	3	shinily
sickly	15	31	1048	3	sickly
sigh	8	56	2589	3	sigh__
sighed	11	37	1205	3	sighed
sigher	10	38	1370	3	sigher
sighs	9	54	1674	3	sigh_s
sight	9	46	2929	3	sigh_t
sights	10	38	1801	3	sights
sigil	6	35	1550	3	sigil_
sigils	7	39	1236	3	sigils
sigla	6	45	1520	3	sig_la
silly	8	45	2762	3	si_lly
simply	13	30	1052	3	simply
singly	10	40	1585	3	singly
sixthly	20	4	287	3	sixthly
slightly	15	4	460	3	slightly
swithly	16	3	444	3	swithly
teughly	14	44	343	3	teughly
thegnly	14	4	261	3	thegnly
thickly	19	41	557	3	thickly
thigh	12	4	1012	3	thigh__
thighed	15	3	527	3	thighed
thighs	13	4	663	3	thigh_s
thinly	12	3	867	3	thi_nly
thirdly	14	4	463	3	thirdly
thistly	13	9	596	3	thistly
tiddly	11	30	878	3	tiddly
tidily	10	28	1139	3	tidily
tight	9	36	2650	3	tigh_t
tights	10	40	1585	3	tights
timely	11	34	1011	3	timely
tingly	10	38	1597	3	tingly
tinily	9	40	1443	3	tinily
tinkly	13	48	1115	3	tinkly
toughly	14	48	743	3	toughly
trigly	10	38	1094	3	trig_ly
ugly	8	60	1238	3	_ug_ly
viably	14	19	983	3	viably
vichy	16	3	904	3	vich_y
vigil	9	43	1300	3	vigil_
vigils	10	42	1019	3	vigils
vilely	12	3	944	3	vilely
waggly	14	34	729	3	waggly
weighty	17	37	623	3	weighty
whirly	15	44	886	3	whi_rly
whitely	16	34	647	3	whitely
widely	13	33	1103	3	widely
wifely	15	42	942	3	wifely
wiggle	11	37	1301	3	wiggle
wiggy	13	45	1073	3	wig_gy
wight	12	37	2557	3	wigh_t
wights	13	33	1578	3	wights
wildly	13	32	812	3	wildly
wilily	12	33	1076	3	wilily
willy	11	53	2191	3	wi_lly
wily	10	64	2881	3	wi__ly
wirily	12	33	1078	3	wirily
wisely	12	27	1171	3	wisely
withy	14	48	1376	3	with_y
wriggly	15	32	489	3	wriggly

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	5.423	20784.8
3	Display Results	263	263	0.080	3287.5
	(SQL Overall)	178691	263	5.893	30322.6