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

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

505 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
stream	8	47	1728	(None)
scream	10	48	1424	1	scream
steam	7	63	2292	1	st_eam
streak	10	46	1362	1	streak
streams	9	47	1337	1	streams
streamy	12	50	948	1	streamy
bream	9	51	2181	2	_bream
cream	9	57	2134	2	_cream
dream	8	51	2039	2	_dream
estreat	7	3	1481	2	estreat
onstream	10	4	510	2	onstream
ream	6	58	4161	2	__ream
scram	9	106	2161	2	scr_am
screak	12	53	1105	2	screak
screams	11	48	1061	2	screams
seam	6	66	4597	2	s__eam
spread	9	3	1253	2	spread
stead	6	55	2027	2	st_ead
steak	9	52	1980	2	st_eak
steal	5	61	2547	2	st_eal
steams	8	49	1690	2	st_eams
steamy	11	51	1237	2	st_eamy
stem	6	106	2824	2	st_e_m
strap	7	79	2526	2	str_ap
straw	8	133	2129	2	str_aw
stray	8	85	2557	2	str_ay
streaks	11	44	1127	2	streaks
streaky	14	44	781	2	streaky
streamed	11	25	890	2	streamed
streamer	10	23	950	2	streamer
streek	10	41	1141	2	streek
streel	6	42	1402	2	streel
street	6	41	2577	2	street
strep	7	71	2085	2	stre_p
streps	8	62	1806	2	streps
stress	6	66	1667	2	stress
strew	8	92	2065	2	stre_w
strewn	9	67	1000	2	strewn
strews	9	68	1709	2	strews
stria	5	57	2320	2	stria_
striae	6	54	2227	2	striae
stroma	8	43	1307	2	stroma
strum	7	56	1944	2	str_um
struma	8	43	1327	2	struma
team	6	62	3865	2	_t_eam
tram	6	70	3455	2	_tr_am
tread	6	48	2170	2	_tread
treat	5	62	4035	2	_treat
upstream	12	4	355	2	upstream
abeam	9	3	1653	3	_abeam
agleam	9	15	862	3	agleam
airstream	11	5	354	3	~~air~~stream
area	4	58	4339	3	_area_
areae	5	52	2974	3	_areae
areal	5	59	2873	3	_areal
areas	5	59	3577	3	_areas
arrear	6	3	1025	3	arrear
ashram	11	3	905	3	ashr_am
astral	6	69	1928	3	astr_al
astray	9	56	1554	3	astr_ay
atria	5	60	2233	3	atria_
atrial	6	54	1894	3	atrial
atrium	8	4	1182	3	atrium
beam	8	69	3923	3	__beam
bitstream	13	4	258	3	~~bit~~stream
boreal	8	48	1721	3	boreal
boreas	8	54	2173	3	boreas
bread	8	55	2311	3	_bread
break	11	53	1940	3	_break
breams	10	48	1504	3	_breams
bureau	8	7	1252	3	bureau
cereal	8	3	1583	3	cereal
cram	8	56	3549	3	_cr_am
creak	11	54	1843	3	_creak
creams	10	47	1525	3	_creams
creamy	13	48	1136	3	_creamy
diram	8	44	1947	3	dir_am
dirham	12	37	827	3	dirham
dram	7	58	3200	3	_dr_am
dread	7	44	1902	3	_dread
dreams	9	45	1398	3	_dreams
dreamt	9	46	1571	3	_dreamt
dreamy	12	50	999	3	_dreamy
drear	6	50	1690	3	_drear
entreat	7	3	1526	3	entreat
esteem	8	3	881	3	est_eem
estral	6	47	1651	3	estr_al
estray	9	57	1333	3	estr_ay
estreats	8	3	942	3	estreats
estrual	7	36	793	3	estrual
estrum	8	18	1051	3	estr_um
extrema	16	7	501	3	extrema
ferbam	13	3	900	3	ferbam
firearm	12	3	719	3	firearm
fleam	10	60	1728	3	_fleam
foram	10	51	2493	3	for_am
forearm	12	3	869	3	forearm
freak	12	51	1524	3	_freak
gastrea	8	4	722	3	gastrea_
gastreas	9	5	724	3	gastreas
gleam	8	69	1673	3	_gleam
gram	7	70	3458	3	_gr_am
great	6	60	3424	3	_great
hareem	11	43	1206	3	hareem
harem	10	49	2445	3	hare_m
hereat	9	35	2741	3	hereat
ihram	10	3	1018	3	ihr_am
inseam	8	32	999	3	inseam
intreat	7	4	1630	3	intreat
irreal	6	5	782	3	irreal
item	6	56	2038	3	it_e_m
iterum	8	3	790	3	iterum
jetstream	18	5	222	3	~~jet~~stream
joram	14	58	1698	3	jor_am
loreal	6	38	1431	3	loreal
marram	10	3	1388	3	marram
midstream	14	4	357	3	~~mid~~stream
mistreat	10	3	1311	3	mistreat
ocrea	7	33	1182	3	ocrea_
ocreae	8	33	1027	3	ocreae
oread	6	46	1960	3	_oread
osteal	6	3	1295	3	ost_eal
outbeam	11	3	797	3	outbeam
outdream	11	4	471	3	outdream
outread	8	28	1109	3	outread
perea	7	50	2644	3	perea_
phreak	15	3	615	3	phreak
praam	9	48	1561	3	_praam
pram	8	57	3349	3	_pr_am
preamp	12	3	899	3	_preamp
prearm	10	45	1234	3	_prearm
ram	5	68	6727	3	__r_am
read	5	59	4253	3	__read
real	4	57	5029	3	__real
realm	7	56	2162	3	__realm
reams	7	57	2962	3	__reams
reap	6	59	3474	3	__reap
rear	4	56	4455	3	__rear
rearm	7	59	2356	3	__rearm
redream	10	10	791	3	redream
rem	5	61	5004	3	__re_m
reread	7	17	1543	3	reread
reteam	8	32	1453	3	reteam
retread	8	4	900	3	retread
retreat	7	3	1753	3	retreat
roam	6	71	3241	3	__roam
salaam	8	7	1101	3	salaam
saran	5	37	3030	3	sar_an
sarcasm	11	3	669	3	sarcasm
sardar	7	30	1317	3	sardar
saree	5	50	4466	3	sare_e
sarees	6	53	2994	3	sarees
sarsar	6	30	1184	3	sarsar
satem	7	60	2145	3	sate_m
satrap	8	62	1255	3	satr_ap
scam	8	59	3235	3	s__cam
schema	13	8	837	3	schema
scrag	8	59	1617	3	scr_ag
scrams	10	52	1662	3	scr_ams
scrap	9	71	2040	3	scr_ap
screaks	13	46	935	3	screaks
screaky	16	43	621	3	screaky
screamed	13	27	759	3	screamed
screamer	12	26	787	3	screamer
scree	7	200	3170	3	scre_e
screed	9	57	1892	3	screed
screen	8	52	1601	3	screen
screes	8	50	2396	3	screes
screw	10	93	1853	3	scre_w
screws	11	55	1388	3	screws
screwy	14	65	945	3	screwy
scrim	9	54	1972	3	scr_im
scrum	9	54	1819	3	scr_um
sea	3	61	6129	3	s__ea_
seal	4	56	5437	3	s__eal
seams	7	57	3166	3	s__eams
seamy	10	59	2127	3	s__eamy
sear	4	73	5384	3	s__ear
seas	4	57	5527	3	s__eas
seat	4	75	7556	3	s__eat
seem	6	54	3856	3	s__eem
sera	4	61	4139	3	ser_a_
serac	7	59	2520	3	ser_ac
serai	5	68	3016	3	ser_ai
seral	5	63	3638	3	ser_al
serdab	9	3	783	3	serdab
sere	4	61	5347	3	sere__
sered	6	57	3729	3	sere_d
serein	6	33	1846	3	serein
serene	6	35	2235	3	serene
serer	5	59	3550	3	sere_r
seres	5	54	4889	3	sere_s
serest	6	48	3161	3	serest
serial	6	46	2585	3	serial
seriema	9	3	840	3	seriema
serum	7	52	2347	3	ser_um
serval	9	39	1341	3	serval
sham	9	64	3635	3	s__ham
shazam	20	4	660	3	shazam
shea	7	60	3157	3	s_hea_
sheaf	11	54	2412	3	s_heaf
sheal	8	49	2770	3	s_heal
shear	8	54	2483	3	s_hear
sheas	8	63	3179	3	s_heas
shmear	11	7	693	3	shmear
shred	9	81	2561	3	shre_d
shreds	10	56	1305	3	shreds
shrew	11	97	2016	3	shre_w
shrewd	13	68	1077	3	shrewd
shrews	12	93	1391	3	shrews
sidearm	10	3	596	3	sidearm
sirdar	7	26	910	3	sirdar
sire	4	61	5041	3	sire__
sired	6	61	3428	3	sire_d
siree	5	52	3881	3	sire_e
sirees	6	46	2458	3	sirees
siren	5	45	2582	3	sire_n
sirens	6	53	1815	3	sirens
sires	5	59	4537	3	sire_s
sirra	5	44	1632	3	sirra_
sirrah	9	37	975	3	sirrah
sirras	6	38	1486	3	sirras
skean	9	44	1562	3	s_kean
skelm	11	42	1128	3	s_kelm
slam	6	77	3797	3	s__lam
smear	7	44	1639	3	s_mear
sneak	9	60	1617	3	s_neak
sneap	7	55	1482	3	s_neap
sora	4	57	4691	3	sor_a_
soras	5	50	4101	3	sor_as
sore	4	70	5953	3	sore__
sored	6	61	4178	3	sore_d
sorel	5	62	3144	3	sore_l
sorels	6	39	2116	3	sorels
sorely	9	46	1800	3	sorely
sorer	5	62	3657	3	sore_r
sores	5	54	5428	3	sore_s
sorest	6	50	2799	3	sorest
sorta	5	71	2541	3	sorta_
spam	8	59	3004	3	s__pam
speak	11	46	1867	3	s_peak
spean	7	46	2051	3	s_pean
spear	7	58	2106	3	s_pear
sperm	9	32	1601	3	s_perm
spirea	8	40	1563	3	spirea_
spireas	9	44	1251	3	spireas
spirem	10	42	1416	3	spire_m
sprag	8	64	1869	3	spr_ag
sprat	7	66	3597	3	spr_at
spray	10	67	2006	3	spr_ay
spreads	10	3	976	3	spreads
spree	7	48	3086	3	spre_e
sprees	8	56	2064	3	sprees
sprent	8	45	2238	3	sprent
squeak	19	3	525	3	squeak
squeal	15	3	801	3	squeal
stab	6	73	2993	3	st__ab
stag	5	73	3200	3	st__ag
stalag	7	3	1002	3	stalag
stamp	9	52	1736	3	st__amp
star	4	80	3776	3	st__ar
stardom	10	3	776	3	stardom
stare	5	44	4026	3	stare__
stared	7	54	2987	3	stare_d
starer	6	40	2736	3	stare_r
starers	7	45	2231	3	starers
stares	6	60	3875	3	stare_s
starets	7	35	1592	3	starets
stat	4	73	5269	3	st__at
statal	6	16	1322	3	statal
staw	7	86	2769	3	st__aw
stay	7	83	3372	3	st__ay
steads	7	41	1622	3	st_eads
steady	10	35	1020	3	st_eady
steaks	10	44	1585	3	st_eaks
steals	6	40	2006	3	st_eals
steamed	10	37	1214	3	st_eamed
steamer	9	33	1309	3	st_eamer
steed	6	60	2494	3	st_eed
steeds	7	38	1488	3	steeds
steek	9	54	1800	3	st_eek
steeks	10	36	1370	3	steeks
steel	5	57	2199	3	st_eel
steels	6	41	1798	3	steels
steely	9	36	1257	3	steely
steep	7	60	2070	3	st_eep
steeps	8	52	1519	3	steeps
steer	5	54	2386	3	st_eer
steers	6	38	2098	3	steers
steeve	9	37	1090	3	steeve
stein	5	46	2053	3	st_ein
stela	5	40	1904	3	st_ela
stelae	6	37	1648	3	stelae
stelai	6	39	1256	3	stelai
stelar	6	40	1386	3	stelar
stele	5	50	2684	3	st_ele
stemma	10	32	813	3	st_emma
stemmy	13	41	703	3	st_emmy
stems	7	52	1995	3	st_ems
steno	5	47	1686	3	st_eno
stent	5	56	3451	3	st_ent
step	6	71	2629	3	st_e_p
steps	7	66	1988	3	st_eps
stere	5	53	2854	3	st_ere
stereo	6	53	1791	3	stereo
stereos	7	43	1497	3	stereos
steres	6	39	2953	3	steres
steric	8	3	1706	3	steric
stern	5	53	1912	3	st_ern
sterna	6	37	1276	3	sterna
sternal	7	34	1190	3	sternal
sterns	6	46	1675	3	sterns
sternum	9	4	773	3	sternum
sterol	6	6	1332	3	sterol
stet	4	59	4732	3	st_e_t
stets	5	54	2391	3	st_ets
stew	7	75	2546	3	st_e_w
stews	8	55	1914	3	st_ews
stewy	11	61	1206	3	st_ewy
stey	7	62	2441	3	st_e_y
stied	6	57	2303	3	stie_d
sties	5	51	3298	3	stie_s
stigma	9	22	675	3	stigma
stoa	4	54	2591	3	st_oa_
stoae	5	50	2426	3	st_oae
stoai	5	54	1786	3	st_oai
stoas	5	51	2602	3	st_oas
stoat	5	71	3595	3	st_oat
stoma	7	59	1827	3	stoma_
stomal	8	52	1331	3	stomal
stomas	8	48	1632	3	stomas
storax	13	8	978	3	storax
store	5	63	3381	3	store__
stored	7	55	2421	3	store_d
storer	6	47	2167	3	store_r
storers	7	50	1868	3	storers
stores	6	55	3364	3	store_s
storey	9	52	1761	3	store_y
storeys	10	55	965	3	storeys
storm	7	65	2037	3	st_orm
strafe	9	52	1597	3	strafe
strain	6	49	1957	3	strain
strait	6	40	2589	3	strait
strake	10	40	1739	3	strake
strand	7	45	1482	3	strand
strang	7	57	1831	3	strang
straps	8	77	2178	3	straps
strass	6	71	1722	3	strass
strata	6	36	1628	3	strata
stratal	7	27	1060	3	stratal
stratas	7	30	1357	3	stratas
strath	9	32	1636	3	strath
strati	6	35	1889	3	strati
stratum	9	31	824	3	stratum
straws	9	87	1867	3	straws
strawy	12	103	1282	3	strawy
strays	9	64	1793	3	strays
streaked	13	22	845	3	streaked
streaker	12	22	947	3	streaker
streambed	14	8	333	3	stream~~bed~~
streamers	11	22	806	3	stream~~ers~~
streamier	11	5	576	3	stream~~ier~~
streaming	12	23	965	3	stream~~ing~~
streamlet	11	4	604	3	stream~~let~~
streeks	11	37	871	3	streeks
streels	7	38	1134	3	streels
streets	7	33	1261	3	streets
stretch	12	3	641	3	stretch
stretta	7	3	729	3	stretta
strettas	8	4	642	3	strettas
strette	7	3	1076	3	strette
stretti	7	4	790	3	stretti
stretto	7	3	772	3	stretto
strewed	11	58	1133	3	strewed
strewer	10	43	1040	3	strewer
striata	7	37	995	3	striata
striate	7	42	1895	3	striate
striatum	10	4	447	3	striatum
strick	12	48	1320	3	strick
strict	8	48	2104	3	strict
stride	7	54	2096	3	stride
strife	9	53	1836	3	strife
strike	10	56	1973	3	strike
string	7	53	2756	3	string
strip	7	75	2433	3	str_ip
stripe	8	58	2244	3	stripe
strips	8	57	1965	3	strips
stript	8	52	2219	3	stript
stripy	11	58	1274	3	stripy
strive	9	50	2096	3	strive
strobe	8	45	1381	3	strobe
strode	7	52	1597	3	strode
stroke	10	51	1617	3	stroke
stroll	6	3	1160	3	stroll
stromal	9	30	1058	3	stromal
strong	7	49	1488	3	strong
strook	10	4	1030	3	strook
strop	7	74	2224	3	str_op
strops	8	62	2038	3	strops
stroud	7	3	1038	3	stroud
strove	9	50	1479	3	strove
strow	8	89	2057	3	str_ow
strown	9	68	1209	3	strown
strows	9	67	1827	3	strows
stroy	8	77	2039	3	str_oy
stroys	9	59	1460	3	stroys
struck	12	48	926	3	struck
strumae	9	36	809	3	strumae
strumas	9	41	983	3	strumas
strums	8	47	1645	3	strums
strung	7	52	1302	3	strung
strunt	6	49	1891	3	strunt
strut	5	60	3073	3	str_ut
struts	6	56	1680	3	struts
stum	6	55	2601	3	st__um
stupa	7	41	1231	3	stupa_
stupas	8	39	1088	3	stupas
stye	7	62	1897	3	stye__
styed	9	58	1548	3	stye_d
styes	8	63	1652	3	stye_s
stylar	9	35	811	3	stylar
styrax	16	7	524	3	styrax
styrene	10	11	669	3	styrene
sunbeam	11	4	605	3	sunbeam
sura	4	57	4029	3	sur_a_
surah	8	68	2325	3	sur_ah
sural	5	59	3126	3	sur_al
suras	5	53	3632	3	sur_as
sure	4	54	4741	3	sure__
surely	9	38	1645	3	surely
surer	5	48	3309	3	sure_r
surest	6	50	2676	3	surest
surety	9	35	1500	3	surety
surname	9	3	760	3	surname
surra	5	55	2134	3	surra_
surras	6	59	1953	3	surras
surreal	7	3	922	3	surreal
surtax	13	3	784	3	surtax
sutra	5	42	1793	3	sutr_a_
sutras	6	48	1858	3	sutr_as
swam	9	63	2998	3	s__wam
swear	8	53	1685	3	s_wear
sweat	8	56	2840	3	s_weat
syren	8	52	1674	3	syre_n
syrens	9	49	1199	3	syrens
tam	5	86	6342	3	_t__am
tea	3	73	5332	3	_t_ea_
teak	8	59	3084	3	_t_eak
teal	4	55	4650	3	_t_eal
teams	7	57	2651	3	_t_eams
tear	4	52	4288	3	_t_ear
teas	4	58	5149	3	_t_eas
teat	4	59	6363	3	_t_eat
teem	6	61	3260	3	_t_eem
terai	5	35	2548	3	_terai
term	6	62	3315	3	_t_erm
them	9	74	2704	3	_the_m
therm	10	60	1802	3	_therm
thread	10	50	1109	3	thread
threap	11	56	966	3	threap
threat	9	50	2046	3	threat
toea	4	67	3233	3	_toea_
toeas	5	57	2642	3	_toeas
trad	5	56	3091	3	_tr_ad
tramp	9	63	1977	3	_tr_amp
trams	7	53	2767	3	_tr_ams
trap	6	75	3280	3	_tr_ap
tray	7	76	3259	3	_tr_ay
treads	7	48	1791	3	_treads
treats	6	48	2169	3	_treats
treaty	9	44	1435	3	_treaty
tree	4	77	4581	3	_tre_e
treed	6	56	2673	3	_treed
treen	5	56	2275	3	_treen
trees	5	58	3576	3	_trees
tref	7	70	3099	3	_tre_f
trefah	12	3	509	3	_trefah
trek	8	62	2231	3	_tre_k
treks	9	60	1685	3	_treks
trend	6	48	1745	3	_trend
trepan	8	25	1167	3	_trepan
tres	4	65	4290	3	_tre_s
tress	5	54	2316	3	_tress
tret	4	66	5353	3	_tre_t
trets	5	59	2802	3	_trets
trews	8	61	1889	3	_trews
trey	7	72	2879	3	_tre_y
treys	8	50	1821	3	_treys
triac	7	41	1637	3	_triac
triad	6	52	1772	3	_triad
trial	5	49	2635	3	_trial
trim	6	53	2951	3	_tr_im
troak	9	52	1357	3	_troak
tryma	10	3	722	3	_tryma
tweak	12	5	775	3	_tweak
unread	7	34	1267	3	unread
unreal	6	44	1445	3	unreal
unseam	8	33	1314	3	unseam
untread	8	5	741	3	untread
uprear	8	16	879	3	uprear
urea	4	65	2805	3	_urea_
ureal	5	67	2268	3	_ureal
ureas	5	58	2601	3	_ureas
wreak	12	55	1327	3	_wreak
ziram	16	39	1289	3	zir_am

Search took 6 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.140	1276364.3
2	DLD Change Limit	112716	505	5.656	19928.6
3	Display Results	505	505	0.156	3237.2
	(SQL Overall)	178691	505	5.952	30022.0