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

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

474 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
baa	5	106	5042	(None)
aa	2	191	7995	1	_aa
aba	5	128	5095	1	aba
ba	4	99	6234	1	b_a
baal	6	70	3311	1	baal
baas	6	68	4467	1	baas
baba	8	88	2834	1	baba
bad	6	77	6315	1	bad
bag	6	70	5922	1	bag
bah	8	77	5535	1	bah
bal	5	66	6272	1	bal
bam	7	85	6014	1	bam
ban	5	83	6683	1	ban
bap	7	64	5584	1	bap
bar	5	80	7055	1	bar
bas	5	86	8175	1	bas
bat	5	109	8895	1	bat
bay	8	96	6164	1	bay
boa	5	69	5403	1	boa
bra	5	63	3946	1	bra
aah	6	162	5296	2	aah
aal	3	90	5867	2	aal
aas	3	109	7539	2	aas
ab	4	106	7476	2	_ab
abaca	9	51	1804	2	abaca
abaka	11	43	1382	2	abaka
abas	6	86	4208	2	abas
abaya	10	44	1317	2	abaya
abba	8	105	2264	2	abba
abo	5	90	4596	2	abo
abs	5	93	5607	2	abs
aby	8	102	3806	2	aby
ad	3	119	7503	2	_ad
ae	2	125	9029	2	_ae
ag	3	110	6746	2	_ag
aga	4	104	4723	2	aga
ah	5	138	6879	2	_ah
aha	6	112	4664	2	aha
ai	2	112	8839	2	_ai
al	2	106	7404	2	_al
ala	3	124	6360	2	ala
am	4	118	7556	2	_am
ama	5	108	5330	2	ama
an	2	118	7907	2	_an
ana	3	95	5982	2	ana
ar	2	113	7938	2	_ar
as	2	110	8307	2	_as
at	2	123	9340	2	_at
ava	6	101	3932	2	ava
aw	5	125	6340	2	_aw
awa	6	119	3967	2	awa
ax	9	110	5778	2	_ax
ay	5	117	7389	2	_ay
baaed	8	52	1816	2	baaed
baals	7	61	2270	2	baals
babas	9	63	2573	2	babas
babe	8	68	3581	2	babe
babka	13	78	1291	2	babka
babu	8	58	2922	2	babu
baby	11	67	2367	2	baby
bacca	11	10	1218	2	bacca
bach	11	61	3139	2	bach
back	12	55	3576	2	back
bade	7	51	4088	2	bade
bads	7	70	4886	2	bads
baff	12	46	3226	2	baff
bags	7	66	4550	2	bags
baht	9	67	4001	2	baht
bail	6	50	4280	2	bail
bait	6	65	5600	2	bait
baiza	16	48	1322	2	baiza
bake	10	56	3751	2	bake
balas	7	69	3721	2	balas
bald	7	64	3290	2	bald
bale	6	63	5384	2	bale
balk	10	51	3222	2	balk
ball	6	60	4332	2	ball
balm	8	55	3420	2	balm
bals	6	63	5404	2	bals
balsa	7	79	2041	2	balsa
bams	8	70	4445	2	bams
banal	7	59	2599	2	banal
band	7	67	4090	2	band
banda	8	52	2310	2	banda
bane	6	52	5042	2	bane
bang	7	48	3699	2	bang
bani	6	53	3495	2	bani
bank	10	58	3574	2	bank
bans	6	65	5513	2	bans
baps	8	60	4084	2	baps
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
basal	7	57	2228	2	basal
base	6	48	4702	2	base
bash	9	152	4016	2	bash
bask	10	51	3142	2	bask
bass	6	61	4678	2	bass
bast	6	63	6241	2	bast
bate	6	65	5242	2	bate
bath	9	59	4008	2	bath
bats	6	69	6233	2	bats
batt	6	50	5387	2	batt
baud	7	49	2842	2	baud
bawd	10	55	2084	2	bawd
bawl	9	53	2606	2	bawl
bays	9	71	4391	2	bays
bazar	16	38	1600	2	bazar
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
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
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
bora	6	61	4163	2	bora
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
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
brava	10	64	1479	2	brava
braw	9	48	2956	2	braw
bray	9	52	3290	2	bray
braza	16	52	1425	2	braza
bro	5	62	3660	2	bro
brr	5	69	2192	2	brr
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
bura	6	61	3953	2	bura
bus	5	69	5097	2	bus
but	5	59	6302	2	but
buy	8	64	3654	2	buy
bwana	10	3	1024	2	bwana
by	7	75	2923	2	b_y
bye	8	61	3459	2	bye
bys	8	52	2946	2	bys
cab	7	83	5540	2	cab
caca	8	55	2808	2	caca
cad	6	74	5636	2	cad
cam	7	80	5898	2	cam
can	5	77	6013	2	can
cap	7	67	5898	2	cap
car	5	91	6556	2	car
casa	6	56	3086	2	casa
cat	5	82	8234	2	cat
caw	8	66	4793	2	caw
cay	8	71	5598	2	cay
dab	6	74	5556	2	dab
dad	5	84	5616	2	dad
dada	6	64	2244	2	dada
dag	5	77	5300	2	dag
dah	7	81	4898	2	dah
dak	8	63	4069	2	dak
dal	4	75	5495	2	dal
dam	6	74	5704	2	dam
dan	4	68	5966	2	dan
dap	6	66	5245	2	dap
data	5	60	2665	2	data
daw	7	71	4836	2	daw
day	7	62	5411	2	day
ear	3	68	6788	2	ear
eat	3	69	8905	2	eat
eau	3	74	5094	2	eau
era	3	57	4150	2	era
eta	3	58	3419	2	eta
fa	5	101	4845	2	_fa
fab	8	74	5313	2	fab
fad	7	74	5241	2	fad
fag	7	68	5236	2	fag
fan	6	71	5885	2	fan
far	6	77	6260	2	far
fas	6	82	6293	2	fas
fat	6	81	7808	2	fat
fava	10	68	2026	2	fava
fax	13	81	4331	2	fax
fay	9	74	5486	2	fay
gab	6	71	5599	2	gab
gad	5	75	5665	2	gad
gae	4	64	5770	2	gae
gag	5	77	5363	2	gag
gaga	6	66	2555	2	gaga
gal	4	60	5551	2	gal
gala	5	56	3516	2	gala
gam	6	70	6006	2	gam
gama	7	70	3551	2	gama
gan	4	80	6012	2	gan
gap	6	70	5561	2	gap
gar	4	72	5990	2	gar
gas	4	88	7025	2	gas
gat	4	68	8051	2	gat
gay	7	68	5649	2	gay
goa	4	73	4380	2	goa
ha	5	102	5994	2	_ha
haaf	10	62	2773	2	haaf
haar	7	73	2349	2	haar
had	7	76	5876	2	had
hae	6	73	6400	2	hae
hag	7	72	5574	2	hag
hah	9	106	5522	2	hah
haha	10	78	2106	2	haha
haj	13	81	4060	2	haj
ham	8	63	6328	2	ham
hao	6	72	5112	2	hao
hap	8	73	6005	2	hap
has	6	73	7265	2	has
hat	6	72	8996	2	hat
haw	9	71	5327	2	haw
hay	9	73	5877	2	hay
jab	12	84	4411	2	jab
jag	11	65	4271	2	jag
jam	12	69	4252	2	jam
jar	10	76	4615	2	jar
java	14	73	1664	2	java
jaw	13	62	3768	2	jaw
jay	13	62	4267	2	jay
ka	6	91	4508	2	_ka
kaas	8	65	3184	2	kaas
kab	9	71	4585	2	kab
kae	7	67	4454	2	kae
kaf	10	68	4551	2	kaf
kaka	7	65	1868	2	kaka
kana	8	59	2852	2	kana
kapa	10	60	2129	2	kapa
kas	7	70	5858	2	kas
kat	7	74	6829	2	kat
kata	8	56	2602	2	kata
kava	11	58	1970	2	kava
kay	10	67	4554	2	kay
kbar	10	65	1465	2	kbar
kea	7	65	4091	2	kea
koa	7	67	3777	2	koa
la	2	192	6163	2	_la
lab	5	88	6478	2	lab
lac	5	101	5582	2	lac
lad	4	81	6570	2	lad
lag	4	78	6212	2	lag
lam	5	76	6671	2	lam
lama	6	66	3529	2	lama
lap	5	85	6527	2	lap
lar	3	79	6753	2	lar
las	3	72	8147	2	las
lat	3	75	9340	2	lat
lav	6	68	4734	2	lav
lava	7	67	2542	2	lava
law	6	86	5664	2	law
lax	10	76	5152	2	lax
lay	6	88	6535	2	lay
lea	3	76	6018	2	lea
ma	4	100	6065	2	_ma
maar	6	60	2505	2	maar
mac	7	80	5392	2	mac
mad	6	89	5870	2	mad
mae	5	76	5910	2	mae
mag	6	79	5647	2	mag
mama	8	62	3158	2	mama
man	5	74	6585	2	man
mana	6	53	4194	2	mana
map	7	72	5511	2	map
mar	5	79	6594	2	mar
mara	6	74	4456	2	mara
mas	5	81	7581	2	mas
masa	6	50	3471	2	masa
mat	5	80	8393	2	mat
maw	8	70	5009	2	maw
max	12	90	4544	2	max
may	8	87	5762	2	may
maya	9	58	2458	2	maya
moa	5	72	4918	2	moa
na	2	86	5248	2	_na
naan	4	76	2193	2	naan
nab	5	69	5492	2	nab
nada	5	80	2290	2	nada
nae	3	59	5274	2	nae
nag	4	64	5081	2	nag
nah	6	98	4700	2	nah
nala	4	69	3039	2	nala
nam	5	59	5339	2	nam
nan	3	78	5487	2	nan
nana	4	66	3289	2	nana
nap	5	67	5320	2	nap
napa	6	69	2726	2	napa
naw	6	63	4649	2	naw
nay	6	69	5277	2	nay
oaf	6	59	5288	2	oaf
oak	7	62	3865	2	oak
oar	3	70	5795	2	oar
oat	3	98	8826	2	oat
oba	5	75	3155	2	oba
obas	6	57	3093	2	obas
obia	6	79	2310	2	obia
oca	5	67	3173	2	oca
oda	4	81	3304	2	oda
oka	7	69	2680	2	oka
ora	3	72	5083	2	ora
ova	6	68	2379	2	ova
pa	4	104	5648	2	_pa
pac	7	90	5408	2	pac
paca	8	51	3224	2	paca
pad	6	80	5732	2	pad
pah	8	88	5359	2	pah
pal	5	67	6167	2	pal
pam	7	78	5839	2	pam
pan	5	84	6644	2	pan
pap	7	67	5840	2	pap
papa	8	58	2714	2	papa
par	5	74	6702	2	par
para	6	52	4217	2	para
pas	5	87	7574	2	pas
pat	5	80	8946	2	pat
paw	8	76	5117	2	paw
pax	12	73	4685	2	pax
pay	8	84	6118	2	pay
pea	5	66	5724	2	pea
pia	5	68	4803	2	pia
pya	8	70	2375	2	pya
qat	12	52	5333	2	qat
qua	12	48	2197	2	qua
rad	4	76	6200	2	rad
rag	4	57	6132	2	rag
raga	5	59	3081	2	raga
rah	6	80	5240	2	rah
rai	3	76	5822	2	rai
raia	4	66	3838	2	raia
raj	10	57	4022	2	raj
raja	11	79	1868	2	raja
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
raya	7	52	2482	2	raya
ria	3	67	4550	2	ria
rya	6	76	2201	2	rya
sab	5	65	6320	2	sab
sac	5	74	5286	2	sac
sad	4	74	5920	2	sad
sae	3	83	6518	2	sae
sag	4	61	6340	2	sag
saga	5	53	3117	2	saga
sal	3	64	6288	2	sal
sap	5	64	6323	2	sap
sat	3	62	8848	2	sat
sau	3	63	5657	2	sau
saw	6	82	5535	2	saw
sax	10	74	4764	2	sax
say	6	72	6476	2	say
sea	3	61	6129	2	sea
sha	6	98	3778	2	sha
ska	7	69	2586	2	ska
spa	5	57	3081	2	spa
ta	2	116	6245	2	_ta
tab	5	74	6032	2	tab
tad	4	79	5982	2	tad
tae	3	82	6705	2	tae
tag	4	72	5949	2	tag
taj	10	64	4219	2	taj
taka	8	76	2359	2	taka
tala	4	59	3805	2	tala
tam	5	86	6342	2	tam
tan	3	71	6756	2	tan
tao	3	83	5895	2	tao
tap	5	76	6387	2	tap
tapa	6	51	2914	2	tapa
tar	3	75	7069	2	tar
tas	3	84	7710	2	tas
tat	3	76	9029	2	tat
tau	3	68	5690	2	tau
tav	6	60	4321	2	tav
taw	6	101	5545	2	taw
tax	10	94	4915	2	tax
taxa	11	68	2009	2	taxa
tea	3	73	5332	2	tea
twa	6	77	2164	2	twa
uta	3	74	2558	2	uta
vac	8	65	3714	2	vac
van	6	62	4632	2	van
var	6	61	4833	2	var
vara	7	55	3088	2	vara
vas	6	77	5577	2	vas
vasa	7	65	2297	2	vasa
vat	6	78	6345	2	vat
vau	6	68	4087	2	vau
vav	9	58	2943	2	vav
vaw	9	59	3746	2	vaw
via	6	56	3624	2	via
wab	8	70	5183	2	wab
wad	7	70	5389	2	wad
wae	6	75	5695	2	wae
wag	7	64	5175	2	wag
wan	6	67	6193	2	wan
wap	8	65	5337	2	wap
war	6	72	6242	2	war
was	6	87	6756	2	was
wat	6	73	7892	2	wat
waw	9	70	4638	2	waw
wax	13	70	4118	2	wax
way	9	67	5766	2	way
wha	9	64	2207	2	wha
ya	5	102	5150	2	_ya
yag	7	69	4773	2	yag
yah	9	90	4635	2	yah
yak	10	70	3856	2	yak
yam	8	74	4899	2	yam
yap	8	59	4982	2	yap
yar	6	72	5383	2	yar
yaw	9	71	4515	2	yaw
yay	9	69	4871	2	yay
yea	6	64	4575	2	yea
za	11	149	3920	2	_za
zag	13	75	3947	2	zag
zap	14	58	4069	2	zap
zas	12	69	4683	2	zas
zax	19	76	3063	2	zax
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.076	2351197.4
2	DLD Change Limit	14084	474	0.436	32302.8
3	Display Results	474	474	0.126	3761.9
	(SQL Overall)	178691	474	0.638	280079.9