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

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

333 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
bean	6	64	4386	(None)
ban	5	83	6684	1	b_an
bead	7	59	3792	1	bead
beak	10	65	3438	1	beak
beam	8	69	3923	1	beam
beano	7	54	2155	1	beano
beans	7	57	3469	1	beans
bear	6	68	4464	1	bear
beat	6	61	6830	1	beat
beau	6	61	3727	1	beau
been	6	53	3578	1	been
began	8	63	1957	1	began
ben	5	65	5492	1	be_n
bran	6	57	4038	1	bran
dean	5	60	3948	1	dean
jean	11	66	2928	1	jean
lean	4	63	4524	1	lean
mean	6	55	3809	1	mean
pean	6	61	4717	1	pean
wean	7	57	3435	1	wean
yean	7	58	3458	1	yean
abeam	9	3	1653	2	abeam
aeon	4	56	3461	2	aeon
alan	4	68	4408	2	alan
an	2	118	7908	2	__an
azan	13	65	2178	2	azan
ba	4	99	6234	2	b_a_
baa	5	106	5042	2	b_aa
baal	6	70	3311	2	baal
baas	6	68	4467	2	baas
bad	6	77	6315	2	b_ad
bag	6	70	5922	2	b_ag
bah	8	77	5535	2	b_ah
bal	5	66	6272	2	b_al
bam	7	85	6014	2	b_am
band	7	67	4091	2	b_and
bane	6	52	5043	2	b_ane
bang	7	48	3700	2	b_ang
bani	6	53	3496	2	b_ani
bank	10	58	3575	2	b_ank
bans	6	65	5514	2	b_ans
bap	7	64	5584	2	b_ap
bar	5	80	7055	2	b_ar
barn	6	64	4464	2	barn
bas	5	86	8175	2	b_as
bat	5	109	8895	2	b_at
bay	8	96	6164	2	b_ay
be	4	79	4894	2	be__
beach	12	46	2389	2	beach
beacon	10	5	1137	2	beacon
beads	8	54	2950	2	beads
beady	11	47	1992	2	beady
beaks	11	53	2662	2	beaks
beaky	14	61	1802	2	beaky
beams	9	53	2817	2	beams
beamy	12	62	1857	2	beamy
beaned	9	56	2147	2	beaned
beanie	8	36	1859	2	beanie
beanos	8	55	1651	2	beanos
beard	8	60	2496	2	beard
bears	7	57	3904	2	bears
beast	7	63	3864	2	beast
beaten	8	46	1706	2	beaten
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
beaut	7	51	3521	2	beaut
beaux	14	65	1321	2	beaux
becap	11	43	1505	2	becap
beck	12	62	2657	2	beck
bed	6	79	5062	2	be_d
bedamn	11	3	781	2	bedamn
bedpan	11	3	758	2	bedpan
beds	7	59	3778	2	beds
bedu	7	59	2369	2	bedu
bee	5	62	6240	2	be_e
beef	9	62	3368	2	beef
beep	8	59	3121	2	beep
beer	6	56	3599	2	beer
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
beg	6	59	4413	2	be_g
begat	8	66	2972	2	begat
begin	8	51	1735	2	begin
begs	7	57	3383	2	begs
begun	8	51	1344	2	begun
being	8	49	2050	2	being
bel	5	71	4846	2	be_l
belay	10	50	2152	2	belay
bell	6	62	3718	2	bell
belon	7	39	2411	2	belon
bels	6	61	4249	2	bels
belt	6	57	5403	2	belt
bema	8	58	2525	2	bema
bemas	9	64	2428	2	bemas
bemean	10	4	1068	2	bemean
bemoan	10	3	1025	2	bemoan
bend	7	64	3526	2	bend
bene	6	64	3949	2	bene
benne	7	65	2112	2	benne
benni	7	47	1536	2	benni
benny	10	52	1736	2	benny
bens	6	59	4570	2	bens
bent	6	77	5991	2	bent
berg	7	54	2554	2	berg
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
bes	5	65	5743	2	be_s
best	6	63	5532	2	best
bet	5	83	7667	2	be_t
beta	6	62	3413	2	beta
betas	7	55	2876	2	betas
beth	9	66	2923	2	beth
beton	7	60	2206	2	beton
bets	6	70	5144	2	bets
bevy	12	71	1522	2	bevy
bey	8	66	4542	2	be_y
beys	9	138	2955	2	beys
bezant	17	8	1454	2	bezant
bhang	11	55	1292	2	bhang
bias	6	47	3816	2	bias
bin	5	66	5864	2	b_in
blab	8	66	2913	2	blab
blae	6	61	3464	2	blae
blah	9	86	2506	2	blah
blain	7	54	2179	2	blain
blam	8	61	3170	2	blam
bland	8	53	2045	2	bland
blank	11	54	1855	2	blank
blat	6	65	5095	2	blat
blaw	9	70	2672	2	blaw
blawn	10	68	1370	2	blawn
bleak	11	59	1538	2	bleak
blear	7	59	1868	2	blear
bleat	7	57	3700	2	bleat
blin	6	72	2817	2	blin
boa	5	69	5403	2	boa_
boar	6	61	3429	2	boar
boas	6	61	5083	2	boas
boat	6	63	6031	2	boat
bogan	8	75	1900	2	bogan
boon	6	71	4217	2	boon
born	6	73	3841	2	born
bra	5	63	3946	2	bra_
brad	7	52	3434	2	brad
brae	6	56	3911	2	brae
brag	7	52	2972	2	brag
brain	7	62	2938	2	brain
brand	8	51	2449	2	brand
brank	11	52	2228	2	brank
brans	7	54	3743	2	brans
brant	7	47	4217	2	brant
bras	6	57	4645	2	bras
brat	6	60	5554	2	brat
braw	9	48	2956	2	braw
brawn	10	60	1856	2	brawn
bray	9	52	3290	2	bray
bread	8	55	2311	2	bread
break	11	53	1940	2	break
bream	9	51	2181	2	bream
bren	6	56	2956	2	bren
brin	6	70	3819	2	brin
bun	5	63	4814	2	b_un
buna	6	47	3072	2	buna
bunn	6	50	2365	2	bunn
buran	7	52	2530	2	buran
burn	6	56	3643	2	burn
bwana	10	3	1024	2	bwana
can	5	77	6014	2	_can
clan	6	56	3392	2	clan
clean	7	54	2041	2	clean
cyan	9	64	1962	2	cyan
dan	4	68	5967	2	_dan
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear
den	4	75	5434	2	de_n
dewan	9	57	1804	2	dewan
ear	3	68	6788	2	_ear
earn	4	67	3755	2	_earn
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
ebon	6	68	2110	2	ebon
elan	4	67	3424	2	elan
en	2	80	5239	2	_e_n
eon	3	60	5208	2	_eon
ern	3	57	3836	2	_ern
fan	6	71	5886	2	_fan
feal	7	139	4042	2	feal
fear	7	53	3779	2	fear
feat	7	64	5822	2	feat
fen	6	68	5135	2	fe_n
fern	7	61	2932	2	fern
flan	7	61	3418	2	flan
gaen	5	73	2960	2	gaen
gan	4	80	6013	2	_gan
gear	5	59	3497	2	gear
gen	4	59	5051	2	ge_n
glean	6	58	1820	2	glean
gran	5	63	3501	2	gran
guan	5	53	2558	2	guan
haen	7	62	2945	2	haen
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
hen	6	75	5527	2	he_n
hern	7	61	3489	2	hern
hewn	10	67	1985	2	hewn
hwan	10	57	1689	2	hwan
jeans	12	60	2211	2	jeans
jeon	11	68	2144	2	jeon
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
keen	8	48	3041	2	keen
ken	7	63	4398	2	ke_n
kern	8	53	2621	2	kern
khan	11	58	1914	2	khan
koan	8	54	2503	2	koan
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
leans	5	55	3625	2	leans
leant	5	67	3778	2	leant
leap	6	60	3268	2	leap
lear	4	70	4595	2	lear
learn	5	53	2266	2	learn
leas	4	59	5418	2	leas
leman	7	56	2260	2	leman
loan	4	74	3645	2	loan
man	5	74	6587	2	_man
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
means	7	58	3123	2	means
meant	7	65	3721	2	meant
meany	10	46	2048	2	meany
meat	6	63	5960	2	meat
men	5	92	5285	2	me_n
moan	6	58	3202	2	moan
naan	4	76	2193	2	naan
nan	3	78	5488	2	_nan
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neat	4	63	5678	2	neat
neon	4	70	2642	2	neon
obeah	10	3	899	2	obeah
ocean	7	12	1296	2	ocean
paean	7	72	2272	2	paean
pan	5	84	6645	2	_pan
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
peans	7	54	3764	2	peans
pear	6	97	4523	2	pear
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
pecan	9	19	1903	2	pecan
peen	6	59	3808	2	peen
pein	6	58	3494	2	pein
pekan	11	16	1397	2	pekan
pen	5	65	5884	2	pe_n
peon	6	56	3524	2	peon
pian	6	61	3609	2	pian
plan	6	58	3394	2	plan
quean	14	36	1284	2	quean
ran	3	82	6662	2	_ran
read	5	59	4253	2	read
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rear	4	56	4455	2	rear
redan	6	61	2501	2	redan
rein	4	60	4089	2	rein
reman	7	57	3015	2	reman
reran	5	73	2910	2	reran
rewan	8	56	2366	2	rewan
roan	4	72	3420	2	roan
scan	6	55	3045	2	scan
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
sedan	6	56	2042	2	sedan
seen	4	69	4312	2	seen
sen	3	60	5852	2	se_n
sewan	8	59	2129	2	sewan
sewn	7	61	2433	2	sewn
skean	9	44	1562	2	skean
span	6	52	3466	2	span
spean	7	46	2051	2	spean
swan	7	66	3131	2	swan
tan	3	71	6757	2	_tan
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tear	4	52	4288	2	tear
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
teen	4	59	3820	2	teen
ten	3	58	5611	2	te_n
tern	4	61	3480	2	tern
than	7	61	2877	2	than
ulan	4	65	2739	2	ulan
van	6	62	4633	2	_van
veal	7	69	3681	2	veal
vegan	9	51	1415	2	vegan
vein	7	56	2575	2	vein
vena	7	61	2629	2	vena
wan	6	67	6194	2	_wan
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
weans	8	53	2674	2	weans
wear	7	58	3672	2	wear
ween	7	58	3546	2	ween
wen	6	62	4960	2	we_n
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yeans	8	66	2488	2	yeans
year	7	65	3425	2	year
yearn	8	63	1643	2	yearn
yeas	7	86	3842	2	yeas
yen	6	68	4738	2	ye_n
yuan	7	61	2001	2	yuan
zeal	13	55	3033	2	zeal
zein	13	56	2060	2	zein

Search took 3 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.563	317390.8
2	DLD Change Limit	29872	333	1.796	16632.5
3	Display Results	333	333	0.156	2134.6
	(SQL Overall)	178691	333	2.515	71050.1