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

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

312 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
beans	7	57	3469	(None)
bans	6	65	5514	1	b_ans
beads	8	54	2950	1	beads
beaks	11	53	2662	1	beaks
beams	9	53	2817	1	beams
bean	6	64	4386	1	bean_
beano	7	54	2155	1	beano
beanos	8	55	1651	1	beanos
bears	7	57	3904	1	bears
beats	7	60	4224	1	beats
beaus	7	51	2711	1	beaus
bens	6	59	4570	1	be_ns
brans	7	54	3743	1	brans
deans	6	61	3139	1	deans
jeans	12	60	2211	1	jeans
leans	5	55	3625	1	leans
means	7	58	3123	1	means
peans	7	54	3764	1	peans
weans	8	53	2674	1	weans
yeans	8	66	2488	1	yeans
aeons	5	76	2465	2	aeons
alans	5	56	3617	2	alans
azans	14	65	1688	2	azans
baals	7	61	2270	2	baals
baas	6	68	4467	2	b_aas
bads	7	70	4886	2	b_ads
bags	7	66	4550	2	b_ags
bals	6	63	5404	2	b_als
bams	8	70	4445	2	b_ams
ban	5	83	6684	2	b_an_
band	7	67	4091	2	b_and
bands	8	52	3342	2	b_ands
bane	6	52	5043	2	b_ane
banes	7	49	4558	2	b_anes
bang	7	48	3700	2	b_ang
bangs	8	56	2777	2	b_angs
bani	6	53	3496	2	b_ani
bank	10	58	3575	2	b_ank
banks	11	55	2790	2	b_anks
banns	7	53	2123	2	banns
baps	8	60	4084	2	b_aps
barns	7	63	3514	2	barns
bars	6	65	6409	2	b_ars
bas	5	86	8175	2	b_a_s
bass	6	61	4678	2	b_ass
bats	6	69	6233	2	b_ats
bays	9	71	4391	2	b_ays
beach	12	46	2389	2	beach
beacons	11	4	1073	2	beacons
bead	7	59	3792	2	bea_d
beady	11	47	1992	2	beady
beak	10	65	3438	2	bea_k
beaky	14	61	1802	2	beaky
beam	8	69	3923	2	bea_m
beamy	12	62	1857	2	beamy
beaned	9	56	2147	2	beaned
beanie	8	36	1859	2	beanie
beanies	9	38	2109	2	beanies
bear	6	68	4464	2	bea_r
beard	8	60	2496	2	beard
beards	9	41	1667	2	beards
beast	7	63	3864	2	beast
beasts	8	45	1972	2	beasts
beat	6	61	6830	2	bea_t
beau	6	61	3727	2	bea_u
beaut	7	51	3521	2	beaut
beauts	8	60	1528	2	beauts
beaux	14	65	1321	2	beaux
becaps	12	38	1140	2	becaps
becks	13	55	2201	2	becks
bedamns	12	3	573	2	bedamns
bedpans	12	3	717	2	bedpans
beds	7	59	3778	2	be_ds
beefs	10	56	1856	2	beefs
been	6	53	3578	2	been_
beeps	9	53	2097	2	beeps
beers	7	56	2839	2	beers
bees	6	54	5338	2	be_es
beets	7	61	3144	2	beets
began	8	63	1957	2	began_
begins	9	44	1530	2	begins
begs	7	57	3383	2	be_gs
being	8	49	2050	2	being
beings	9	46	1303	2	beings
belays	11	43	1385	2	belays
bells	7	64	3216	2	bells
belons	8	41	1941	2	belons
bels	6	61	4249	2	be_ls
belts	7	59	3116	2	belts
bemas	9	64	2428	2	bemas
bemeans	11	4	874	2	bemeans
bemoans	11	3	825	2	bemoans
ben	5	65	5492	2	be_n_
bend	7	64	3526	2	be_nd
bends	8	56	2897	2	bends
bene	6	64	3949	2	be_ne
benes	7	55	3623	2	benes
benne	7	65	2112	2	benne
bennes	8	60	1901	2	bennes
benni	7	47	1536	2	benni
bennis	8	43	1480	2	bennis
benny	10	52	1736	2	benny
bent	6	77	5991	2	be_nt
bents	7	60	3369	2	bents
bergs	8	47	1804	2	bergs
berks	11	54	2312	2	berks
berms	9	53	2366	2	berms
bes	5	65	5743	2	be__s
beses	7	58	3072	2	beses
bests	7	59	3261	2	bests
betas	7	55	2876	2	betas
beths	10	55	1922	2	beths
betons	8	49	1955	2	betons
bets	6	70	5144	2	be_ts
beys	9	138	2955	2	be_ys
bezant	17	8	1454	2	bezant
bezants	18	7	734	2	bezants
bhang	11	55	1292	2	bhang
bhangs	12	44	966	2	bhangs
bias	6	47	3816	2	bia_s
bins	6	65	4825	2	b_ins
blabs	9	56	1963	2	blabs
blahs	10	56	1651	2	blahs
blains	8	45	1637	2	blains
blams	9	50	2385	2	blams
bland	8	53	2045	2	bland
blank	11	54	1855	2	blank
blanks	12	41	1289	2	blanks
blats	7	51	3250	2	blats
blaws	10	56	2046	2	blaws
bleaks	12	51	1243	2	bleaks
blears	8	51	1645	2	blears
bleats	8	55	1861	2	bleats
boars	7	52	2960	2	boars
boas	6	61	5083	2	boa_s
boats	7	56	3515	2	boats
bogans	9	57	1481	2	bogans
boons	7	50	3191	2	boons
brads	8	55	2829	2	brads
braes	7	57	3505	2	braes
brags	8	56	2510	2	brags
brains	8	51	2547	2	brains
bran	6	57	4038	2	bran_
brand	8	51	2449	2	brand
brands	9	51	1894	2	brands
brank	11	52	2228	2	brank
branks	12	48	1738	2	branks
brant	7	47	4217	2	brant
brants	8	57	2305	2	brants
bras	6	57	4645	2	bra_s
brass	7	54	2802	2	brass
brats	7	53	3601	2	brats
brawns	11	56	1408	2	brawns
braws	10	64	2519	2	braws
brays	10	67	2311	2	brays
breads	9	54	1920	2	breads
breaks	12	48	1642	2	breaks
breams	10	48	1504	2	breams
brens	7	58	2336	2	brens
brins	7	55	3397	2	brins
bunas	7	51	2657	2	bunas
bunns	7	47	1829	2	bunns
buns	6	62	4372	2	b_uns
burans	8	50	1930	2	burans
burns	7	49	2678	2	burns
bwana	10	3	1024	2	bwana
bwanas	11	5	744	2	bwanas
cans	6	50	5085	2	_cans
clans	7	50	3101	2	clans
cleans	8	58	1705	2	cleans
cyans	10	57	1481	2	cyans
dans	5	67	4815	2	_dans
deads	7	57	2691	2	deads
deals	6	54	3534	2	deals
dean	5	60	3948	2	dean_
dears	6	57	3688	2	dears
dedans	8	59	1507	2	dedans
dens	5	59	4507	2	de_ns
dewans	10	52	1514	2	dewans
earns	5	59	2756	2	_earns
ears	4	63	5659	2	_ears
eats	4	70	5487	2	_eats
ebons	7	43	1609	2	ebons
elans	5	55	2775	2	elans
ens	3	72	4592	2	_e_ns
eons	4	66	3871	2	_eons
erns	4	54	2823	2	_erns
fans	7	62	4737	2	_fans
fears	8	48	2939	2	fears
feats	8	64	3275	2	feats
fens	7	61	3976	2	fe_ns
ferns	8	52	2008	2	ferns
flans	8	53	2797	2	flans
gears	6	46	2869	2	gears
gens	5	57	4007	2	ge_ns
glans	6	51	2583	2	glans
gleans	7	50	1474	2	gleans
grans	6	48	3254	2	grans
guans	6	44	1944	2	guans
heads	9	51	2711	2	heads
heals	8	57	3346	2	heals
heaps	10	52	2322	2	heaps
hears	8	67	3737	2	hears
heats	8	58	3840	2	heats
hens	7	56	4257	2	he_ns
herns	8	48	2558	2	herns
jean	11	66	2928	2	jean_
keas	8	63	3709	2	kea_s
keens	9	57	2118	2	keens
kens	8	54	3523	2	ke_ns
kerns	9	47	1956	2	kerns
khans	12	46	1517	2	khans
koans	9	58	1862	2	koans
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
lean	4	63	4524	2	lean_
leant	5	67	3778	2	leant
leaps	7	55	2293	2	leaps
learns	6	55	1374	2	learns
lears	5	59	3873	2	lears
leas	4	59	5418	2	lea_s
lemans	8	53	1639	2	lemans
lens	4	61	4649	2	le_ns
loans	5	60	2646	2	loans
mans	6	63	5455	2	_mans
meads	8	54	2532	2	meads
meals	7	59	3338	2	meals
mean	6	55	3809	2	mean_
meant	7	65	3721	2	meant
meany	10	46	2048	2	meany
meats	7	50	3405	2	meats
moans	7	46	2437	2	moans
naans	5	58	1525	2	naans
nans	4	61	3940	2	_nans
neaps	7	56	1832	2	neaps
nears	5	55	2942	2	nears
neats	5	59	3190	2	neats
neons	5	58	1868	2	neons
obeahs	11	3	586	2	obeahs
oceans	8	12	1100	2	oceans
paeans	8	51	1826	2	paeans
pans	6	58	5573	2	_pans
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
pean	6	61	4717	2	pean_
pears	7	51	3861	2	pears
peas	6	57	5506	2	pea_s
peats	7	61	4019	2	peats
pecans	10	15	1583	2	pecans
peens	7	64	2819	2	peens
peins	7	61	2806	2	peins
pekans	12	17	1055	2	pekans
pens	6	56	4964	2	pe_ns
peons	7	53	2718	2	peons
pians	7	51	2696	2	pians
plans	7	57	3127	2	plans
queans	15	31	1075	2	queans
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rears	5	47	3965	2	rears
redans	7	54	2102	2	redans
reins	5	62	3456	2	reins
remans	8	48	2300	2	remans
roans	5	49	2644	2	roans
sans	4	51	5336	2	_sans
scans	7	46	2510	2	scans
seals	5	48	3970	2	seals
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
sedans	7	48	1609	2	sedans
sewans	9	52	1590	2	sewans
skeans	10	45	1291	2	skeans
spans	7	45	2873	2	spans
speans	8	54	1714	2	speans
swans	8	46	2501	2	swans
tans	4	61	5482	2	_tans
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
tears	5	54	3646	2	tears
teas	4	58	5149	2	tea_s
teats	5	56	3681	2	teats
teens	5	62	2748	2	teens
tens	4	56	4741	2	te_ns
terns	5	52	2687	2	terns
trans	5	49	3304	2	trans
ulans	5	49	2130	2	ulans
vans	7	62	3673	2	_vans
veals	8	49	2619	2	veals
vegans	10	39	1085	2	vegans
veins	8	46	2049	2	veins
wans	7	64	5227	2	_wans
weals	8	54	2874	2	weals
wean	7	57	3435	2	wean_
wears	8	60	3030	2	wears
weens	8	52	2405	2	weens
wens	7	63	3793	2	we_ns
yeahs	11	52	1455	2	yeahs
yean	7	58	3458	2	yean_
yearns	9	50	954	2	yearns
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
yens	7	58	3226	2	ye_ns
yuans	8	46	1332	2	yuans
zeals	14	53	2085	2	zeals
zeins	14	47	1539	2	zeins

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	53800	0.296	603685.8
2	DLD Change Limit	53800	312	1.720	31279.1
3	Display Results	312	312	0.076	4105.3
	(SQL Overall)	178691	312	2.092	85416.3