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

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

326 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
bear	6	68	4464	(None)
bar	5	80	7055	1	b_ar
bead	7	59	3792	1	bead
beak	10	65	3438	1	beak
beam	8	69	3923	1	beam
bean	6	64	4386	1	bean
beard	8	60	2496	1	beard
bears	7	57	3904	1	bears
beat	6	61	6830	1	beat
beau	6	61	3727	1	beau
beer	6	56	3599	1	beer
blear	7	59	1868	1	blear
boar	6	61	3429	1	boar
dear	5	53	4360	1	dear
ear	3	68	6788	1	_ear
fear	7	53	3779	1	fear
gear	5	59	3497	1	gear
hear	7	61	4388	1	hear
lear	4	70	4595	1	lear
near	4	52	3650	1	near
pear	6	97	4523	1	pear
rear	4	56	4455	1	rear
sear	4	73	5384	1	sear
tear	4	52	4288	1	tear
wear	7	58	3672	1	wear
year	7	65	3425	1	year
abeam	9	3	1653	2	abeam
afar	7	67	2078	2	afar
agar	5	87	2641	2	agar
ajar	11	62	1770	2	ajar
alar	4	63	4007	2	alar
anear	5	54	2032	2	anear
ar	2	113	7938	2	__ar
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
ban	5	83	6684	2	b_an
bap	7	64	5584	2	b_ap
barb	8	52	4006	2	b_arb
bard	7	56	4886	2	b_ard
bare	6	54	6052	2	b_are
barf	9	58	4441	2	b_arf
bark	10	62	4215	2	b_ark
barm	8	67	3960	2	b_arm
barn	6	64	4464	2	b_arn
bars	6	65	6409	2	b_ars
bas	5	86	8175	2	b_as
bat	5	109	8895	2	b_at
bay	8	96	6164	2	b_ay
bazar	16	38	1600	2	bazar
be	4	79	4894	2	be__
beach	12	46	2389	2	beach
beader	9	46	2379	2	beader
beads	8	54	2950	2	beads
beady	11	47	1992	2	beady
beaker	12	55	2069	2	beaker
beaks	11	53	2662	2	beaks
beaky	14	61	1802	2	beaky
beams	9	53	2817	2	beams
beamy	12	62	1857	2	beamy
beano	7	54	2155	2	beano
beans	7	57	3469	2	beans
beards	9	41	1667	2	beards
bearer	8	53	2391	2	bearer
beast	7	63	3864	2	beast
beater	8	47	2939	2	beater
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
beaut	7	51	3521	2	beaut
beaux	14	65	1321	2	beaux
beaver	11	48	1925	2	beaver
becap	11	43	1505	2	becap
beck	12	62	2657	2	beck
bed	6	79	5062	2	be_d
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
been	6	53	3578	2	been
beep	8	59	3121	2	beep
beers	7	56	2839	2	beers
beery	10	52	2012	2	beery
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
beg	6	59	4413	2	be_g
began	8	63	1957	2	began
begat	8	66	2972	2	begat
beggar	10	32	822	2	beggar
begs	7	57	3383	2	begs
bel	5	71	4846	2	be_l
belay	10	50	2152	2	belay
bell	6	62	3718	2	bell
bels	6	61	4249	2	bels
belt	6	57	5403	2	belt
bema	8	58	2525	2	bema
bemas	9	64	2428	2	bemas
ben	5	65	5492	2	be_n
bend	7	64	3526	2	bend
bene	6	64	3949	2	bene
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
berry	10	45	2177	2	berry
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
bets	6	70	5144	2	bets
bevor	10	15	1081	2	bevor
bevy	12	71	1522	2	bevy
beware	11	3	1371	2	beware
bey	8	66	4542	2	be_y
beys	9	138	2955	2	beys
bezoar	17	3	691	2	bezoar
bias	6	47	3816	2	bias
bier	6	55	3183	2	bier
birr	6	60	2236	2	birr
blab	8	66	2913	2	blab
blae	6	61	3464	2	blae
blah	9	86	2506	2	blah
blam	8	61	3170	2	blam
blare	7	58	2623	2	blare
blat	6	65	5095	2	blat
blaw	9	70	2672	2	blaw
bleak	11	59	1538	2	bleak
blears	8	51	1645	2	blears
bleary	11	51	1255	2	bleary
bleat	7	57	3700	2	bleat
blur	6	60	2053	2	blur
boa	5	69	5403	2	boa_
board	8	55	2300	2	board
boars	7	52	2960	2	boars
boart	7	88	3593	2	boart
boas	6	61	5083	2	boas
boat	6	63	6031	2	boat
bolar	7	51	2347	2	bolar
boor	6	61	3068	2	boor
bora	6	61	4163	2	bora
boyar	10	60	1376	2	boyar
bra	5	63	3946	2	bra_
brad	7	52	3434	2	brad
brae	6	56	3911	2	brae
brag	7	52	2972	2	brag
bran	6	57	4038	2	bran
bras	6	57	4645	2	bras
brat	6	60	5554	2	brat
braw	9	48	2956	2	braw
bray	9	52	3290	2	bray
bread	8	55	2311	2	bread
break	11	53	1940	2	break
bream	9	51	2181	2	bream
briar	7	57	1815	2	briar
brr	5	69	2192	2	b_rr
brrr	6	53	1229	2	brrr
buhr	9	53	1538	2	buhr
bur	5	57	4469	2	b_ur
bura	6	61	3953	2	bura
burr	6	56	3123	2	burr
car	5	91	6556	2	_car
cedar	8	40	1432	2	cedar
char	9	51	3215	2	char
clear	7	62	1905	2	clear
czar	15	60	1313	2	czar
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deair	6	58	1719	2	deair
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
debar	8	55	1786	2	debar
deer	5	67	3902	2	deer
denar	6	52	2329	2	denar
dewar	9	58	1773	2	dewar
drear	6	50	1690	2	drear
earl	4	58	3814	2	_earl
earn	4	67	3755	2	_earn
ears	4	63	5659	2	_ears
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
er	2	83	4514	2	_e_r
era	3	57	4150	2	_era
err	3	56	2653	2	_err
far	6	77	6260	2	_far
feal	7	139	4042	2	feal
fears	8	48	2939	2	fears
feat	7	64	5822	2	feat
fer	6	66	4612	2	fe_r
feuar	8	3	1024	2	feuar
fiar	7	64	2733	2	fiar
gar	4	72	5990	2	_gar
gears	6	46	2869	2	gears
gnar	5	60	2138	2	gnar
guar	5	69	2329	2	guar
haar	7	73	2349	2	haar
head	8	71	3717	2	head
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
heard	9	52	2275	2	heard
hears	8	67	3737	2	hears
heart	8	54	4074	2	heart
heat	7	70	6142	2	heat
heir	7	75	2380	2	heir
her	6	65	4781	2	he_r
hoar	7	67	2916	2	hoar
izar	13	66	1601	2	izar
jar	10	76	4615	2	_jar
jean	11	66	2928	2	jean
jeer	11	54	2646	2	jeer
kbar	10	65	1465	2	kbar
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
kebar	11	51	1353	2	kebar
keir	8	62	1787	2	keir
knar	8	58	1872	2	knar
kyar	11	69	1684	2	kyar
lar	3	79	6753	2	_lar
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
learn	5	53	2266	2	learn
lears	5	59	3873	2	lears
leary	8	59	2738	2	leary
leas	4	59	5418	2	leas
leer	4	62	3935	2	leer
lehr	7	55	1494	2	lehr
liar	4	72	2968	2	liar
maar	6	60	2506	2	maar
mar	5	79	6595	2	_mar
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3809	2	mean
meat	6	63	5960	2	meat
neap	6	69	2701	2	neap
nears	5	55	2942	2	nears
neat	4	63	5678	2	neat
oar	3	70	5795	2	_oar
obeah	10	3	899	2	obeah
osar	4	68	2095	2	osar
par	5	74	6702	2	_par
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
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
peart	7	64	4075	2	peart
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
peer	6	62	3835	2	peer
per	5	63	5309	2	pe_r
read	5	59	4253	2	read
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rearm	7	59	2356	2	rearm
rears	5	47	3965	2	rears
rebar	7	54	2019	2	rebar
roar	4	63	2857	2	roar
scar	6	64	3420	2	scar
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sears	5	47	4491	2	sears
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
seer	4	55	4704	2	seer
ser	3	67	5240	2	se_r
sera	4	61	4139	2	sera
sewar	8	54	2109	2	sewar
shear	8	54	2483	2	shear
smear	7	44	1639	2	smear
soar	4	68	3867	2	soar
spar	6	54	3330	2	spar
spear	7	58	2106	2	spear
star	4	80	3776	2	star
swear	8	53	1685	2	swear
tar	3	75	7069	2	_tar
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tears	5	54	3646	2	tears
teary	8	51	2405	2	teary
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
tsar	4	78	1980	2	tsar
tzar	13	63	1537	2	tzar
unbear	8	8	916	2	unbear
upbear	10	9	649	2	upbear
var	6	61	4833	2	_var
veal	7	69	3681	2	veal
veer	7	62	2957	2	veer
velar	8	58	1763	2	velar
vera	7	68	2884	2	vera
war	6	72	6242	2	_war
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
wean	7	57	3435	2	wean
wears	8	60	3030	2	wears
weary	11	56	2061	2	weary
weer	7	55	3509	2	weer
weir	7	60	1992	2	weir
yar	6	72	5383	2	_yar
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
yearn	8	63	1643	2	yearn
years	8	45	2767	2	years
yeas	7	86	3842	2	yeas
zeal	13	55	3033	2	zeal

Search took 1 second 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.063	2836365.1
2	DLD Change Limit	29872	326	0.843	35435.3
3	Display Results	326	326	0.076	4289.5
	(SQL Overall)	178691	326	0.982	181966.4