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

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

383 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
hernia	9	3	1229	(None)
herniae	10	3	904	1	herniae
hernial	10	3	1043	1	hernial
hernias	10	3	1077	1	hernias
ceria	7	51	2535	2	cer_ia
feria	8	59	2271	2	fer_ia
heinie	9	25	1266	2	heinie
henna	8	44	1404	2	he_nna
herdic	12	31	1230	2	herdic
herein	9	37	1779	2	herein
herma	10	53	1888	2	her_ma
hermai	11	89	1286	2	hermai
hermit	11	5	1944	2	hermit
hern	7	61	3489	2	hern__
herniate	11	4	811	2	herniate
herns	8	48	2558	2	hern_s
heroic	11	35	1692	2	heroic
heroin	9	44	2059	2	heroin
kerria	10	33	991	2	kerria
pennia	8	44	1297	2	pennia
pereia	8	52	1798	2	pereia
pernio	8	5	1314	2	pernio
tenia	5	53	2448	2	te_nia
terbia	8	3	1115	2	terbia
vernix	16	3	663	2	vernix
xenia	12	48	1477	2	xe_nia
aecia	7	38	1928	3	ae_cia
aeonian	7	3	835	3	aeonian
aeonic	8	35	1704	3	aeonic
aerial	6	46	2571	3	aer_ial
aerie	5	46	3460	3	aer_ie
aerobia	9	3	946	3	aerobia
agria	6	55	1714	3	agr_ia
amnia	7	59	1864	3	_amnia
anergia	8	4	736	3	anergia
arena	5	53	2381	3	aren_a
aria	4	62	4542	3	_ar_ia
arnica	8	3	1044	3	_arnica
atonia	6	38	1651	3	atonia
atria	5	60	2234	3	atr_ia
beanie	8	36	1859	3	beanie
begonia	10	4	721	3	begonia
benni	7	47	1536	3	benni_
bennis	8	43	1480	3	bennis
berlin	8	31	1637	3	berlin
bertha	11	42	917	3	bertha
biennia	9	9	493	3	biennia
burnie	8	37	1541	3	burnie
byrnie	11	34	857	3	byrnie
cardia	9	9	1637	3	cardia
carina	8	43	2532	3	carina
carnie	8	44	2109	3	carnie
cerci	9	37	1639	3	cerci_
cercis	10	46	1449	3	cercis
cerias	8	33	2198	3	cer_ias
ceric	9	40	2309	3	cer_ic
cering	9	45	2253	3	cering
cervid	12	3	932	3	cervid
cervix	18	6	516	3	cervix
chervil	15	3	495	3	chervil
coria	7	58	2832	3	cor_ia
cornea	8	40	1892	3	cornea
cornua	8	54	1190	3	cornua
crania	8	24	1843	3	crania
curia	7	45	2377	3	cur_ia
deni	5	69	2939	3	de_ni_
denial	7	47	2051	3	de_nial
denim	8	55	1884	3	de_nim
derail	7	42	1881	3	derail
derma	8	49	1851	3	der_ma
dermic	11	45	1191	3	dermic
dermis	9	47	1716	3	dermis
dernier	8	30	1194	3	dernier
derris	7	36	1527	3	derris
dharna	10	5	526	3	dharn_a
dhurna	10	4	356	3	dhurn_a
eerie	5	52	2853	3	eer_ie
entia	5	3	1820	3	_entia
eonian	6	3	1183	3	_eonian
era	3	57	4150	3	_er__a
erica	7	3	1654	3	_erica
ern	3	57	3836	3	_ern__
erne	4	67	2743	3	_ern_e
ernes	5	52	2481	3	_ernes
erns	4	54	2823	3	_ern_s
ervil	8	3	1030	3	_ervil
etna	4	64	1526	3	_etn_a
farina	9	46	1823	3	farina
feriae	9	56	1860	3	fer_iae
ferial	9	46	2125	3	fer_ial
ferias	9	50	2039	3	fer_ias
ferine	9	64	2258	3	ferine
ferlie	9	28	1405	3	ferlie
fermi	10	39	1416	3	fermi_
fermis	11	43	1350	3	fermis
fern	7	61	2932	3	fern__
fernier	10	31	1082	3	fernier
ferns	8	52	2008	3	fern_s
ferny	11	58	1618	3	fern_y
ferric	11	3	999	3	ferric
ferula	9	30	1117	3	ferula
fervid	13	3	751	3	fervid
fornix	16	3	603	3	fornix
frena	8	59	1527	3	fren_a
garni	6	3	1570	3	garni_
genial	7	49	1761	3	ge_nial
genic	8	51	1939	3	ge_nic
genie	6	61	2492	3	ge_nie
genii	6	45	1417	3	ge_nii
genip	8	44	1520	3	ge_nip
genoa	6	43	1582	3	ge_noa
genua	6	46	1415	3	ge_nua
geranial	9	4	928	3	geranial
gerbil	9	3	834	3	gerbil
germina	10	3	850	3	germina
gherkin	15	4	404	3	gherkin
gonia	6	41	1753	3	_gonia
haniwa	12	3	674	3	h_aniwa
hansa	8	54	1678	3	h_ansa
haring	10	42	3300	3	haring
harmin	11	31	1739	3	harmin
harpin	11	36	1438	3	harpin
hearing	11	33	2416	3	hearing
hectic	13	23	1152	3	hectic
hedonic	13	3	904	3	hedonic
hegira	10	3	652	3	hegira
heil	7	63	2893	3	he__il
heinies	10	25	1454	3	heinies
heir	7	75	2380	3	he__ir
heiring	11	33	1290	3	heiring
hejira	16	4	480	3	hejira
heliac	11	10	1089	3	he_liac
helio	8	53	2119	3	he_lio
helix	15	44	1301	3	he_lix
hemic	12	57	1862	3	he_mic
hemin	10	36	2093	3	he_min
hemins	11	34	1757	3	hemins
hemoid	12	3	1351	3	hemoid
hempie	13	24	1056	3	hempie
hen	6	75	5527	3	he_n__
henbit	11	14	1200	3	henbit
hence	10	49	2004	3	he_nce
henge	9	48	1983	3	he_nge
hennas	9	42	1180	3	hennas
hennish	13	3	686	3	hennish
henries	10	27	1828	3	henries
henry	11	40	1447	3	he_nry
henrys	12	36	610	3	henrys
hens	7	56	4257	3	he_n_s
hent	7	66	5638	3	he_n_t
hents	8	73	3074	3	he_nts
her	6	65	4781	3	her___
herald	10	3	1134	3	herald
herb	9	47	3096	3	her__b
herbal	11	25	1349	3	herbal
herbaria	13	4	609	3	herbaria
herbed	12	35	1345	3	herbed
herbier	12	3	959	3	herbier
herbs	10	55	2050	3	her_bs
herby	13	47	1531	3	her_by
herd	8	49	3306	3	her__d
herded	11	42	1564	3	herded
herder	10	45	1646	3	herder
herdics	13	24	952	3	herdics
herding	12	29	1512	3	herding
herdman	13	23	842	3	herdman
herds	9	64	2468	3	her_ds
here	7	64	4710	3	her__e
hereat	9	35	2741	3	hereat
hereby	14	46	833	3	hereby
hereof	12	32	1237	3	hereof
hereon	9	39	1436	3	hereon
heres	8	62	4590	3	her_es
heresy	12	50	1123	3	heresy
heretic	12	3	1483	3	heretic
hereto	9	3	1369	3	hereto
heriot	9	4	2234	3	heriot
herl	7	58	3455	3	her__l
herls	8	52	2643	3	her_ls
herm	9	56	3615	3	her__m
hermae	11	53	1447	3	hermae
hermits	12	3	1214	3	hermits
herms	10	56	2643	3	her_ms
herniated	13	4	601	3	hernia~~ted~~
herniates	12	4	733	3	hernia~~tes~~
hero	7	46	3578	3	her__o
heroes	9	49	2382	3	heroes
heroical	13	4	1002	3	heroical
heroics	12	29	1200	3	heroics
heroine	10	35	1748	3	heroine
heroins	10	35	1801	3	heroins
heroism	12	3	1101	3	heroism
heroize	19	32	1096	3	heroize
heron	8	50	2550	3	her_on
heronry	13	4	604	3	heronry
herons	9	48	2054	3	herons
heros	8	49	3086	3	her_os
herpes	11	55	1732	3	herpes
herried	11	35	1445	3	herried
herries	10	40	2507	3	herries
herring	11	36	1588	3	herring
herry	11	49	2247	3	her_ry
hers	7	58	4487	3	her__s
hertz	17	49	1904	3	her_tz
hessian	10	3	585	3	hessian
hetaira	10	4	590	3	hetaira
hewing	13	45	1424	3	hewing
hewn	10	67	1985	3	hewn__
hexing	17	42	1051	3	hexing
hiring	10	44	2160	3	hiring
honda	9	4	1498	3	h_onda
hora	7	61	3656	3	hor__a
horn	7	67	3561	3	horn__
horned	10	57	1870	3	horned
hornet	9	49	2643	3	hornet
hornier	10	30	1246	3	hornier
hornily	13	3	828	3	hornily
horning	11	30	1500	3	horning
hornist	10	23	1482	3	hornist
hornito	10	4	707	3	hornito
horns	8	61	2533	3	horn_s
horny	11	56	1962	3	horn_y
horrid	10	3	1156	3	horrid
hryvnia	16	4	164	3	hryvnia
hydria	13	22	790	3	hydria
hyena	11	8	1025	3	hyen_a
hyenic	14	3	872	3	hyenic
hymenia	15	4	639	3	hymenia
hypnic	16	3	726	3	hypnic
inertia	7	4	1020	3	inertia
inia	4	50	2470	3	__inia
irenic	8	3	1110	3	irenic
jarina	13	40	1406	3	jarina
jerboa	15	3	563	3	jerboa
jerid	13	23	1642	3	jer_id
jerkin	17	25	811	3	jerkin
jerrid	14	25	914	3	jerrid
kermis	12	40	1239	3	kermis
kern	8	53	2621	3	kern__
kerne	9	47	1822	3	kern_e
kerned	11	41	1293	3	kerned
kernel	10	40	1059	3	kernel
kernes	10	47	1753	3	kernes
kerning	12	40	1089	3	kerning
kernite	11	5	947	3	kernite
kerns	9	47	1956	3	kern_s
kerrias	11	28	951	3	kerrias
lenis	5	63	2686	3	le_nis
mania	7	56	3415	3	_mania
maria	7	50	3288	3	mar_ia
marina	8	46	2341	3	marina
meanie	8	37	1839	3	meanie
media	8	47	2171	3	me_dia
medina	9	41	1409	3	medina
meinie	8	26	1452	3	meinie
menial	8	42	2303	3	me_nial
mensa	7	53	1867	3	me_nsa
menta	7	44	2442	3	me_nta
merino	8	3	1509	3	merino
merit	7	3	3918	3	mer_it
merlin	8	39	1668	3	merlin
meropia	11	4	961	3	meropia
nereid	7	3	1292	3	nereid
nereis	6	3	1534	3	nereis
noria	5	57	2218	3	nor_ia
ornis	5	46	1677	3	_ornis
penial	8	41	2089	3	pe_nial
penis	7	51	2932	3	pe_nis
penna	7	45	2020	3	pe_nna
penni	7	46	1790	3	penni_
pennis	8	43	1574	3	pennis
perdie	9	47	1851	3	perdie
perea	7	50	2644	3	per_ea
peri	6	56	3697	3	per_i_
peridia	10	3	1236	3	peridia
peril	7	54	2595	3	per_il
perinea	9	3	1303	3	perinea
peris	7	55	3707	3	per_is
permian	11	26	1228	3	permian
permit	10	3	2168	3	permit
pernod	9	3	1045	3	pernod
petunia	9	6	680	3	petunia
phelonia	13	4	704	3	phelonia
phenix	18	3	713	3	phe_nix
phrenic	14	3	877	3	phrenic
raia	4	66	3838	3	__raia
realia	6	3	1459	3	realia
redia	6	55	2448	3	re_dia
regina	7	53	1714	3	regina
regna	6	46	1481	3	regn_a
reknit	10	3	1253	3	reknit
renig	6	45	1891	3	re_nig
renin	5	48	3003	3	re_nin
rennin	6	39	1403	3	rennin
rerig	6	40	1848	3	rer_ig
retia	5	53	2611	3	re_tia
retina	6	50	2338	3	retina
ria	3	67	4550	3	__r_ia
segni	6	37	1248	3	segni_
semina	8	9	1557	3	semina
senna	5	46	1798	3	se_nna
sennit	6	31	1792	3	sennit
sensa	5	41	1747	3	se_nsa
sepia	7	53	1867	3	se_pia
sera	4	61	4139	3	ser__a
serai	5	68	3016	3	serai_
serail	6	42	2267	3	serail
serais	6	43	2613	3	serais
serein	6	33	1846	3	serein
serial	6	46	2586	3	ser_ial
serif	8	41	3213	3	ser_if
serin	5	54	3444	3	ser_in
serine	6	54	3267	3	serine
sering	7	47	3181	3	sering
seringa	8	33	1074	3	seringa
serins	6	40	2967	3	serins
serosa	6	3	1302	3	serosa
sharia	9	31	1673	3	shar_ia
sheenie	10	15	949	3	sheenie
sherif	12	29	1524	3	sher_if
sherpa	11	3	809	3	sher_pa
sherris	10	16	880	3	sherris
shortia	10	4	819	3	shortia
sterna	6	37	1276	3	stern_a
sthenia	10	5	850	3	sthe_nia
stria	5	57	2321	3	str_ia
taenia	6	3	1319	3	taenia
tarsia	6	55	1427	3	tarsia
telia	5	58	2114	3	te_lia
teniae	6	45	1735	3	te_niae
tenias	6	47	2007	3	te_nias
tennis	6	40	1530	3	tennis
terai	5	35	2548	3	terai_
terais	6	40	2351	3	terais
terbias	9	3	1074	3	terbias
terbic	10	4	1096	3	terbic
terga	6	33	1564	3	ter_ga
tern	4	61	3480	3	tern__
terne	5	64	2615	3	tern_e
ternes	6	54	2290	3	ternes
ternion	7	3	949	3	ternion
terns	5	52	2687	3	tern_s
terra	5	44	1966	3	ter_ra
territ	6	34	2137	3	territ
tertial	7	3	1386	3	tertial
tertian	7	5	1119	3	tertian
therein	10	23	1035	3	therein
theriac	12	3	914	3	ther_iac
therian	10	3	1129	3	ther_ian
thermic	14	3	933	3	thermic
thermit	12	3	1201	3	thermit
theroid	11	3	1340	3	theroid
thoria	9	30	1289	3	thor_ia
turnip	8	3	659	3	turnip
urania	6	25	1612	3	urania
urbia	7	3	1114	3	_urbia
uredia	7	36	1006	3	uredia
uremia	8	29	1089	3	uremia
varia	8	58	2420	3	var_ia
varna	8	45	1617	3	varn_a
veena	8	19	1232	3	veen_a
vena	7	61	2629	3	ve_n_a
venial	9	42	1828	3	ve_nial
venin	8	51	1866	3	ve_nin
vera	7	68	2884	3	ver__a
veranda	11	5	632	3	veranda
verbid	12	23	1131	3	verbid
verdin	10	31	1302	3	verdin
vermian	12	32	971	3	vermian
vermin	11	34	1452	3	vermin
vermis	11	42	1496	3	vermis
vernal	9	35	1421	3	vernal
vernier	10	27	1127	3	vernier
veronica	13	4	673	3	veronica
weenie	9	26	1202	3	weenie
wherein	13	21	659	3	wherein
xenial	13	34	1490	3	xe_nial
xenias	13	37	1297	3	xe_nias
xenic	14	41	1464	3	xe_nic
xeric	14	43	1566	3	xer_ic
yenta	8	39	1704	3	ye_nta
yerba	10	10	1076	3	yer_ba
zinnia	15	3	601	3	zinnia

Search took 7 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	383	5.796	19447.2
3	Display Results	383	383	0.126	3039.7
	(SQL Overall)	178691	383	6.312	28309.7