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

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

289 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
highted	15	27	1016	(None)
bighted	14	28	1092	1	bighted
dighted	13	25	1149	1	dighted
lighted	12	29	1350	1	lighted
righted	12	29	1214	1	righted
sighted	12	31	1152	1	sighted
alighted	13	4	767	2	alighted
bigoted	11	25	840	2	bigoted
blighted	15	4	686	2	blighted
fighter	14	30	1076	2	fighter
flighted	16	4	697	2	flighted
frighted	16	5	717	2	frighted
heighten	15	4	570	2	heighten
higgled	13	33	907	2	higgled
highbred	18	4	337	2	highbred
higher	13	46	1089	2	high_er
hight	12	53	2723	2	hight__
highth	12	38	914	2	hight_h
highths	13	35	800	2	highths
hightop	16	4	501	2	hightop
hights	13	37	1689	2	hight_s
hilted	10	40	1604	2	hi_lted
hinted	10	43	1832	2	hi_nted
histed	10	44	2024	2	hi_sted
knighted	17	4	512	2	knighted
lichted	13	26	880	2	lichted
ligated	9	24	1413	2	ligated
lighten	11	28	1152	2	lighten
lighter	11	31	1342	2	lighter
nighed	11	38	1129	2	nigh_ed
oughted	12	3	622	2	oughted
plighted	15	4	646	2	plighted
righter	11	32	1237	2	righter
sighed	11	37	1205	2	sigh_ed
sighter	11	34	1210	2	sighter
slighted	13	5	739	2	slighted
thighed	15	3	526	2	thigh_ed
tighten	11	28	897	2	tighten
tighter	11	29	1068	2	tighter
weighted	16	3	559	2	weighted
whishted	18	4	315	2	whishted
agisted	9	3	820	3	agisted
airted	7	42	1450	3	ai_rted
airthed	11	32	830	3	airthed
bedighted	17	4	458	3	bedighted
benighted	16	4	474	3	benighted
bighead	14	12	665	3	bighead
bight	11	87	2884	3	bight__
bights	12	44	1796	3	bight_s
bilsted	10	3	803	3	bilsted
birthed	13	22	859	3	birthed
bitted	9	44	1848	3	bi_tted
blighter	14	6	685	3	blighter
brighten	14	6	624	3	brighten
brighter	14	7	666	3	brighter
cisted	9	52	1752	3	ci_sted
cited	8	44	2195	3	ci__ted
delighted	15	4	620	3	delighted
dieted	8	31	1549	3	di_eted
digested	11	20	816	3	digested
digged	10	43	1465	3	dig_ged
dight	10	40	2700	3	dight__
dights	11	40	1696	3	dight_s
dilated	9	31	1582	3	dilated
diluted	9	24	893	3	diluted
dinted	8	44	1984	3	di_nted
dished	11	43	1871	3	dish_ed
eight	9	49	2805	3	eight__
eighteen	12	4	576	3	eighteen
eighth	13	33	1060	3	eight_h
eighths	14	38	829	3	eighths
eighties	12	7	1080	3	eighties
eights	10	36	1898	3	eight_s
eightvo	14	4	384	3	eightvo
eighty	13	37	1160	3	eight_y
fagoted	12	3	607	3	fagoted
fidgeted	14	4	389	3	fidgeted
figged	12	40	1389	3	fig_ged
fight	12	40	2709	3	fight__
fighters	15	26	939	3	fighters
fights	13	38	1655	3	fight_s
figured	12	19	647	3	figured
fileted	11	5	909	3	fileted
fished	13	43	1631	3	fish_ed
fisted	10	42	1870	3	fi_sted
fitted	10	47	1666	3	fi_tted
fixated	18	3	553	3	fixated
freighted	17	5	520	3	freighted
frighten	15	6	644	3	frighten
gated	7	53	2977	3	__gated
gifted	11	45	1070	3	gi_fted
gigged	10	41	1229	3	gig_ged
giggled	11	40	1007	3	giggled
gighe	10	13	973	3	gigh_e_
girted	8	39	1287	3	gi_rted
girthed	12	26	624	3	girthed
gitted	8	40	1505	3	gi_tted
habited	13	3	788	3	habited
hafted	13	47	1383	3	h_afted
hagged	12	43	1770	3	hag_ged
haggled	13	35	928	3	haggled
halted	10	50	1960	3	h_alted
hanted	10	41	2431	3	h_anted
hashed	13	60	2194	3	hash_ed
hasted	10	51	2528	3	h_asted
hated	9	57	3402	3	h__ated
hatted	10	49	2151	3	h_atted
haunted	11	39	973	3	haunted
hearted	11	33	1402	3	hearted
heated	10	45	2559	3	h_eated
hefted	13	49	1142	3	h_efted
height	13	47	1343	3	height__
heightened	18	4	301	3	heightened
heightens	16	4	471	3	heightens
heighth	13	36	634	3	height_h
heighths	14	32	482	3	heighths
heights	14	39	944	3	height_s
heisted	11	32	1065	3	heisted
hented	10	42	1875	3	h_ented
hided	10	52	2244	3	hi__ded
hied	8	54	3404	3	hi___ed
higgle	11	38	1174	3	higgle_
higgler	12	36	980	3	higgler
higgles	12	39	1180	3	higgles
high	11	66	1991	3	high___
highboy	19	4	339	3	highboy
highest	14	3	956	3	highest
highland	16	11	452	3	highland
highly	16	3	682	3	high_ly
highness	15	3	605	3	highness
highroad	16	4	370	3	highroad
highs	12	54	1252	3	high__s
hightail	15	4	525	3	hightail
hightailed	18	5	281	3	hight~~ail~~ed
highting	16	25	972	3	highting
hightops	17	4	504	3	hightops
highway	20	4	425	3	highway
hiked	13	59	1920	3	hi__ked
hilled	10	40	2222	3	hi_lled
hilloed	11	32	1129	3	hilloed
hinged	11	46	1891	3	hi_nged
hinnied	11	34	810	3	hinnied
hinter	9	40	2130	3	hi_nter
hipped	14	43	1769	3	hi_pped
hipster	12	28	878	3	hipster
hired	9	52	2626	3	hi__red
hirpled	13	15	713	3	hirpled
hirsled	11	11	811	3	hirsled
hissed	10	41	1445	3	hi_ssed
hitched	16	33	1225	3	hitched
hither	12	44	1725	3	hith_er
hitter	9	44	1986	3	hi_tter
hived	12	52	1791	3	hi__ved
hogged	12	58	1777	3	hog_ged
hogtied	12	22	665	3	hogtied
hogweed	15	3	444	3	hogweed
hoisted	11	34	1129	3	hoisted
hooted	10	44	2265	3	h_ooted
hosted	10	50	2034	3	h_osted
hotted	10	43	1993	3	h_otted
hugged	12	41	1364	3	hug_ged
hunted	10	44	1701	3	h_unted
hushed	13	44	1667	3	hush_ed
hutted	10	46	1633	3	h_utted
igged	8	60	1276	3	_ig_ged
ignited	9	13	762	3	_ignited
ingoted	9	3	917	3	ingoted
jigged	16	44	1277	3	jig_ged
jiggled	17	35	884	3	jiggled
jilted	14	41	1135	3	ji_lted
kilted	11	36	1383	3	ki_lted
kited	10	51	2009	3	ki__ted
kithed	14	46	1301	3	kith_ed
kitted	11	51	1483	3	ki_tted
legated	9	25	1398	3	legated
lifted	10	44	1352	3	li_fted
ligate	7	25	1924	3	ligate_
ligates	8	23	1837	3	ligates
light	9	44	2960	3	light__
lightened	14	4	602	3	lightened
lightens	12	25	999	3	lightens
lightered	14	4	626	3	lightered
lighters	12	31	1137	3	lighters
lightest	12	14	1035	3	lightest
lightly	14	36	902	3	lightly
lights	10	45	1991	3	light_s
lilted	7	37	1537	3	li_lted
limited	10	23	1023	3	limited
linted	7	40	2182	3	li_nted
listed	7	43	2283	3	li_sted
lithoed	11	3	783	3	lithoed
miched	14	39	1339	3	mich_ed
might	11	38	2708	3	might__
mightier	14	3	638	3	mightier
mights	12	35	1625	3	might_s
mighty	15	43	1020	3	might_y
migrated	12	11	1049	3	migrated
milted	9	39	1994	3	mi_lted
minted	9	42	2058	3	mi_nted
minuted	10	32	950	3	minuted
misted	9	36	2582	3	mi_sted
negated	9	34	1323	3	negated
neighed	12	13	589	3	neigh_ed
niched	12	55	1406	3	nich_ed
nidated	9	3	986	3	nidated
niggled	10	31	920	3	niggled
nigher	10	36	1275	3	nigh_er
night	9	43	2785	3	night__
nightie	11	7	965	3	nightie
nighties	12	10	1138	3	nighties
nightly	14	44	903	3	nightly
nights	10	41	1772	3	night_s
nighty	13	56	1127	3	night_y
picoted	12	3	921	3	picoted
pigged	11	42	1415	3	pig_ged
pigweed	14	6	509	3	pigweed
piloted	10	3	1032	3	piloted
pirated	10	25	1561	3	pirated
pished	12	48	1706	3	pish_ed
pithed	12	46	1561	3	pith_ed
pitted	9	43	1959	3	pi_tted
pivoted	13	3	651	3	pivoted
plighter	14	7	662	3	plighter
relighted	14	3	686	3	relighted
resighted	14	3	652	3	resighted
rifted	10	41	1531	3	ri_fted
rigged	9	45	1740	3	rig_ged
right	9	44	3050	3	right__
righters	12	26	1070	3	righters
rightest	12	14	958	3	rightest
righties	12	7	1157	3	righties
rightly	14	38	904	3	rightly
righto	10	41	1109	3	right_o
rights	10	40	1933	3	right_s
righty	13	50	1183	3	right_y
rioted	7	34	1637	3	ri_oted
riveted	11	25	857	3	riveted
shifted	14	35	997	3	shi_fted
shitted	11	42	1204	3	shi_tted
sifted	10	43	1367	3	si_fted
sigher	10	38	1370	3	sigh_er
sight	9	46	2929	3	sight__
sighters	12	25	1059	3	sighters
sightly	14	40	827	3	sightly
sights	10	38	1801	3	sight_s
sightsee	12	4	547	3	sightsee
signed	8	34	1375	3	sig_ned
signeted	10	3	597	3	signeted
silted	7	40	2001	3	si_lted
sited	6	51	3074	3	si__ted
slighter	12	5	782	3	slighter
sughed	11	36	1020	3	sugh_ed
thirsted	12	3	521	3	thirsted
tight	9	36	2650	3	tight__
tightened	14	4	496	3	tightened
tightens	12	29	794	3	tightens
tightest	12	14	836	3	tightest
tightly	14	32	761	3	tightly
tights	10	40	1585	3	tight_s
tightwad	16	4	290	3	tightwad
tilted	7	46	1686	3	ti_lted
tincted	10	3	727	3	tincted
tinted	7	44	1953	3	ti_nted
tithed	10	41	1559	3	tith_ed
togated	9	44	1066	3	togated
ungated	9	27	1721	3	ungated
unlighted	14	5	577	3	unlighted
unsighted	14	5	542	3	unsighted
uplighted	16	5	384	3	uplighted
uprighted	16	5	421	3	uprighted
visited	11	6	877	3	visited
waughted	16	4	348	3	waughted
weighed	15	13	593	3	weigh_ed
weighter	15	3	560	3	weighter
whished	17	42	802	3	whish_ed
whisted	14	40	1001	3	whi_sted
whited	13	48	1408	3	whi__ted
wigged	12	44	1358	3	wig_ged
wiggled	13	29	960	3	wiggled
wight	12	37	2557	3	wight__
wights	13	33	1578	3	wight_s
wilted	10	39	1571	3	wi_lted
wished	13	44	1751	3	wish_ed
wisted	10	41	2027	3	wi_sted
wited	9	47	2714	3	wi__ted
withed	13	44	1623	3	with_ed
witted	10	42	1681	3	wi_tted
yachted	16	3	485	3	yachted
zigged	18	41	1019	3	zig_ged

Search took 9 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.156	1145455.1
2	DLD Change Limit	134027	289	7.843	17088.7
3	Display Results	289	289	0.110	2627.3
	(SQL Overall)	178691	289	8.109	22036.1