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

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

435 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
lehua	8	3	795	(None)
lehuas	9	3	594	1	lehuas
genua	6	46	1415	2	genua
jehu	14	56	1486	2	jehu_
jehus	15	48	857	2	jehus
lea	3	76	6018	2	le__a
lehr	7	55	1494	2	leh_r
lehrs	8	61	1113	2	lehrs
leku	8	65	1991	2	leku_
lemma	9	48	1103	2	lemma
lemur	7	3	977	2	lemur
lepta	7	57	1439	2	lepta
letup	7	37	1216	2	letup
leu	3	60	4740	2	le_u_
leud	5	72	2342	2	le_ud
leva	7	70	2071	2	le_va
tegua	6	10	956	2	tegua
aecia	7	38	1928	3	aecia
agha	8	74	1730	3	agh_a
aha	6	112	4664	3	_ah_a
alexia	13	29	1046	3	alexia
aloha	8	5	1361	3	aloh_a
alpha	10	4	965	3	alph_a
althea	9	3	819	3	althea
aqua	13	28	1396	3	_aqua
beau	6	61	3727	3	beau_
beaus	7	51	2711	3	beaus
beaut	7	51	3521	3	beaut
beaux	14	65	1321	3	beaux
bedu	7	59	2369	3	bedu_
begum	10	52	1392	3	begum
begun	8	51	1344	3	begun
behead	12	3	992	3	behead
belga	8	3	1323	3	belga
beluga	9	3	623	3	beluga
bema	8	58	2525	3	be_ma
beta	6	62	3413	3	be_ta
betta	7	49	1684	3	betta
bhut	9	54	2571	3	_bhut
bohea	10	50	1373	3	bohea
ceca	8	48	2078	3	ce_ca
cecum	11	6	1184	3	cecum
cedula	9	7	764	3	cedula
ceiba	9	3	870	3	ceiba
cella	7	54	2031	3	cella
ceria	7	51	2535	3	ceria
cesta	7	54	1948	3	cesta
cesura	8	3	876	3	cesura
chela	10	39	1680	3	chela
chia	9	60	2662	3	_chia
chub	11	55	1641	3	_chub
chufa	13	48	911	3	_chufa
chug	10	59	1411	3	_chug
chum	11	63	1800	3	_chum
debug	9	42	1006	3	debug
debut	8	60	2414	3	debut
degum	9	47	1190	3	degum
delta	6	61	1777	3	delta
demur	8	3	1116	3	demur
derma	8	49	1851	3	derma
deva	8	57	2098	3	de_va
eau	3	74	5094	3	_eau_
eaux	11	66	1842	3	_eaux
ecu	5	68	2823	3	_ecu_
ecus	6	54	2146	3	_ecus
eh	5	83	3996	3	_eh__
elhi	7	6	1240	3	elh_i
emu	5	59	2998	3	_emu_
emus	6	68	2168	3	_emus
enuf	7	3	2384	3	_enuf
epha	9	3	1005	3	_epha
equal	14	4	982	3	_equal
era	3	57	4150	3	_e_ra
eta	3	58	3419	3	_e_ta
etna	4	64	1526	3	_etna
etui	4	54	1623	3	_etui
eyra	7	62	1755	3	_eyra
fecula	11	33	1005	3	fecula
feh	9	61	3609	3	feh__
fehs	10	65	2238	3	feh_s
fella	8	49	1865	3	fella
femur	10	3	868	3	femur
feria	8	59	2271	3	feria
ferula	9	30	1117	3	ferula
feta	7	65	2890	3	fe_ta
fetus	8	58	1654	3	fetus
feu	6	78	4366	3	fe_u_
feuar	8	3	1024	3	fe_uar
feud	8	65	2302	3	fe_ud
feus	7	58	3075	3	fe_us
flea	7	56	2849	3	fle__a
gemma	10	63	1177	3	gemma
genoa	6	43	1582	3	genoa
genu	5	59	2907	3	genu_
genus	6	53	1983	3	genus
geta	5	66	2744	3	ge_ta
getup	8	34	1026	3	getup
geum	7	54	2455	3	ge_um
gleba	8	39	1024	3	gle_ba
ha	5	102	5994	3	__h_a
haha	10	78	2106	3	hah_a
heh	9	60	3962	3	heh__
hehs	10	67	2396	3	heh_s
henna	8	44	1404	3	henna
herma	10	53	1888	3	herma
hub	8	64	3748	3	__hub
hue	6	66	4230	3	__hue
hug	7	60	3736	3	__hug
huh	9	64	3201	3	__huh
hula	7	49	2375	3	__hula
hum	8	55	4293	3	__hum
hun	6	58	4471	3	__hun
hup	8	64	3781	3	__hup
hut	6	64	5729	3	__hut
ilea	4	59	3146	3	ile__a
ileum	7	45	1282	3	ile_um
ileus	5	46	1689	3	ile_us
jehad	16	3	768	3	jehad
jejuna	12	4	324	3	jejuna
jeu	10	55	3207	3	je_u_
jeux	18	43	1127	3	je_ux
kahuna	13	9	410	3	kahuna
kea	7	65	4091	3	ke__a
kheda	13	4	653	3	kheda
la	2	192	6163	3	l___a
labia	7	52	1901	3	labia
labra	7	54	1546	3	labra
lacuna	8	11	812	3	lacuna
laguna	7	12	722	3	laguna
lahar	8	31	1426	3	lahar
lama	6	66	3529	3	l_ama
lamia	7	53	2432	3	lamia
larum	7	43	1797	3	larum
larva	8	3	1248	3	larva
latu	4	79	3418	3	latu_
lauan	5	52	1679	3	l_auan
laud	5	65	2772	3	l_aud
laura	5	41	1620	3	laura
lava	7	67	2542	3	l_ava
layup	10	3	772	3	layup
leach	10	54	2252	3	leach
lead	5	60	3885	3	le_ad
leads	6	60	2849	3	leads
leady	9	56	1860	3	leady
leaf	7	64	4103	3	le_af
leafs	8	57	2118	3	leafs
leafy	11	63	1621	3	leafy
league	7	5	874	3	league
leak	8	62	3371	3	le_ak
leaks	9	59	2391	3	leaks
leaky	12	52	1772	3	leaky
leal	4	60	4327	3	le_al
lean	4	63	4524	3	le_an
leans	5	55	3625	3	leans
leant	5	67	3778	3	leant
leap	6	60	3268	3	le_ap
leaps	7	55	2293	3	leaps
leapt	7	50	2747	3	leapt
lear	4	70	4595	3	le_ar
learn	5	53	2266	3	learn
lears	5	59	3873	3	lears
leary	8	59	2738	3	leary
leas	4	59	5418	3	le_as
lease	5	52	3026	3	lease
leash	8	55	1921	3	leash
least	5	61	3488	3	least
leave	8	47	2372	3	leave
leavy	11	57	1577	3	leavy
leben	7	3	1485	3	leben
lech	9	68	2544	3	le_ch
leched	12	37	1600	3	leched
lecher	11	34	1585	3	lecher
leches	11	54	2131	3	leches
lechwe	14	3	511	3	lechwe
led	4	62	5455	3	le__d
ledge	7	65	1946	3	ledge
ledgy	10	57	1201	3	ledgy
lee	3	60	6814	3	le__e
leech	10	49	1321	3	leech
leek	8	53	3173	3	le_ek
leeks	9	53	1889	3	leeks
leer	4	62	3935	3	le_er
leers	5	48	2898	3	leers
leery	8	59	1913	3	leery
lees	4	54	5588	3	le_es
leet	4	59	5790	3	le_et
leets	5	49	2712	3	leets
leeway	12	5	588	3	leeway
left	7	63	4048	3	le_ft
lefts	8	65	1781	3	lefts
lefty	11	56	1356	3	lefty
leg	4	64	4611	3	le__g
legal	6	57	1594	3	legal
leger	6	57	2150	3	leger
leges	6	44	2728	3	leges
leggy	10	52	1024	3	leggy
legit	6	13	2350	3	legit
legman	9	4	965	3	legman
legs	5	61	3369	3	le_gs
legume	9	3	691	3	legume
lei	3	68	4638	3	le__i
leis	4	57	3960	3	le_is
lek	7	56	4030	3	le__k
leke	8	55	2740	3	le_ke
leks	8	54	2760	3	le_ks
lekvar	13	3	304	3	lekvar
leman	7	56	2260	3	leman
lemmas	10	34	916	3	lemmas
lemon	7	56	1818	3	lemon
lemurs	8	3	725	3	lemurs
lend	5	62	3367	3	le_nd
lends	6	53	2625	3	lends
lenes	5	47	3852	3	lenes
lenis	5	63	2686	3	lenis
leno	4	73	3139	3	le_no
lenos	5	60	2486	3	lenos
lens	4	61	4649	3	le_ns
lense	5	45	2343	3	lense
lent	4	63	6053	3	le_nt
lento	5	72	2339	3	lento
leone	5	50	1882	3	leone
leper	7	48	2074	3	leper
lept	6	64	4088	3	le_pt
les	3	56	6307	3	le__s
lesbo	7	3	925	3	lesbo
leses	5	49	3081	3	leses
less	4	56	3510	3	le_ss
lest	4	69	5632	3	le_st
let	3	64	8147	3	le__t
letch	10	52	1580	3	letch
lethal	9	3	980	3	lethal
lethe	8	57	1730	3	lethe
lethean	10	3	709	3	lethean
lethes	9	48	1808	3	lethes
lets	4	71	4794	3	le_ts
letups	8	31	768	3	letups
leuds	6	62	1481	3	leuds
lev	6	61	3942	3	le__v
levee	8	40	2381	3	levee
level	8	41	1655	3	level
lever	8	51	2516	3	lever
levin	8	48	1641	3	levin
levis	8	58	1855	3	levis
levo	7	68	2006	3	le_vo
levy	10	64	1850	3	le_vy
lewd	8	57	1659	3	le_wd
lewis	8	53	1584	3	lewis
lex	10	79	4382	3	le__x
lexes	12	72	2526	3	lexes
lexica	15	3	610	3	lexica
lexis	12	59	1603	3	lexis
ley	6	62	4681	3	le__y
leys	7	64	3018	3	le_ys
lez	12	55	4131	3	le__z
lezzy	16	60	808	3	lezzy
liana	5	39	1589	3	liana
libra	7	47	1242	3	libra
lieu	4	65	3436	3	lieu_
lieus	5	62	1848	3	lieus
ligula	7	35	967	3	ligula
likuta	10	3	421	3	likuta
lima	6	57	3413	3	l_ima
limba	9	54	1498	3	limba
limpa	9	70	1446	3	limpa
linga	6	68	2082	3	linga
lingua	7	50	991	3	lingua
linum	7	3	1382	3	linum
lipa	6	84	2592	3	l_ipa
lira	4	69	2868	3	l_ira
lithia	9	3	933	3	lithia
litu	4	76	3156	3	litu_
llama	7	9	989	3	llama
loca	6	55	2768	3	l_oca
lochia	11	5	831	3	lochia
locum	9	48	1217	3	locum
locus	7	48	1999	3	locus
logia	6	81	1660	3	logia
loofa	8	59	1281	3	loofa
loquat	15	5	828	3	loquat
lota	4	72	3350	3	l_ota
lotus	5	57	1806	3	lotus
loud	5	52	2804	3	l_oud
louma	7	62	1363	3	louma
loup	6	60	2843	3	l_oup
lour	4	54	3068	3	l_our
lout	4	59	5214	3	l_out
luau	4	48	2416	3	l__uau
luaus	5	45	1490	3	luaus
luffa	11	40	902	3	luffa
lug	4	61	3806	3	l__ug
lulu	4	41	2288	3	lulu_
lulus	5	43	1516	3	lulus
lum	5	55	4293	3	l__um
luma	6	55	2752	3	l_uma
luna	4	62	2985	3	l_una
lunula	6	3	617	3	lunula
lupus	7	45	1252	3	lupus
lusus	5	48	1387	3	lusus
lutea	5	48	1907	3	lutea
luv	6	71	2577	3	l__uv
lux	10	65	2877	3	l__ux
lycea	10	41	894	3	lycea
lycra	10	31	797	3	lycra
lyssa	8	3	571	3	lyssa
lytta	8	8	806	3	lytta
mecca	11	3	993	3	mecca
media	8	47	2171	3	media
medusa	9	3	629	3	medusa
mega	7	76	2087	3	me_ga
mensa	7	53	1866	3	mensa
menta	7	44	2442	3	menta
menu	6	51	3022	3	menu_
menus	7	58	2284	3	menus
meou	6	53	2586	3	meou_
meous	7	61	2006	3	meous
mesa	6	70	2548	3	me_sa
meshuga	13	4	299	3	meshuga
meta	6	59	3241	3	me_ta
mezuza	16	4	353	3	mezuza
mohur	10	3	651	3	mohur
nebula	8	5	733	3	nebula
negus	6	45	1356	3	negus
nema	6	55	2252	3	ne_ma
neuk	8	74	1660	3	ne_uk
neum	6	67	2308	3	ne_um
nevus	8	46	1139	3	nevus
nexus	12	47	1066	3	nexus
ohia	7	57	1936	3	_ohia
olea	4	65	3272	3	ole__a
oleum	7	36	1332	3	ole_um
pea	5	66	5724	3	pe__a
peh	8	67	4096	3	peh__
pehs	9	56	2576	3	peh_s
penna	7	45	2020	3	penna
pepla	9	3	1286	3	pepla
perea	7	50	2644	3	perea
phut	9	69	2597	3	_phut
plea	6	68	3060	3	ple__a
plena	7	58	1639	3	ple_na
plenum	10	3	950	3	plenum
pleura	8	3	753	3	pleura
plexus	15	37	728	3	plexus
qua	12	48	2197	3	__qua
reata	5	42	2539	3	reata
rebus	7	57	2111	3	rebus
rebut	7	59	2738	3	rebut
rebuy	10	47	1468	3	rebuy
recta	7	42	2026	3	recta
recur	7	41	1684	3	recur
recut	7	47	2924	3	recut
redia	6	55	2448	3	redia
redub	8	42	1241	3	redub
redux	13	38	1110	3	redux
regma	8	46	1233	3	regma
regna	6	46	1481	3	regna
rehab	10	3	1244	3	rehab
rehear	9	37	1322	3	rehear
reheat	9	44	2394	3	reheat
rehem	10	38	1535	3	rehem
rehung	10	3	634	3	rehung
remuda	9	3	682	3	remuda
rerun	5	87	2215	3	rerun
retia	5	53	2611	3	retia
revue	8	11	1445	3	revue
rhea	7	50	1743	3	_rhea
rheum	10	3	884	3	rheum
rhus	7	51	1405	3	_rhus
schul	10	25	1041	3	schul
schwa	13	42	684	3	schwa
sea	3	61	6129	3	se__a
sebum	9	38	1455	3	sebum
sedum	8	41	1557	3	sedum
segue	6	3	1441	3	segue
selva	8	30	1427	3	selva
senna	5	46	1798	3	senna
sensa	5	41	1747	3	sensa
sepia	7	53	1867	3	sepia
septa	7	55	1808	3	septa
sera	4	61	4139	3	se_ra
serum	7	52	2347	3	serum
seta	4	56	3731	3	se_ta
setup	7	39	1582	3	setup
sexual	13	3	841	3	sexual
sha	6	98	3778	3	_sh_a
shea	7	60	3157	3	_shea
shul	7	58	2315	3	_shul
shun	7	51	2277	3	_shun
shut	7	61	3758	3	_shut
shwa	10	60	1496	3	_shwa
skua	8	61	1315	3	_skua
tea	3	73	5332	3	te__a
tecta	7	42	1552	3	tecta
teguas	7	6	801	3	teguas
tela	4	55	3297	3	te_la
telia	5	58	2114	3	telia
tenia	5	53	2448	3	tenia
tepa	6	60	2168	3	te_pa
tephra	11	3	648	3	tephra
terga	6	33	1564	3	terga
terra	5	44	1965	3	terra
tesla	5	56	1260	3	tesla
testa	5	48	2204	3	testa
tetra	5	34	1795	3	tetra
theca	10	33	1145	3	theca
theta	8	34	1457	3	theta
thud	8	56	1391	3	_thud
thug	8	64	1548	3	_thug
thuja	15	3	521	3	_thuja
thus	7	67	2147	3	_thus
thuya	11	3	558	3	_thuya
ulema	7	10	971	3	ule_ma
vacua	10	5	1046	3	vacua
veena	8	19	1232	3	veena
vela	7	57	2554	3	ve_la
velum	10	7	1338	3	velum
vena	7	61	2629	3	ve_na
venue	8	49	1821	3	venue
venus	8	49	1890	3	venus
vera	7	68	2884	3	ve_ra
vesta	8	66	1830	3	vesta
weka	11	70	1387	3	we_ka
wha	9	64	2207	3	_wh_a
whoa	10	66	1520	3	_whoa
whup	12	57	1416	3	_whup
xenia	12	48	1477	3	xenia
xerus	12	3	1333	3	xerus
yea	6	64	4575	3	ye__a
yeh	9	71	3577	3	yeh__
yenta	8	39	1704	3	yenta
yerba	10	10	1076	3	yerba
yeuk	11	60	1547	3	ye_uk
zebra	16	3	788	3	zebra
zebu	15	34	1472	3	zebu_
zebus	16	46	1005	3	zebus
zeta	13	51	2164	3	ze_ta

Search took 5 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	83667	0.106	1685764.2
2	DLD Change Limit	83667	435	4.440	18843.9
3	Display Results	435	435	0.110	3954.5
	(SQL Overall)	178691	435	4.656	38378.7