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

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

372 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
bra	5	63	3946	(None)
ba	4	99	6234	1	b_a
baa	5	106	5042	1	baa
bar	5	80	7055	1	bar
boa	5	69	5403	1	boa
bora	6	61	4163	1	bora
brad	7	52	3434	1	brad
brae	6	56	3911	1	brae
brag	7	52	2972	1	brag
bran	6	57	4038	1	bran
bras	6	57	4645	1	bras
brat	6	60	5554	1	brat
braw	9	48	2956	1	braw
bray	9	52	3290	1	bray
bro	5	62	3660	1	bro
brr	5	69	2192	1	brr
bura	6	61	3953	1	bura
era	3	57	4150	1	era
ora	3	72	5083	1	ora
aa	2	191	7995	2	_aa
aba	5	128	5095	2	aba
abba	8	105	2264	2	abba
abri	6	55	2221	2	abri
aga	4	104	4723	2	aga
aha	6	112	4664	2	aha
ala	3	124	6360	2	ala
ama	5	108	5330	2	ama
ana	3	95	5982	2	ana
ar	2	113	7938	2	ar_
arak	8	69	2957	2	arak
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
are	3	78	7457	2	are
area	4	58	4339	2	area
arf	6	74	5337	2	arf
aria	4	62	4542	2	aria
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
aura	4	58	3625	2	aura
ava	6	101	3932	2	ava
awa	6	119	3967	2	awa
baal	6	70	3311	2	baal
baas	6	68	4467	2	baas
baba	8	88	2834	2	baba
bad	6	77	6315	2	bad
bag	6	70	5922	2	bag
bah	8	77	5535	2	bah
bal	5	66	6272	2	bal
bam	7	85	6014	2	bam
ban	5	83	6683	2	ban
bap	7	64	5584	2	bap
barb	8	52	4006	2	barb
barca	9	13	1943	2	barca
bard	7	56	4886	2	bard
bare	6	54	6052	2	bare
barf	9	58	4440	2	barf
bark	10	62	4215	2	bark
barm	8	67	3960	2	barm
barn	6	64	4464	2	barn
bars	6	65	6409	2	bars
bas	5	86	8175	2	bas
bat	5	109	8895	2	bat
bay	8	96	6164	2	bay
be	4	79	4894	2	b_e
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
bear	6	68	4464	2	bear
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
bed	6	79	5062	2	bed
bee	5	62	6240	2	bee
beg	6	59	4413	2	beg
bel	5	71	4846	2	bel
bema	8	58	2525	2	bema
ben	5	65	5492	2	ben
berg	7	54	2554	2	berg
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
bes	5	65	5743	2	bes
bet	5	83	7667	2	bet
beta	6	62	3413	2	beta
bey	8	66	4542	2	bey
bi	4	80	4646	2	b_i
bias	6	47	3815	2	bias
bib	7	70	4592	2	bib
bid	6	77	5178	2	bid
big	6	73	4571	2	big
bima	8	67	2382	2	bima
bin	5	66	5863	2	bin
bio	5	78	4607	2	bio
bird	7	61	2831	2	bird
birk	10	63	2685	2	birk
birl	6	58	3046	2	birl
biro	6	61	3120	2	biro
birr	6	60	2235	2	birr
bis	5	68	6065	2	bis
bit	5	70	7089	2	bit
biz	14	79	3935	2	biz
blab	8	66	2913	2	blab
blae	6	61	3464	2	blae
blah	9	86	2506	2	blah
blam	8	61	3170	2	blam
blat	6	65	5095	2	blat
blaw	9	70	2672	2	blaw
bo	4	109	5757	2	b_o
boar	6	61	3429	2	boar
boas	6	61	5083	2	boas
boat	6	63	6031	2	boat
bob	7	67	5566	2	bob
bod	6	70	5554	2	bod
bog	6	78	5241	2	bog
bola	6	60	3556	2	bola
boo	5	81	6366	2	boo
bop	7	75	4948	2	bop
boral	7	58	3170	2	boral
boras	7	59	3830	2	boras
borax	14	59	1872	2	borax
bore	6	60	5133	2	bore
bork	10	69	3382	2	bork
born	6	73	3841	2	born
bort	6	59	6096	2	bort
bos	5	79	6681	2	bos
bot	5	96	8040	2	bot
bota	6	62	3650	2	bota
bow	8	70	5190	2	bow
box	12	101	4234	2	box
boy	8	77	5356	2	boy
brace	9	56	2927	2	brace
brach	12	61	2330	2	brach
bract	9	63	3272	2	bract
brads	8	55	2829	2	brads
braes	7	57	3505	2	braes
brags	8	56	2510	2	brags
braid	8	58	2226	2	braid
brail	7	55	2555	2	brail
brain	7	62	2938	2	brain
brake	11	60	2534	2	brake
braky	14	50	1581	2	braky
brand	8	51	2449	2	brand
brank	11	52	2228	2	brank
brans	7	54	3743	2	brans
brant	7	47	4217	2	brant
brash	10	62	2156	2	brash
brass	7	54	2802	2	brass
brats	7	53	3601	2	brats
brava	10	64	1479	2	brava
brave	10	49	2550	2	brave
bravi	10	47	1575	2	bravi
bravo	10	52	1434	2	bravo
brawl	10	62	1796	2	brawl
brawn	10	60	1856	2	brawn
braws	10	64	2519	2	braws
braxy	17	54	1089	2	braxy
brays	10	67	2311	2	brays
braza	16	52	1425	2	braza
braze	16	54	2345	2	braze
bread	8	55	2311	2	bread
break	11	53	1940	2	break
bream	9	51	2181	2	bream
bred	7	51	3097	2	bred
bree	6	72	4126	2	bree
bren	6	56	2956	2	bren
brew	9	50	2356	2	brew
briar	7	57	1815	2	briar
brie	6	58	3790	2	brie
brig	7	65	2803	2	brig
brim	8	56	2937	2	brim
brin	6	70	3819	2	brin
brio	6	54	3249	2	brio
bris	6	55	3961	2	bris
brit	6	63	5015	2	brit
broad	8	48	1769	2	broad
broo	6	51	2982	2	broo
bros	6	56	3566	2	bros
brow	9	72	2844	2	brow
brrr	6	53	1229	2	brrr
brut	6	65	3796	2	brut
brux	13	63	1527	2	brux
bub	7	63	4397	2	bub
bud	6	70	4127	2	bud
bug	6	53	4074	2	bug
bum	7	53	4269	2	bum
bun	5	63	4814	2	bun
buna	6	47	3072	2	buna
bur	5	57	4469	2	bur
buran	7	52	2530	2	buran
buras	7	47	3629	2	buras
burb	8	53	3467	2	burb
burd	7	55	3426	2	burd
burg	7	49	3036	2	burg
burka	11	46	1769	2	burka
burl	6	49	3718	2	burl
burn	6	56	3642	2	burn
burp	8	50	2888	2	burp
burqa	16	50	1309	2	burqa
burr	6	56	3123	2	burr
burs	6	58	4742	2	burs
bursa	7	49	2152	2	bursa
bury	9	56	3359	2	bury
bus	5	69	5097	2	bus
but	5	59	6302	2	but
buy	8	64	3654	2	buy
by	7	75	2923	2	b_y
bye	8	61	3459	2	bye
byre	9	50	2385	2	byre
byrl	9	57	1601	2	byrl
bys	8	52	2946	2	bys
car	5	91	6556	2	car
cobra	9	52	1440	2	cobra
crab	8	57	2767	2	crab
crag	7	56	2530	2	crag
cram	8	56	3549	2	cram
crap	8	57	3184	2	crap
craw	9	77	2526	2	craw
cru	5	71	2956	2	cru
cry	8	97	2624	2	cry
dobra	8	50	1310	2	dobra
drab	7	62	2645	2	drab
drag	6	48	2505	2	drag
dram	7	58	3200	2	dram
drat	5	62	4783	2	drat
draw	8	56	2301	2	draw
dray	8	54	2809	2	dray
dry	7	65	2603	2	dry
dura	5	52	3211	2	dura
ear	3	68	6788	2	ear
er	2	83	4514	2	er_
eras	4	54	4150	2	eras
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ern	3	57	3835	2	ern
err	3	56	2653	2	err
ers	3	60	4628	2	ers
eta	3	58	3419	2	eta
eyra	7	62	1755	2	eyra
fa	5	101	4845	2	_fa
far	6	77	6260	2	far
fora	7	59	3739	2	fora
frae	7	53	3047	2	frae
frag	8	51	2627	2	frag
frap	9	59	2581	2	frap
frat	7	56	4854	2	frat
fray	10	54	2890	2	fray
fro	6	55	3064	2	fro
fry	9	62	2650	2	fry
gar	4	72	5990	2	gar
goa	4	73	4380	2	goa
grab	7	54	2761	2	grab
grad	6	68	2986	2	grad
gram	7	70	3458	2	gram
gran	5	63	3501	2	gran
grat	5	56	5128	2	grat
gray	8	53	2989	2	gray
ha	5	102	5994	2	_ha
hora	7	61	3655	2	hora
ire	3	69	4317	2	ire
irk	7	64	2636	2	irk
jar	10	76	4615	2	jar
jura	11	60	2489	2	jura
ka	6	91	4508	2	_ka
kbar	10	65	1465	2	kbar
kea	7	65	4091	2	kea
koa	7	67	3777	2	koa
kora	8	64	3155	2	kora
la	2	192	6163	2	_la
labra	7	54	1546	2	labra
lar	3	79	6753	2	lar
lea	3	76	6018	2	lea
libra	7	47	1242	2	libra
lira	4	69	2868	2	lira
ma	4	100	6065	2	_ma
mar	5	79	6594	2	mar
mara	6	74	4456	2	mara
mbira	9	7	795	2	mbira
moa	5	72	4918	2	moa
mora	6	66	4127	2	mora
mura	6	56	3329	2	mura
na	2	86	5248	2	_na
oar	3	70	5795	2	oar
oba	5	75	3155	2	oba
obia	6	79	2310	2	obia
oca	5	67	3173	2	oca
oda	4	81	3304	2	oda
oka	7	69	2680	2	oka
okra	8	64	1357	2	okra
or	2	73	5473	2	or_
orad	5	60	3169	2	orad
oral	4	76	3812	2	oral
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
orca	6	55	2277	2	orca
ore	3	66	6183	2	ore
orra	4	61	2072	2	orra
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
ova	6	68	2379	2	ova
pa	4	104	5648	2	_pa
par	5	74	6702	2	par
para	6	52	4217	2	para
pea	5	66	5724	2	pea
pia	5	68	4803	2	pia
pram	8	57	3349	2	pram
prao	6	62	2902	2	prao
prat	6	59	5204	2	prat
prau	6	65	2947	2	prau
pray	9	63	3153	2	pray
pro	5	58	3726	2	pro
proa	6	62	2996	2	proa
pry	8	57	2805	2	pry
pya	8	70	2375	2	pya
qua	12	48	2197	2	qua
rad	4	76	6200	2	_rad
rag	4	57	6132	2	_rag
rah	6	80	5240	2	_rah
rai	3	76	5822	2	_rai
raj	10	57	4022	2	_raj
ram	5	68	6727	2	_ram
ran	3	82	6661	2	_ran
rap	5	62	6196	2	_rap
ras	3	75	7539	2	_ras
rat	3	78	9274	2	_rat
raw	6	72	5225	2	_raw
rax	10	84	4572	2	_rax
ray	6	63	6199	2	_ray
re	2	61	5374	2	_re
ria	3	67	4550	2	ria
rya	6	76	2201	2	rya
sabra	7	53	1785	2	sabra
sea	3	61	6129	2	sea
sera	4	61	4139	2	sera
sha	6	98	3778	2	sha
ska	7	69	2586	2	ska
sora	4	57	4691	2	sora
spa	5	57	3081	2	spa
sri	3	56	3400	2	sri
sura	4	57	4029	2	sura
ta	2	116	6245	2	_ta
tar	3	75	7069	2	tar
tea	3	73	5332	2	tea
tora	4	75	4599	2	tora
trad	5	56	3091	2	trad
tram	6	70	3455	2	tram
trap	6	75	3280	2	trap
tray	7	76	3259	2	tray
try	6	65	2967	2	try
twa	6	77	2164	2	twa
umbra	9	4	850	2	umbra
urb	5	57	3110	2	urb
urd	4	64	2704	2	urd
urea	4	65	2805	2	urea
urn	3	57	3146	2	urn
urp	5	64	2639	2	urp
ursa	4	41	1690	2	ursa
uta	3	74	2558	2	uta
var	6	61	4833	2	var
vara	7	55	3088	2	vara
vera	7	68	2884	2	vera
via	6	56	3624	2	via
war	6	72	6242	2	war
wha	9	64	2207	2	wha
wrap	9	68	2197	2	wrap
wry	9	65	2470	2	wry
ya	5	102	5150	2	_ya
yar	6	72	5383	2	yar
yea	6	64	4575	2	yea
za	11	149	3920	2	_za
zebra	16	3	788	2	zebra
zoa	12	85	2999	2	zoa

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	14084	0.060	2978183.3
2	DLD Change Limit	14084	372	0.440	32009.1
3	Display Results	372	372	0.076	4894.7
	(SQL Overall)	178691	372	0.576	310227.4