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

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

331 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
brat	6	60	5554	(None)
bat	5	109	8895	1	b_at
beat	6	61	6830	1	beat
blat	6	65	5095	1	blat
boat	6	63	6031	1	boat
bra	5	63	3946	1	bra_
bract	9	63	3272	1	bract
brad	7	52	3434	1	brad
brae	6	56	3911	1	brae
brag	7	52	2972	1	brag
bran	6	57	4038	1	bran
brant	7	47	4217	1	brant
bras	6	57	4645	1	bras
brats	7	53	3601	1	brats
braw	9	48	2956	1	braw
bray	9	52	3290	1	bray
brit	6	63	5015	1	brit
brut	6	65	3796	1	brut
drat	5	62	4783	1	drat
frat	7	56	4854	1	frat
grat	5	56	5128	1	grat
prat	6	59	5204	1	prat
rat	3	78	9274	1	_rat
arak	8	69	2957	2	arak
arhat	8	3	2709	2	arhat
art	3	86	7914	2	ar_t
at	2	123	9340	2	__at
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
baht	9	67	4001	2	baht
bait	6	65	5600	2	bait
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
bar	5	80	7055	2	b_ar
barb	8	52	4006	2	barb
bard	7	56	4886	2	bard
bare	6	54	6052	2	bare
barf	9	58	4441	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	b_as
bast	6	63	6241	2	bast
bate	6	65	5242	2	b_ate
bath	9	59	4008	2	b_ath
bats	6	69	6233	2	b_ats
batt	6	50	5387	2	batt
bay	8	96	6164	2	b_ay
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
beast	7	63	3864	2	beast
beats	7	60	4224	2	beats
beau	6	61	3727	2	beau
beaut	7	51	3521	2	beaut
beet	6	64	5754	2	beet
begat	8	66	2972	2	begat
belt	6	57	5403	2	belt
bent	6	77	5991	2	bent
berate	8	47	2902	2	berate
beret	7	49	4636	2	beret
best	6	63	5532	2	best
bet	5	83	7667	2	b_et
beta	6	62	3413	2	beta
bhut	9	54	2571	2	bhut
bias	6	47	3816	2	bias
bint	6	73	5504	2	bint
bit	5	70	7090	2	b_it
bitt	6	55	4581	2	bitt
blab	8	66	2913	2	blab
blae	6	61	3464	2	blae
blah	9	86	2506	2	blah
blam	8	61	3170	2	blam
blast	7	65	3257	2	blast
blate	7	59	3378	2	blate
blats	7	51	3250	2	blats
blaw	9	70	2672	2	blaw
bleat	7	57	3700	2	bleat
blet	6	62	4767	2	blet
bloat	7	52	2992	2	bloat
blot	6	58	4232	2	blot
boa	5	69	5403	2	boa_
boar	6	61	3429	2	boar
boart	7	88	3593	2	boart
boas	6	61	5083	2	boas
boast	7	59	3570	2	boast
boats	7	56	3515	2	boats
bolt	6	62	5417	2	bolt
boot	6	77	5937	2	boot
bora	6	61	4163	2	bora_
boral	7	58	3170	2	boral
boras	7	59	3830	2	boras
borate	8	50	2615	2	borate
borax	14	59	1872	2	borax
bort	6	59	6096	2	bort
bot	5	96	8040	2	b_ot
bota	6	62	3650	2	bota
bott	6	65	4857	2	bott
bout	6	63	5329	2	bout
brace	9	56	2927	2	brace
brach	12	61	2330	2	brach
bracts	10	56	1777	2	bracts
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
brants	8	57	2305	2	brants
brash	10	62	2156	2	brash
brass	7	54	2802	2	brass
bratty	11	5	968	2	bratty
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
breast	8	3	1963	2	breast
breath	11	39	1626	2	breath
bred	7	51	3097	2	bred
bree	6	72	4126	2	bree
bren	6	56	2956	2	bren
brent	7	57	3413	2	brent
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
brith	10	49	2437	2	brith
brits	7	64	3308	2	brits
britt	7	57	3223	2	britt
bro	5	62	3660	2	br_o
broad	8	48	1769	2	broad
broo	6	51	2982	2	broo
bros	6	56	3566	2	bros
broth	10	65	2109	2	broth
brow	9	72	2844	2	brow
brr	5	69	2192	2	br_r
brrr	6	53	1229	2	brrr
bruit	7	61	2672	2	bruit
brunt	7	57	2875	2	brunt
brute	7	53	2178	2	brute
bruts	7	59	2295	2	bruts
brux	13	63	1527	2	brux
bunt	6	58	5085	2	bunt
bura	6	61	3953	2	bura_
buran	7	52	2530	2	buran
buras	7	47	3630	2	buras
buret	7	74	4401	2	buret
burnt	7	52	3033	2	burnt
burst	7	53	3224	2	burst
bust	6	59	4778	2	bust
but	5	59	6302	2	b_ut
butt	6	51	4374	2	butt
carat	7	50	4879	2	carat
cart	6	65	7034	2	cart
cat	5	82	8234	2	_cat
chat	9	55	4613	2	chat
coat	6	75	5835	2	coat
crab	8	57	2767	2	crab
craft	10	53	2766	2	craft
crag	7	56	2530	2	crag
cram	8	56	3549	2	cram
crap	8	57	3184	2	crap
crate	7	65	3740	2	crate
craw	9	77	2526	2	craw
crit	6	57	4371	2	crit
dart	5	58	5787	2	dart
derat	6	50	4408	2	derat
doat	5	69	4767	2	doat
drab	7	62	2645	2	drab
draft	9	55	2668	2	draft
drag	6	48	2505	2	drag
dram	7	58	3200	2	dram
drats	6	66	2837	2	drats
draw	8	56	2301	2	draw
dray	8	54	2809	2	dray
eat	3	69	8905	2	_eat
era	3	57	4150	2	era_
eras	4	54	4150	2	eras
erst	4	74	3643	2	erst
fart	7	68	6056	2	fart
fat	6	81	7808	2	_fat
feat	7	64	5822	2	feat
fiat	7	66	4664	2	fiat
flat	7	71	4782	2	flat
frae	7	53	3047	2	frae
frag	8	51	2627	2	frag
frap	9	59	2581	2	frap
frats	8	68	2967	2	frats
fray	10	54	2890	2	fray
fret	7	58	4504	2	fret
frit	7	70	4447	2	frit
gat	4	68	8051	2	_gat
ghat	8	64	3528	2	ghat
gnat	5	60	3443	2	gnat
goat	5	62	5083	2	goat
grab	7	54	2761	2	grab
grad	6	68	2986	2	grad
graft	9	53	2720	2	graft
gram	7	70	3458	2	gram
gran	5	63	3501	2	gran
grant	6	48	4002	2	grant
grate	6	49	3288	2	grate
gray	8	53	2989	2	gray
great	6	60	3424	2	great
grit	5	52	4724	2	grit
groat	6	55	3197	2	groat
grot	5	59	4205	2	grot
hart	7	68	6577	2	hart
hat	6	72	8996	2	_hat
heat	7	70	6142	2	heat
ikat	8	76	2664	2	ikat
irate	5	56	2798	2	irate
jurat	12	48	2932	2	jurat
karat	9	68	3759	2	karat
kart	8	67	5080	2	kart
kat	7	74	6829	2	_kat
khat	11	67	3072	2	khat
korat	9	49	3443	2	korat
kraft	12	57	2101	2	kraft
krait	9	47	2677	2	krait
kraut	9	52	2140	2	kraut
kyat	11	60	2552	2	kyat
lat	3	75	9340	2	_lat
mart	6	68	6598	2	mart
mat	5	80	8394	2	_mat
meat	6	63	5960	2	meat
moat	6	63	5203	2	moat
neat	4	63	5678	2	neat
oat	3	98	8826	2	_oat
ora	3	72	5083	2	ora_
orad	5	60	3169	2	orad
oral	4	76	3812	2	oral
orate	5	51	3330	2	orate
ort	3	94	6523	2	or_t
part	6	59	6746	2	part
pat	5	80	8946	2	_pat
peat	6	59	6793	2	peat
phat	9	58	3786	2	phat
plat	6	60	4887	2	plat
pram	8	57	3349	2	pram
prao	6	62	2902	2	prao
prate	7	51	3598	2	prate
prats	7	63	3339	2	prats
prau	6	65	2947	2	prau
pray	9	63	3153	2	pray
qat	12	52	5333	2	_qat
rad	4	76	6200	2	_rad
raft	7	62	4591	2	_raft
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	6662	2	_ran
rant	4	58	6468	2	_rant
rap	5	62	6196	2	_rap
rapt	6	72	4531	2	_rapt
ras	3	75	7539	2	_ras
rate	4	54	5876	2	_rate
rath	7	60	3766	2	_rath
rato	4	54	3697	2	_rato
rats	4	62	6037	2	_rats
raw	6	72	5225	2	_raw
rax	10	84	4572	2	_rax
ray	6	63	6199	2	_ray
ret	3	59	8283	2	_ret
rot	3	72	8295	2	_rot
rut	3	55	6052	2	_rut
sat	3	62	8848	2	_sat
scat	6	58	4837	2	scat
seat	4	75	7556	2	seat
shat	7	64	5660	2	shat
skat	8	70	3790	2	skat
slat	4	69	5902	2	slat
spat	6	65	4852	2	spat
sprat	7	66	3597	2	sprat
stat	4	73	5269	2	stat
swat	7	72	4444	2	swat
tart	4	75	6618	2	tart
tat	3	76	9029	2	_tat
teat	4	59	6363	2	teat
that	7	56	3932	2	that
tract	7	56	3571	2	tract
trad	5	56	3091	2	trad
trait	5	69	4084	2	trait
tram	6	70	3455	2	tram
trap	6	75	3280	2	trap
trapt	7	64	3339	2	trapt
tray	7	76	3259	2	tray
treat	5	62	4035	2	treat
tret	4	66	5353	2	tret
trot	4	63	5131	2	trot
twat	7	58	3151	2	twat
urate	5	54	3216	2	urate
vat	6	78	6345	2	_vat
wart	7	78	6608	2	wart
wat	6	73	7892	2	_wat
what	10	54	3407	2	what
wrap	9	68	2197	2	wrap
wrapt	10	51	2318	2	wrapt
wrath	11	57	1587	2	wrath
writ	7	55	3791	2	writ

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.296	603685.8
2	DLD Change Limit	29872	331	0.876	34100.5
3	Display Results	331	331	0.076	4355.3
	(SQL Overall)	178691	331	1.248	143181.9