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

Here are the results of your fuzzy-string dictionary search for “ream” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

298 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
ream	6	58	4161	(None)
beam	8	69	3923	1	beam
bream	9	51	2181	1	bream
cream	9	57	2135	1	cream
dream	8	51	2039	1	dream
ram	5	68	6727	1	r_am
read	5	59	4253	1	read
real	4	57	5029	1	real
realm	7	56	2162	1	realm
reams	7	57	2962	1	reams
reap	6	59	3474	1	reap
rear	4	56	4455	1	rear
rearm	7	59	2357	1	rearm
rem	5	61	5004	1	re_m
roam	6	71	3241	1	roam
seam	6	66	4597	1	seam
team	6	62	3865	1	team
abeam	9	3	1653	2	abeam
am	4	118	7556	2	__am
area	4	58	4339	2	area_
areae	5	52	2974	2	areae
areal	5	59	2873	2	areal
areas	5	59	3577	2	areas
bam	7	85	6014	2	_bam
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beams	9	53	2817	2	beams
beamy	12	62	1857	2	beamy
bean	6	64	4386	2	bean
bear	6	68	4464	2	bear
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
bema	8	58	2525	2	bema
berm	8	67	3275	2	berm
blam	8	61	3170	2	blam
bread	8	55	2311	2	bread
break	11	53	1940	2	break
breams	10	48	1504	2	breams
cam	7	80	5898	2	_cam
cham	11	55	3231	2	cham
clam	8	63	3229	2	clam
cram	8	56	3549	2	cram
creak	11	54	1843	2	creak
creams	10	47	1525	2	creams
creamy	13	48	1136	2	creamy
dam	6	74	5704	2	_dam
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
deem	7	54	3289	2	deem
derm	7	60	3189	2	derm
dram	7	58	3200	2	dram
dread	7	44	1902	2	dread
dreams	9	45	1398	2	dreams
dreamt	9	46	1571	2	dreamt
dreamy	12	50	999	2	dreamy
drear	6	50	1690	2	drear
ear	3	68	6788	2	_ear
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
elm	5	75	3174	2	_elm
em	4	94	4515	2	_e_m
era	3	57	4150	2	era_
eras	4	54	4150	2	eras
exam	13	25	1462	2	exam
feal	7	139	4042	2	feal
fear	7	53	3779	2	fear
feat	7	64	5822	2	feat
fem	8	60	4073	2	fe_m
flam	9	63	3329	2	flam
fleam	10	60	1728	2	fleam
foam	9	71	2717	2	foam
freak	12	51	1524	2	freak
gam	6	70	6006	2	_gam
gear	5	59	3497	2	gear
gem	6	68	4022	2	ge_m
germ	7	54	2896	2	germ
geum	7	54	2455	2	geum
glam	7	65	2934	2	glam
gleam	8	69	1673	2	gleam
gram	7	70	3458	2	gram
great	6	60	3424	2	great
haem	9	57	3098	2	haem
ham	8	63	6328	2	_ham
head	8	71	3717	2	head
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
hear	7	61	4388	2	hear
heat	7	70	6142	2	heat
helm	9	55	3002	2	helm
hem	8	61	4873	2	he_m
herm	9	56	3615	2	herm
imam	8	17	1833	2	imam
jam	12	69	4252	2	_jam
jean	11	66	2928	2	jean
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
lam	5	76	6671	2	_lam
lea	3	76	6018	2	lea_
lead	5	60	3885	2	lead
leaf	7	64	4103	2	leaf
leak	8	62	3371	2	leak
leal	4	60	4327	2	leal
lean	4	63	4524	2	lean
leap	6	60	3268	2	leap
lear	4	70	4595	2	lear
leas	4	59	5418	2	leas
loam	6	56	3048	2	loam
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3809	2	mean
meat	6	63	5960	2	meat
mem	7	79	4347	2	me_m
nam	5	59	5339	2	_nam
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neat	4	63	5678	2	neat
neem	6	73	2808	2	neem
nema	6	55	2252	2	nema
neum	6	67	2308	2	neum
ogam	7	51	2003	2	ogam
oread	6	46	1960	2	oread
pam	7	78	5839	2	_pam
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pear	6	97	4523	2	pear
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
perm	8	58	3463	2	perm
praam	9	48	1561	2	praam
pram	8	57	3349	2	pram
preamp	12	3	899	2	preamp
prearm	10	45	1235	2	prearm
rad	4	76	6200	2	r_ad
rag	4	57	6132	2	r_ag
rah	6	80	5240	2	r_ah
rai	3	76	5822	2	r_ai
raj	10	57	4022	2	r_aj
rami	6	60	3409	2	r_ami
ramp	8	59	3400	2	r_amp
rams	6	59	5077	2	r_ams
ran	3	82	6662	2	r_an
rap	5	62	6196	2	r_ap
ras	3	75	7539	2	r_as
rat	3	78	9274	2	r_at
raw	6	72	5225	2	r_aw
rax	10	84	4572	2	r_ax
ray	6	63	6199	2	r_ay
re	2	61	5374	2	re__
reach	10	51	2388	2	reach
react	7	46	3433	2	react
readd	7	46	1713	2	readd
reads	6	48	3527	2	reads
ready	9	48	2150	2	ready
realms	8	49	1349	2	realms
reals	5	50	3865	2	reals
reamed	9	43	2612	2	reamed
reamer	8	43	2521	2	reamer
reaps	7	56	2619	2	reaps
rearms	8	51	1465	2	rearms
rears	5	47	3965	2	rears
reata	5	42	2539	2	reata
reave	8	45	2802	2	reave
reb	5	58	4496	2	re_b
rebar	7	54	2019	2	rebar
rebs	6	57	3356	2	rebs
rec	5	56	4546	2	re_c
recap	9	57	1802	2	recap
reck	10	61	3056	2	reck
recs	6	57	3418	2	recs
red	4	67	5580	2	re_d
redan	6	61	2501	2	redan
redd	6	63	2317	2	redd
rede	5	50	3767	2	rede
redo	5	60	2936	2	redo
reds	5	60	4286	2	reds
ree	3	79	7407	2	re_e
reed	5	55	4962	2	reed
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
ref	6	60	5329	2	re_f
refs	7	57	3224	2	refs
reft	7	51	4127	2	reft
reg	4	61	4649	2	re_g
regal	6	50	2379	2	regal
regma	8	46	1233	2	regma
regs	5	54	3657	2	regs
rehab	10	3	1244	2	rehab
rehem	10	38	1535	2	rehem
rei	3	56	4725	2	re_i
reif	7	69	3765	2	reif
rein	4	60	4089	2	rein
reis	4	53	4323	2	reis
relax	12	48	1780	2	relax
relay	8	44	2467	2	relay
rely	7	54	2895	2	rely
reman	7	57	3015	2	reman
remap	9	54	1810	2	remap
rems	6	62	3772	2	rems
renal	5	59	2950	2	renal
rename	8	27	1881	2	rename
rend	5	61	3657	2	rend
rent	4	66	6124	2	rent
rep	5	58	4780	2	re_p
repay	10	48	1845	2	repay
repo	6	60	2754	2	repo
repp	8	54	1874	2	repp
reps	6	59	3795	2	reps
reran	5	73	2910	2	reran
res	3	55	6504	2	re_s
resat	5	51	3968	2	resat
resaw	8	41	1725	2	resaw
resay	8	53	2054	2	resay
resh	7	65	2345	2	resh
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
retag	6	36	1841	2	retag
retax	12	45	1797	2	retax
rete	4	49	4413	2	rete
reteam	8	32	1453	2	reteam
retem	7	42	2195	2	retem
rets	4	53	5256	2	rets
rev	6	53	3662	2	re_v
revamp	13	3	601	2	revamp
revs	7	50	2705	2	revs
rewan	8	56	2366	2	rewan
rewarm	11	59	1349	2	rewarm
rewax	15	57	1392	2	rewax
rex	10	57	4099	2	re_x
rhea	7	50	1743	2	rhea_
rheas	8	48	1695	2	rheas
rheum	10	3	884	2	rheum
ria	3	67	4550	2	ria_
rial	4	59	3809	2	rial
rias	4	55	4059	2	rias
rim	5	60	5227	2	r_im
road	5	63	3211	2	road
roams	7	49	1961	2	roams
roan	4	72	3420	2	roan
roar	4	63	2857	2	roar
rom	5	98	5563	2	r_om
room	6	62	3508	2	room
rum	5	66	4464	2	r_um
rya	6	76	2201	2	rya_
ryas	7	72	2461	2	ryas
scam	8	59	3235	2	scam
scream	10	48	1425	2	scream
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seams	7	57	3166	2	seams
seamy	10	59	2127	2	seamy
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
seem	6	54	3856	2	seem
sham	9	64	3636	2	sham
slam	6	77	3797	2	slam
spam	8	59	3004	2	spam
steam	7	63	2293	2	steam
stream	8	47	1729	2	stream
swam	9	63	2998	2	swam
tam	5	86	6342	2	_tam
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
teams	7	57	2651	2	teams
tear	4	52	4288	2	tear
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
teem	6	61	3260	2	teem
term	6	62	3315	2	term
tram	6	70	3455	2	tram
tread	6	48	2170	2	tread
treat	5	62	4035	2	treat
urea	4	65	2805	2	urea_
ureal	5	67	2268	2	ureal
ureas	5	58	2601	2	ureas
veal	7	69	3681	2	veal
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
wean	7	57	3435	2	wean
wear	7	58	3672	2	wear
wham	12	53	2169	2	wham
wreak	12	55	1327	2	wreak
yam	8	74	4899	2	_yam
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
year	7	65	3425	2	year
yeas	7	86	3842	2	yeas
zeal	13	55	3033	2	zeal

Search took 2 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	29872	0.266	671770.7
2	DLD Change Limit	29872	298	0.903	33080.8
3	Display Results	298	298	0.080	3725.0
	(SQL Overall)	178691	298	1.249	143067.3