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

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

486 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
sterna	6	37	1276	(None)
stern	5	53	1912	1	stern_
sternal	7	34	1191	1	sternal
sterns	6	46	1676	1	sterns
asteria	7	3	1618	2	asteria
astern	6	48	1581	2	astern_
asternal	8	5	832	2	asternal
cisterna	10	37	636	2	cisterna
eternal	7	29	1089	2	eternal
eterne	6	3	1172	2	eterne
scena	7	48	1578	2	sce_na
senna	5	46	1798	2	s_enna
sera	4	61	4139	2	s_er_a
sherpa	11	3	809	2	sherpa
sienna	6	4	719	2	sienna
sierra	6	3	731	2	sierra
stein	5	46	2054	2	stein_
steins	6	48	1834	2	steins
stela	5	40	1904	2	ste_la
stella	6	36	1297	2	stella
stemma	10	32	813	2	stemma
steno	5	47	1686	2	ste_no
stent	5	56	3451	2	ste_nt
stere	5	53	2854	2	ster_e
stereo	6	53	1791	2	stereo
steres	6	39	2953	2	steres
steric	8	3	1706	2	steric
sterner	7	4	1191	2	sterner
sternly	10	3	785	2	sternly
sternum	9	4	773	2	sternum
sternway	14	4	315	2	sternway
sterol	6	6	1333	2	sterol
stria	5	57	2321	2	st_ria
terga	6	33	1564	2	_terga
tern	4	61	3480	2	_tern_
terne	5	64	2615	2	_terne
terns	5	52	2687	2	_terns
terra	5	44	1966	2	_terra
amarna	8	3	979	3	amarna
antenna	7	4	638	3	antenna
apteria	9	3	1291	3	apteria
arena	5	53	2381	3	are_na
aster	5	54	3489	3	aster__
asterias	8	3	1701	3	asterias
asters	6	56	3160	3	aster_s
atria	5	60	2234	3	at_ria
catena	8	3	1248	3	cate_na
cateran	9	3	1377	3	cateran
ceria	7	51	2535	3	_ceria
cistern	9	33	1070	3	cistern_
cisternae	11	26	509	3	cisternae
cisternal	11	32	574	3	cisternal
cisterns	10	36	957	3	cisterns
derma	8	49	1851	3	_derma
dharna	10	5	526	3	dharna
dhurna	10	4	356	3	dhurna
duenna	7	3	459	3	duenna
eastern	7	44	1253	3	eastern_
entera	6	42	1683	3	enter_a
episterna	11	4	337	3	~~epi~~sterna
era	3	57	4150	3	__er_a
ern	3	57	3835	3	__ern_
erne	4	67	2742	3	__erne
erns	4	54	2822	3	__erns
ester	5	47	2771	3	ester__
esters	6	46	2773	3	ester_s
eternals	8	23	895	3	eternals
etna	4	64	1526	3	__etna
extern	13	4	847	3	extern_
external	15	7	722	3	external
externe	14	3	857	3	externe
externs	14	3	823	3	externs
faena	8	50	1420	3	fae_na
feria	8	59	2271	3	_feria
fern	7	61	2932	3	_fern_
ferns	8	52	2008	3	_ferns
ferny	11	58	1618	3	_ferny
frena	8	59	1527	3	fre_na
henna	8	44	1404	3	_henna
herma	10	53	1888	3	_herma
hern	7	61	3489	3	_hern_
hernia	9	3	1229	3	_hernia
herns	8	48	2558	3	_herns
hyena	11	8	1025	3	hye_na
hysteria	14	4	739	3	hysteria
intern	6	40	1654	3	intern_
internal	8	4	1408	3	internal
interne	7	32	1814	3	interne
interns	7	31	1677	3	interns
iterant	7	3	1778	3	iterant
iterum	8	3	790	3	iterum
kern	8	53	2621	3	_kern_
kerne	9	47	1821	3	_kerne
kerns	9	47	1956	3	_kerns
lierne	6	3	802	3	lierne
listeria	8	3	943	3	listeria
maternal	10	4	780	3	maternal
opera	7	3	1357	3	oper_a
osetra	6	6	742	3	osetr_a
osteoma	9	4	543	3	osteoma
pastern	9	44	1506	3	pastern_
pasterns	10	41	1262	3	pasterns
paternal	10	3	833	3	paternal
penna	7	45	2020	3	_penna
perea	7	50	2644	3	_perea
plena	7	58	1639	3	ple_na
postern	9	36	1561	3	postern_
posterns	10	27	1372	3	posterns
presterna	11	4	526	3	~~pre~~sterna
pterin	8	10	1415	3	pterin
pterins	9	8	1299	3	pterins
pteryla	12	4	330	3	pteryla
quern	14	36	1040	3	quern_
querns	15	30	794	3	querns
regna	6	46	1481	3	_regna
reran	5	73	2910	3	_reran
retina	6	50	2338	3	retina
sabra	7	53	1785	3	sabr_a
sacra	7	45	1699	3	sacr_a
salina	6	42	2112	3	salina
saltern	7	40	1065	3	saltern_
salterns	8	38	890	3	salterns
santera	7	3	1130	3	santer_a
santeria	8	3	1165	3	santeria
saran	5	37	3030	3	s_aran
satara	6	3	1553	3	satar_a
sateen	6	38	1501	3	sateen_
sateens	7	37	1075	3	sateens
sauna	5	41	1755	3	s_auna
sauterne	8	4	625	3	sauterne
scenas	8	41	1470	3	sce_nas
scend	8	55	1629	3	sce_nd
scene	7	72	2057	3	sce_ne
scent	7	58	3162	3	sce_nt
sclera	8	3	888	3	scler_a
scoria	8	5	1350	3	scoria
scorn	7	58	1744	3	scorn_
scorns	8	57	1302	3	scorns
sea	3	61	6129	3	s_e__a
secern	8	10	1022	3	secern_
secerns	9	8	773	3	secerns
sedan	6	56	2042	3	s_edan
seeing	7	42	2214	3	seeing
seen	4	69	4312	3	s_een_
seer	4	55	4704	3	seer__
seers	5	51	3638	3	seer_s
segni	6	37	1248	3	s_egni
segno	6	48	1474	3	s_egno
seine	5	57	3287	3	s_eine
selva	8	30	1427	3	s_elva
semina	8	9	1556	3	semina
sen	3	60	5852	3	s_e_n_
send	5	52	3729	3	s_e_nd
sene	4	68	4805	3	s_e_ne
sennas	6	42	1423	3	s_ennas
sensa	5	41	1747	3	s_ensa
sent	4	69	6301	3	s_e_nt
sepia	7	53	1867	3	s_epia
septa	7	55	1808	3	s_epta
ser	3	67	5240	3	s_er__
serac	7	59	2520	3	s_erac
serai	5	68	3016	3	s_erai
seral	5	63	3638	3	s_eral
serdab	9	3	783	3	s_erdab
sere	4	61	5347	3	s_er_e
sered	6	57	3729	3	s_ered
serene	6	35	2235	3	s_erene
serer	5	59	3550	3	s_erer
seres	5	54	4889	3	s_eres
serf	7	63	4011	3	s_er_f
serfs	8	49	2201	3	s_erfs
serge	6	47	2746	3	s_erge
serial	6	46	2586	3	s_erial
serif	8	41	3213	3	s_erif
serin	5	54	3444	3	s_erin
serine	6	54	3267	3	s_erine
sering	7	47	3181	3	s_ering
seringa	8	33	1074	3	s_eringa
serins	6	40	2967	3	s_erins
serosa	6	3	1302	3	s_erosa
serow	8	67	2044	3	s_erow
serry	8	48	2412	3	s_erry
sers	4	57	4665	3	s_er_s
serum	7	52	2347	3	s_erum
serval	9	39	1341	3	s_erval
serve	8	54	2596	3	s_erve
servo	8	45	1668	3	s_ervo
seta	4	56	3731	3	s_e_ta
seton	5	52	2354	3	seton_
setons	6	46	2017	3	setons
sewan	8	59	2129	3	s_ewan
sewn	7	61	2433	3	s_ewn_
sharia	9	31	1673	3	sharia
sharn	8	48	2370	3	sharn_
sharns	9	55	1698	3	sharns
sharny	12	47	1183	3	sharny
shea	7	60	3157	3	she__a
sheen	8	50	2331	3	sheen_
sheens	9	51	1699	3	sheens
sheeny	12	49	1219	3	sheeny
sheila	9	6	984	3	sheila
shelta	9	31	1179	3	shelta
shend	9	47	1997	3	she_nd
shent	8	59	3350	3	she_nt
sherd	9	63	2115	3	sher_d
sherds	10	56	1472	3	sherds
sherif	12	29	1524	3	sherif
sherpas	12	3	809	3	sherpas
sherry	12	45	1041	3	sherry
shewn	11	57	1570	3	shewn_
shoran	9	40	1604	3	shoran
shorn	8	57	2218	3	shorn_
siennas	7	3	612	3	siennas
sierran	7	3	719	3	sierran
sierras	7	3	786	3	sierras
siesta	6	3	950	3	siesta
signa	6	61	1470	3	s_igna
siren	5	45	2582	3	siren_
sirens	6	53	1815	3	sirens
sirra	5	44	1632	3	s_irra
skean	9	44	1562	3	skean_
skeane	10	46	1137	3	skeane
skeans	10	45	1291	3	skeans
skeen	9	48	1740	3	skeen_
skeens	10	39	1291	3	skeens
skein	9	48	1441	3	skein_
skeins	10	39	1190	3	skeins
skene	9	61	1812	3	ske_ne
skerry	13	35	610	3	skerry
smegma	11	3	411	3	smegma
smerk	11	54	1272	3	smer_k
smerks	12	44	971	3	smerks
sora	4	57	4691	3	s_or_a
sorn	4	66	4106	3	s_orn_
sorns	5	50	2842	3	s_orns
sorta	5	71	2541	3	s_orta
sovran	9	3	715	3	sovran
spean	7	46	2051	3	spean_
speans	8	54	1714	3	speans
spend	8	56	1933	3	spe_nd
spent	7	55	3283	3	spe_nt
sperm	9	32	1601	3	sper_m
sperms	10	25	1260	3	sperms
spirea	8	40	1563	3	spirea
sprent	8	45	2238	3	sprent
spurn	7	48	1545	3	spurn_
spurns	8	48	1138	3	spurns
stadia	7	3	1214	3	stadia
stain	5	57	2794	3	stain_
stains	6	49	2365	3	stains
stamina	9	3	1079	3	stamina
stand	6	59	2328	3	st_and
stane	5	59	3300	3	st_ane
stang	6	64	2468	3	st_ang
stank	9	58	2330	3	st_ank
stanza	15	3	707	3	stanza
star	4	80	3776	3	star__
starch	11	30	1320	3	starch
stare	5	44	4026	3	star_e
stared	7	54	2987	3	stared
starer	6	40	2736	3	starer
stares	6	60	3875	3	stares
staring	8	45	2705	3	staring
stark	9	54	2562	3	star_k
starry	9	49	1167	3	starry
stars	5	58	3657	3	star_s
start	5	56	4231	3	star_t
starts	6	54	2312	3	starts
starve	9	46	1374	3	starve
stead	6	55	2027	3	ste_ad
steads	7	41	1622	3	steads
steady	10	35	1020	3	steady
steak	9	52	1980	3	ste_ak
steaks	10	44	1585	3	steaks
steal	5	61	2547	3	ste_al
steals	6	40	2006	3	steals
steam	7	63	2293	3	ste_am
steams	8	49	1690	3	steams
steamy	11	51	1237	3	steamy
stearic	9	3	942	3	stearic
stearin	7	3	1200	3	stearin
stearine	8	3	1190	3	stearine
stearins	8	3	1214	3	stearins
steed	6	60	2494	3	ste_ed
steeds	7	38	1488	3	steeds
steek	9	54	1800	3	ste_ek
steeks	10	36	1370	3	steeks
steel	5	57	2199	3	ste_el
steels	6	41	1798	3	steels
steely	9	36	1257	3	steely
steep	7	60	2070	3	ste_ep
steeps	8	52	1519	3	steeps
steer	5	54	2386	3	ste_er
steered	8	36	1525	3	steered
steerer	7	31	1363	3	steerer
steering	9	39	1679	3	steering
steers	6	38	2098	3	steers
steeve	9	37	1090	3	steeve
stelae	6	37	1648	3	stelae
stelai	6	39	1256	3	stelai
stelar	6	40	1386	3	stelar
stele	5	50	2684	3	ste_le
stelene	7	3	1025	3	stelene
steles	6	37	2566	3	steles
stelic	8	3	1308	3	stelic
stellar	7	26	1042	3	stellar
stellas	7	28	1304	3	stellas
stem	6	106	2825	3	ste__m
stemmas	11	25	697	3	stemmas
stemmy	13	41	703	3	stemmy
stems	7	52	1995	3	ste_ms
stench	11	41	1116	3	stench
stengah	11	4	456	3	stengah
stenos	6	39	1577	3	stenos
stents	6	50	1945	3	stents
step	6	71	2629	3	ste__p
steppe	10	31	987	3	steppe
steps	7	66	1988	3	ste_ps
stereos	7	43	1497	3	stereos
sterical	10	3	1125	3	sterical
sterigma	11	4	411	3	sterigma
sterile	7	3	1660	3	sterile
sterlet	7	13	1847	3	sterlet
sterling	9	36	1555	3	sterling
sternest	8	3	1443	3	sternest
sternite	8	3	1054	3	sternite
sternson	8	4	484	3	sternson
sternums	10	4	578	3	sternums
sternward	13	4	311	3	sternward
sternways	15	4	259	3	sternways
steroid	8	13	1486	3	steroid
sterols	7	3	1344	3	sterols
stertor	7	3	1008	3	stertor
stet	4	59	4732	3	ste__t
stets	5	54	2391	3	ste_ts
stew	7	75	2546	3	ste__w
stewed	10	48	1424	3	stewed
stewing	11	34	1249	3	stewing
stewpan	12	3	419	3	stewpan
stews	8	55	1914	3	ste_ws
stewy	11	61	1206	3	ste_wy
stey	7	62	2441	3	ste__y
sthenia	10	5	850	3	sthenia
stigma	9	22	676	3	stigma
sting	6	53	3024	3	st_ing
stink	9	51	2250	3	st_ink
stint	5	70	3766	3	st_int
stir	4	57	2325	3	stir__
stirk	9	57	1741	3	stir_k
stirks	10	49	1424	3	stirks
stirp	7	68	1550	3	stir_p
stirps	8	50	1182	3	stirps
stirs	5	59	2162	3	stir_s
stoa	4	54	2591	3	st__oa
stoma	7	59	1827	3	st_oma
stone	5	54	3118	3	st_one
stony	8	58	1864	3	st_ony
storax	13	8	978	3	storax
store	5	63	3381	3	stor_e
stored	7	55	2421	3	stored
storer	6	47	2167	3	storer
stores	6	55	3366	3	stores
storey	9	52	1761	3	storey
storing	8	39	2112	3	storing
stork	9	68	1969	3	stor_k
storks	10	61	1595	3	storks
storm	7	65	2039	3	stor_m
storms	8	58	1463	3	storms
stormy	11	55	1073	3	stormy
story	8	67	2303	3	stor_y
stound	7	39	990	3	stound
strand	7	45	1482	3	strand
strang	7	57	1831	3	strang
strap	7	79	2526	3	st_rap
strata	6	36	1628	3	strata
straw	8	133	2129	3	st_raw
stray	8	85	2557	3	st_ray
streak	10	46	1362	3	streak
stream	8	47	1728	3	stream
streek	10	41	1141	3	streek
streel	6	42	1402	3	streel
street	6	41	2577	3	street
strep	7	71	2085	3	st_rep
streps	8	62	1806	3	streps
stress	6	66	1667	3	stress
stretta	7	3	729	3	stretta
strew	8	92	2065	3	st_rew
strewn	9	67	1000	3	strewn
strews	9	68	1709	3	strews
striae	6	54	2227	3	st_riae
string	7	53	2756	3	string
strip	7	75	2434	3	st_rip
stroma	8	43	1307	3	stroma
strong	7	49	1488	3	strong
strop	7	74	2224	3	st_rop
strow	8	89	2057	3	st_row
stroy	8	77	2039	3	st_roy
strum	7	56	1945	3	st_rum
struma	8	43	1327	3	struma
strung	7	52	1302	3	strung
strunt	6	49	1891	3	strunt
strut	5	60	3073	3	st_rut
stun	4	56	2345	3	st_un_
stung	6	54	1715	3	st_ung
stunk	9	46	1629	3	st_unk
stuns	5	47	1949	3	st_uns
stunt	5	53	2817	3	st_unt
stupa	7	41	1231	3	st_upa
sturdy	10	3	704	3	sturdy
sturt	5	60	2896	3	stur_t
sturts	6	39	1514	3	sturts
stying	10	54	1457	3	stying
styrax	16	7	524	3	styrax
styrene	10	11	669	3	styrene
suer	4	53	3403	3	suer__
suers	5	51	2848	3	suer_s
sunna	5	50	1606	3	s_unna
supernal	10	3	987	3	supernal
supra	7	36	1425	3	supr_a
sura	4	57	4029	3	s_ur_a
surra	5	55	2134	3	s_urra
sutra	5	42	1793	3	sutr_a
sweeny	12	35	884	3	sweeny
swerve	12	5	629	3	swerve
sworn	8	61	1530	3	sworn_
syren	8	52	1674	3	syren_
syrens	9	49	1199	3	syrens
tarn	4	68	4272	3	_tarn_
tarnal	6	37	1650	3	_tarnal
tarns	5	64	3395	3	_tarns
taverna	10	28	538	3	taverna
tea	3	73	5332	3	_te__a
tecta	7	42	1552	3	_tecta
teen	4	59	3820	3	_teen_
teens	5	62	2748	3	_teens
teeny	8	54	1788	3	_teeny
tegua	6	10	956	3	_tegua
teind	6	2	1361	3	_teind
tela	4	55	3297	3	_te_la
telia	5	58	2114	3	_telia
ten	3	58	5611	3	_te_n_
tend	5	64	3377	3	_te_nd
tenia	5	53	2448	3	_tenia
tens	4	56	4741	3	_te_ns
tent	4	61	5986	3	_te_nt
tepa	6	60	2168	3	_te_pa
terai	5	35	2548	3	_terai
terbia	8	3	1115	3	_terbia
terce	7	57	2184	3	_terce
tergal	7	29	1283	3	_tergal
term	6	62	3315	3	_ter_m
terms	7	55	2347	3	_terms
ternary	10	3	834	3	_ternary
ternate	7	4	1548	3	_ternate
ternes	6	54	2290	3	_ternes
terrae	6	29	1521	3	_terrae
terras	6	35	1697	3	_terras
terry	8	47	2187	3	_terry
terse	5	50	2682	3	_terse
tesla	5	56	1260	3	_tesla
testa	5	48	2204	3	_testa
tetra	5	34	1795	3	_tetra
tora	4	75	4599	3	_tor_a
torn	4	60	4425	3	_torn_
torta	5	59	2535	3	_torta
trend	6	48	1745	3	_trend
trona	5	41	1895	3	_trona
tsarina	7	3	665	3	tsarina
tuna	4	51	2784	3	_t_una
turn	4	63	3038	3	_turn_
turns	5	56	2323	3	_turns
uteri	5	10	1298	3	uter_i
uterine	7	3	1519	3	uterine
uterus	6	3	920	3	uterus
varna	8	45	1617	3	_varna
veena	8	19	1232	3	_veena
vena	7	61	2629	3	_ve_na
vera	7	68	2884	3	_ver_a
vernal	9	35	1421	3	_vernal
veteran	10	3	935	3	veteran
western	10	29	1109	3	western_
westerns	11	32	896	3	westerns
wisteria	11	4	775	3	wisteria
yerba	10	10	1076	3	_yerba
yestern	10	33	863	3	yestern_
yttria	9	5	480	3	yttria

Search took 8 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.266	671770.7
2	DLD Change Limit	112716	486	6.826	16512.7
3	Display Results	486	486	0.143	3398.6
	(SQL Overall)	178691	486	7.235	24698.1