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

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

420 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
sterol	6	6	1333	(None)
sterols	7	3	1344	1	sterols
nerol	5	10	1781	2	_nerol
petrol	8	27	1406	2	petrol
safrol	9	3	728	2	safrol
seral	5	63	3638	2	s_eral
serow	8	67	2044	2	s_erow
sheol	8	43	1837	2	she_ol
stanol	6	3	1072	2	stanol
steal	5	61	2547	2	ste_al
steel	5	57	2199	2	ste_el
steno	5	47	1686	2	steno_
stenos	6	39	1577	2	stenos
stere	5	53	2854	2	ster_e
stereo	6	53	1791	2	stereo
stereos	7	43	1497	2	stereos
steres	6	39	2953	2	steres
steric	8	3	1706	2	steric
sterile	7	3	1660	2	sterile
stern	5	53	1912	2	ster_n
sterna	6	37	1276	2	sterna
sternal	7	34	1191	2	sternal
sternly	10	3	785	2	sternly
sterns	6	46	1676	2	sterns
steroid	8	13	1486	2	steroid
stertor	7	3	1009	2	stertor
stool	5	56	1989	2	st_ool
streel	6	42	1402	2	streel
stroll	6	3	1160	2	st_roll
strop	7	74	2224	2	st_rop
strow	8	89	2057	2	st_row
stroy	8	77	2039	2	st_roy
acerola	9	4	782	3	acerola
aero	4	54	3534	3	_aero_
apteral	9	3	1152	3	apteral
aster	5	54	3489	3	aster__
asteria	7	3	1618	3	asteria
astern	6	48	1581	3	aster_n
asternal	8	5	832	3	asternal
asteroid	9	5	1119	3	asteroid
asters	6	56	3160	3	aster_s
astral	6	69	1928	3	ast_ral
beryl	10	12	1167	3	_beryl
carol	7	51	2861	3	_carol
ceorl	7	4	1092	3	_ceorl
cero	6	63	2945	3	_cero_
ceros	7	47	2607	3	_ceros
cresol	8	3	1021	3	cresol
emerod	9	13	921	3	emerod
enol	4	58	2382	3	__enol
enrol	5	10	1428	3	_enrol
enteral	7	35	1644	3	enteral
enteron	7	3	1334	3	enteron
eros	4	52	3845	3	__eros
ester	5	47	2771	3	ester__
esters	6	46	2773	3	ester_s
estral	6	47	1651	3	est_ral
estriol	7	4	755	3	estriol
eternal	7	29	1089	3	eternal
eterne	6	3	1172	3	eterne
feral	8	54	2465	3	_feral
herl	7	58	3455	3	_her_l
hero	7	46	3578	3	_hero_
heron	8	50	2550	3	_heron
heros	8	49	3086	3	_heros
hetero	9	3	1263	3	hetero_
heteros	10	3	1268	3	heteros
iterum	8	3	790	3	iterum
ketol	9	54	1400	3	_ketol
lateral	7	3	1357	3	lateral
literal	7	6	1327	3	literal
merl	6	58	3097	3	_mer_l
metol	7	59	1781	3	_metol
metro	7	47	1880	3	metro_
metros	8	42	1780	3	metros
neroli	6	11	1115	3	_neroli
nerols	6	9	1488	3	_nerols
operon	8	8	1177	3	operon
osteal	6	3	1296	3	oste_al
parol	7	48	2627	3	_parol
patrol	8	32	1302	3	patrol
peril	7	54	2595	3	_peril
petrel	8	31	1153	3	petrel
petrols	9	29	1308	3	petrols
phenol	11	4	925	3	phenol
pterin	8	10	1415	3	pterin
pteryla	12	4	330	3	pteryla
pyrrol	11	3	627	3	pyrrol
reroll	6	4	1268	3	_reroll
retool	6	39	1448	3	retool
retral	6	44	1974	3	retral
retro	5	50	2095	3	retro_
retros	6	38	2019	3	retros
sacral	8	34	1441	3	sacral
safrole	10	3	725	3	safrole
safrols	10	3	686	3	safrols
salol	5	52	2214	3	s_alol
santero	7	3	1113	3	santero_
santeros	8	3	1119	3	santeros
santol	6	45	1524	3	santol
sarod	6	53	2587	3	s_arod
saros	5	52	3806	3	s_aros
saurel	6	5	1199	3	saurel
school	11	4	1072	3	school
schorl	11	7	981	3	schorl
schrod	12	4	788	3	schrod
scleral	9	3	786	3	scleral
scrod	8	51	1507	3	s_crod
scroll	8	3	1017	3	s_croll
seal	4	56	5437	3	s_e_al
seel	4	50	4298	3	s_e_el
seer	4	55	4704	3	seer__
seers	5	51	3638	3	seer_s
sego	5	65	2518	3	s_ego_
segos	6	49	1948	3	s_egos
sel	3	82	5332	3	s_e__l
sell	4	58	4061	3	s_e_ll
senor	5	38	2280	3	s_enor
sepal	7	77	2300	3	s_epal
sepoy	10	3	1430	3	s_epoy
ser	3	67	5240	3	s_er__
sera	4	61	4139	3	s_er_a
serac	7	59	2520	3	s_erac
serai	5	68	3016	3	s_erai
serail	6	42	2267	3	s_erail
sere	4	61	5347	3	s_er_e
sered	6	57	3729	3	s_ered
serer	5	59	3551	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	2747	3	s_erge
serial	6	46	2586	3	s_erial
serif	8	41	3213	3	s_erif
serin	5	54	3444	3	s_erin
sermon	8	4	1355	3	s_ermon
serosa	6	3	1302	3	s_erosa
serosal	7	3	1115	3	s_erosal
serous	6	50	2356	3	s_erous
serows	9	60	1639	3	s_erows
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
servos	9	38	1272	3	s_ervos
setal	5	64	3090	3	s_etal
seton	5	52	2354	3	s_eton
several	10	3	953	3	several
sheal	8	49	2770	3	she_al
shekel	13	3	838	3	shekel
shell	8	44	2412	3	she_ll
sheols	9	46	1416	3	she_ols
sheqel	18	4	652	3	sheqel
sherd	9	63	2115	3	sher_d
sherds	10	56	1472	3	sherds
sherif	12	29	1524	3	sherif
sheroot	10	4	1437	3	sheroot
sherpa	11	3	809	3	sherpa
sherry	12	45	1041	3	sherry
shool	8	45	2315	3	s_hool
shorl	8	47	2025	3	shor_l
shtetel	10	3	394	3	shtetel
shtetl	9	3	644	3	shte_tl
sierra	6	3	731	3	sierra
skatol	10	3	572	3	skatol
skell	9	49	1583	3	ske_ll
skerry	13	35	610	3	skerry
skirl	9	60	1291	3	skir_l
smell	7	49	1623	3	sme_ll
smerk	11	54	1272	3	smer_k
smerks	12	44	971	3	smerks
snarl	5	49	2108	3	snar_l
snell	5	45	1730	3	sne_ll
snool	5	51	1864	3	s_nool
sokol	9	46	1229	3	s_okol
sol	3	72	5662	3	s___ol
sorel	5	62	3144	3	s_orel
sorrel	6	4	1355	3	sorrel
sorrow	9	33	944	3	sorrow
sotol	5	49	1765	3	s_otol
speel	7	44	2076	3	spe_el
speil	7	56	1864	3	spe_il
spell	7	50	2030	3	spe_ll
sperm	9	32	1602	3	sper_m
sperms	10	25	1260	3	sperms
spheral	12	3	842	3	spheral
spiral	8	37	1534	3	spiral
spool	7	52	1904	3	s_pool
sporal	8	29	1545	3	sporal
stall	5	47	2235	3	st_all
stanols	7	3	973	3	stanols
star	4	80	3776	3	star__
starch	11	30	1320	3	starch
stardom	10	3	776	3	stardom
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
stark	9	54	2562	3	star_k
starkly	14	27	703	3	starkly
starry	9	49	1167	3	starry
stars	5	58	3657	3	star_s
start	5	56	4231	3	star_t
startle	7	25	1112	3	startle
starts	6	54	2312	3	starts
starve	9	46	1374	3	starve
statal	6	16	1322	3	statal
stator	6	40	1548	3	stator
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
steals	6	40	2006	3	steals
steam	7	63	2293	3	ste_am
steamroll	11	5	210	3	steamroll
steams	8	49	1690	3	steams
steamy	11	51	1237	3	steamy
stearic	9	3	942	3	stearic
stearin	7	3	1200	3	stearin
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
steels	6	41	1798	3	steels
steely	9	36	1257	3	steely
steep	7	60	2070	3	ste_ep
steeple	9	3	732	3	steeple
steeply	12	3	629	3	steeply
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
steers	6	38	2098	3	steers
steeve	9	37	1090	3	steeve
stein	5	46	2054	3	ste_in
steins	6	48	1834	3	steins
stela	5	40	1904	3	ste_la
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
steles	6	37	2566	3	steles
stelic	8	3	1308	3	stelic
stella	6	36	1297	3	stella
stem	6	106	2825	3	ste__m
stemma	10	32	813	3	stemma
stemmy	13	41	703	3	stemmy
stems	7	52	1995	3	ste_ms
stemson	9	4	516	3	stemson
stench	11	41	1116	3	stench
stencil	9	4	689	3	stencil
stenoky	14	4	425	3	stenoky
stent	5	56	3451	3	ste_nt
stentor	7	3	938	3	stentor
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
stepson	9	4	567	3	stepson
stereoed	9	3	788	3	stereoed
sterical	10	3	1125	3	sterical
sterlet	7	13	1847	3	sterlet
sterner	7	4	1191	3	sterner
sternson	8	4	484	3	sternson
sternum	9	4	773	3	sternum
steroidal	10	4	547	3	stero~~ida~~l
steroids	9	9	1144	3	steroids
stertors	8	3	1093	3	stertors
stet	4	59	4732	3	ste__t
stets	5	54	2391	3	ste_ts
stetson	7	4	578	3	stetson
stew	7	75	2546	3	ste__w
stewed	10	48	1424	3	stewed
stews	8	55	1914	3	ste_ws
stewy	11	61	1206	3	ste_wy
stey	7	62	2441	3	ste__y
still	5	49	2208	3	st_ill
stipel	8	44	1212	3	stipel
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
stob	6	67	2461	3	st__ob
stole	5	49	2881	3	st__ole
stolon	6	41	1207	3	stolon
stomal	8	52	1331	3	stomal
stood	6	55	1771	3	st_ood
stook	9	52	1821	3	st_ook
stools	6	51	1702	3	st_ools
stoop	7	58	2154	3	st_oop
stop	6	65	3203	3	st__op
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
stork	9	68	1969	3	stor_k
storks	10	61	1595	3	storks
storm	7	65	2040	3	stor_m
storms	8	58	1463	3	storms
stormy	11	55	1073	3	stormy
story	8	67	2303	3	stor_y
stot	4	63	4733	3	st__ot
stow	7	73	2574	3	st__ow
strap	7	79	2526	3	st_rap
straw	8	133	2129	3	st_raw
stray	8	85	2557	3	st_ray
streak	10	46	1362	3	streak
stream	8	47	1729	3	stream
streek	10	41	1141	3	streek
streels	7	38	1134	3	streels
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
strew	8	92	2066	3	st_rew
strewn	9	67	1001	3	strewn
strews	9	68	1710	3	strews
stria	5	57	2321	3	st_ria
strip	7	75	2434	3	st_rip
strobe	8	45	1381	3	st_robe
strobil	9	3	696	3	st_robil
strode	7	52	1597	3	st_rode
stroke	10	51	1617	3	st_roke
strolls	7	3	918	3	st_rolls
stroma	8	43	1307	3	st_roma
stromal	9	30	1059	3	st_romal
strong	7	49	1488	3	st_rong
strook	10	4	1030	3	strook
strops	8	62	2038	3	st_rops
stroud	7	3	1038	3	st_roud
strove	9	50	1479	3	st_rove
strown	9	68	1209	3	st_rown
strows	9	67	1827	3	st_rows
stroys	9	59	1460	3	st_roys
strum	7	56	1945	3	st_rum
strut	5	60	3073	3	st_rut
stull	5	49	1627	3	st_ull
stupor	8	3	601	3	stupor
sturdy	10	3	704	3	sturdy
sturt	5	60	2896	3	stur_t
sturts	6	39	1514	3	sturts
styrax	16	7	524	3	styrax
suer	4	53	3403	3	suer__
suers	5	51	2848	3	suer_s
sural	5	59	3126	3	s_ural
sutural	7	3	1022	3	sutural
swell	8	48	1598	3	swe_ll
swerve	12	5	629	3	swerve
swirl	8	45	1414	3	swir_l
symbol	13	3	608	3	symbol
taro	4	68	4691	3	_taro_
taroc	7	57	2164	3	_taroc
tarok	9	79	2107	3	_tarok
taros	5	56	4082	3	_taros
tarot	5	59	4393	3	_tarot
taxol	12	40	1136	3	_taxol
teal	4	55	4650	3	_te_al
teel	4	63	3580	3	_te_el
tel	3	56	4790	3	_te__l
tell	4	49	3470	3	_te_ll
teloi	5	42	1738	3	_teloi
telos	5	54	2452	3	_telos
tenon	5	33	2051	3	_tenon
tenor	5	36	2025	3	_tenor
tepal	7	63	1958	3	_tepal
tepoy	10	3	1216	3	_tepoy
terai	5	35	2548	3	_terai
terce	7	57	2184	3	_terce
tercel	8	36	1299	3	_tercel
terga	6	33	1564	3	_terga
tergal	7	29	1283	3	_tergal
term	6	62	3315	3	_ter_m
termly	11	3	843	3	_termly
termor	8	44	1251	3	_termor
terms	7	55	2347	3	_terms
tern	4	61	3480	3	_ter_n
terne	5	64	2615	3	_terne
terns	5	52	2687	3	_terns
terra	5	44	1966	3	_terra
terror	6	38	1173	3	_terror
terry	8	47	2187	3	_terry
terse	5	50	2682	3	_terse
tetryl	9	3	569	3	_tetryl
thiol	8	76	1604	3	_thiol
thro	7	77	2642	3	_thro_
throb	10	98	1685	3	_throb
throe	8	93	2142	3	_throe
throw	11	87	1973	3	_throw
tirl	4	50	2992	3	_tir_l
tiro	4	68	3236	3	_tiro_
tiros	5	45	2489	3	_tiros
tool	4	67	3568	3	_t_ool
toro	4	80	4568	3	_toro_
toros	5	43	3619	3	_toros
torot	5	61	3994	3	_torot
triol	5	55	2136	3	_triol
trod	5	76	2795	3	_t_rod
trog	5	76	2821	3	_t_rog
troll	5	44	1653	3	_t_roll
trop	6	68	3330	3	_t_rop
trot	4	63	5131	3	_t_rot
trow	7	80	3142	3	_t_row
troy	7	74	2968	3	_t_roy
tyro	7	66	2236	3	_tyro_
tyros	8	51	1859	3	_tyros
uteri	5	10	1298	3	uter_i
uterus	6	3	920	3	uterus
viosterol	12	4	285	3	~~vio~~sterol
xerox	11	3	862	3	_xerox
zero	13	48	2247	3	_zero_
zeros	14	49	1811	3	_zeros
zoosterol	18	4	287	3	~~zoo~~sterol

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.373	479064.3
2	DLD Change Limit	112716	420	6.846	16464.5
3	Display Results	420	420	0.140	3000.0
	(SQL Overall)	178691	420	7.359	24282.0