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

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

335 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
band	7	67	4091	(None)
and	4	72	4417	1	_and
bad	6	77	6315	1	ba_d
bald	7	64	3290	1	bald
ban	5	83	6684	1	ban_
banda	8	52	2310	1	banda
bands	8	52	3342	1	bands
bandy	11	48	2418	1	bandy
bane	6	52	5043	1	bane
baned	8	54	3635	1	baned
bang	7	48	3700	1	bang
bani	6	53	3496	1	bani
bank	10	58	3575	1	bank
bans	6	65	5514	1	bans
bard	7	56	4886	1	bard
baud	7	49	2842	1	baud
bawd	10	55	2084	1	bawd
bend	7	64	3526	1	bend
bind	7	62	3451	1	bind
bland	8	53	2045	1	bland
bond	7	53	3436	1	bond
brand	8	51	2449	1	brand
bund	7	55	3066	1	bund
hand	8	68	3371	1	hand
land	5	63	3731	1	land
rand	5	58	3957	1	rand
sand	5	53	3847	1	sand
wand	8	58	3388	1	wand
abed	7	97	3413	2	abed
ad	3	119	7503	2	_a_d
add	5	101	3236	2	_add
aid	4	92	6908	2	_aid
aland	6	55	2641	2	aland
an	2	118	7908	2	_an_
ana	3	95	5983	2	_ana
ands	5	78	3361	2	_ands
ane	3	78	6695	2	_ane
ani	3	77	5118	2	_ani
ant	3	72	7079	2	_ant
any	6	84	4049	2	_any
ba	4	99	6234	2	ba__
baa	5	106	5042	2	ba_a
baaed	8	52	1816	2	baaed
baal	6	70	3311	2	baal
baas	6	68	4467	2	baas
baba	8	88	2835	2	baba
babe	8	68	3582	2	babe
babu	8	58	2923	2	babu
baby	11	67	2368	2	baby
bach	11	61	3139	2	bach
back	12	55	3576	2	back
baddy	12	50	1602	2	baddy
bade	7	51	4088	2	bade
bads	7	70	4886	2	bads
baff	12	46	3227	2	baff
bag	6	70	5922	2	ba_g
bags	7	66	4550	2	bags
bah	8	77	5535	2	ba_h
baht	9	67	4001	2	baht
bail	6	50	4280	2	bail
bait	6	65	5600	2	bait
bake	10	56	3751	2	bake
baked	12	61	3077	2	baked
bal	5	66	6272	2	ba_l
balds	8	55	2464	2	balds
baldy	11	55	1893	2	baldy
bale	6	63	5384	2	bale
baled	8	54	3644	2	baled
balk	10	51	3222	2	balk
ball	6	60	4332	2	ball
balm	8	55	3420	2	balm
bals	6	63	5404	2	bals
bam	7	85	6014	2	ba_m
bams	8	70	4445	2	bams
banal	7	59	2599	2	banal
banco	9	40	1939	2	banco
bandas	9	51	2054	2	bandas
banded	10	52	2317	2	banded
bander	9	39	2822	2	bander
bandit	9	38	2113	2	bandit
bandog	10	3	872	2	bandog
banes	7	49	4558	2	banes
banged	10	49	2372	2	banged
bangs	8	56	2777	2	bangs
banjo	14	38	1244	2	banjo
banked	13	50	2144	2	banked
banks	11	55	2790	2	banks
banned	9	47	2134	2	banned
banns	7	53	2123	2	banns
banty	10	66	2400	2	banty
bap	7	64	5584	2	ba_p
baps	8	60	4084	2	baps
bar	5	80	7055	2	ba_r
barb	8	52	4006	2	barb
barde	8	53	3077	2	barde
bards	8	71	3964	2	bards
bare	6	54	6052	2	bare
bared	8	51	4448	2	bared
barf	9	58	4441	2	barf
bark	10	62	4215	2	bark
barm	8	67	3960	2	barm
barn	6	64	4464	2	barn
barned	9	56	2358	2	barned
barns	7	63	3514	2	barns
barny	10	58	2173	2	barny
bars	6	65	6409	2	bars
bas	5	86	8175	2	ba_s
base	6	48	4702	2	base
based	8	53	3158	2	based
bash	9	152	4016	2	bash
bask	10	51	3142	2	bask
bass	6	61	4678	2	bass
bast	6	63	6241	2	bast
bat	5	109	8895	2	ba_t
bate	6	65	5242	2	bate
bated	8	59	3553	2	bated
bath	9	59	4008	2	bath
bats	6	69	6233	2	bats
batt	6	50	5387	2	batt
bauds	8	58	2104	2	bauds
bawds	11	61	1549	2	bawds
bawdy	14	75	1328	2	bawdy
bawl	9	53	2606	2	bawl
bay	8	96	6164	2	ba_y
bayed	11	54	2302	2	bayed
bays	9	71	4391	2	bays
bead	7	59	3792	2	bead
bean	6	64	4386	2	bean_
beaned	9	56	2147	2	beaned
beano	7	54	2155	2	beano
beans	7	57	3469	2	beans
beard	8	60	2496	2	beard
bed	6	79	5062	2	b_ed
ben	5	65	5492	2	ben_
bends	8	56	2897	2	bends
bendy	11	50	1725	2	bendy
bene	6	64	3949	2	bene
bens	6	59	4570	2	bens
bent	6	77	5991	2	bent
bhang	11	55	1292	2	bhang
bid	6	77	5181	2	b_id
bin	5	66	5864	2	bin_
bindi	8	56	1701	2	bindi
binds	8	66	2747	2	binds
bine	6	66	5086	2	bine
bins	6	65	4825	2	bins
bint	6	73	5504	2	bint
bird	7	61	2832	2	bird
blank	11	54	1855	2	blank
bled	7	57	2931	2	bled
blend	8	53	1745	2	blend
blind	8	63	1932	2	blind
blond	8	56	1837	2	blond
board	8	55	2300	2	board
bod	6	70	5554	2	b_od
bold	7	54	3281	2	bold
bonds	8	61	2684	2	bonds
bone	6	59	4932	2	bone
boned	8	51	3324	2	boned
bong	7	56	3341	2	bong
bonk	10	55	3171	2	bonk
bony	9	67	3208	2	bony
bound	8	48	1958	2	bound
brad	7	52	3434	2	brad
braid	8	58	2226	2	braid
bran	6	57	4038	2	bran_
brands	9	51	1894	2	brands
brandy	12	47	1206	2	brandy
brank	11	52	2228	2	brank
brans	7	54	3743	2	brans
brant	7	47	4217	2	brant
bred	7	51	3097	2	bred
bud	6	70	4127	2	b_ud
bun	5	63	4814	2	bun_
buna	6	47	3072	2	buna
bunds	8	55	2354	2	bunds
bundt	8	58	2485	2	bundt
bung	7	57	3063	2	bung
bunk	10	57	3135	2	bunk
bunn	6	50	2365	2	bunn
buns	6	62	4372	2	buns
bunt	6	58	5085	2	bunt
burd	7	55	3426	2	burd
bwana	10	3	1024	2	bwana
cad	6	74	5636	2	ca_d
caid	7	78	3753	2	caid
can	5	77	6014	2	can_
candy	11	51	1982	2	candy
cane	6	66	5312	2	cane
caned	8	58	3809	2	caned
canid	8	55	2634	2	canid
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
card	7	102	4587	2	card
dad	5	84	5616	2	da_d
dan	4	68	5967	2	dan_
dandy	10	44	1670	2	dandy
dang	6	51	3154	2	dang
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
eland	6	58	2039	2	eland
end	4	68	3435	2	_end
fad	7	74	5241	2	fa_d
fan	6	71	5886	2	fan_
fane	7	53	4357	2	fane
fang	8	54	3255	2	fang
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
fard	8	56	3906	2	fard
fend	8	48	3297	2	fend
find	8	75	3260	2	find
fond	8	63	3095	2	fond
fund	8	56	2498	2	fund
gad	5	75	5665	2	ga_d
gaed	6	60	3151	2	gaed
gan	4	80	6013	2	gan_
gane	5	51	4530	2	gane
gang	6	60	3197	2	gang
gaud	6	70	2543	2	gaud
gland	7	52	1771	2	gland
grand	7	51	2269	2	grand
had	7	76	5876	2	ha_d
haed	8	63	3858	2	haed
hands	9	53	2738	2	hands
handy	12	55	2087	2	handy
hang	8	55	3555	2	hang
hank	11	51	3414	2	hank
hant	7	54	6159	2	hant
hard	8	54	4350	2	hard
hind	8	55	2975	2	hind
jane	11	50	3148	2	jane
kana	8	59	2853	2	kana
kane	8	51	3397	2	kane
kind	9	61	2856	2	kind
lad	4	81	6570	2	la_d
laid	5	64	3914	2	laid
lands	6	54	2690	2	lands
lane	4	51	5333	2	lane
lang	5	66	3738	2	lang
lank	8	47	3445	2	lank
lard	5	67	4200	2	lard
laud	5	65	2772	2	laud
lend	5	62	3367	2	lend
mad	6	89	5871	2	ma_d
maid	7	55	3766	2	maid
man	5	74	6587	2	man_
mana	6	53	4196	2	mana
mane	6	50	5203	2	mane
maned	8	66	3410	2	maned
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
many	9	57	3186	2	many
maud	7	53	2540	2	maud
maund	8	55	1545	2	maund
mend	7	53	3403	2	mend
mind	7	54	3438	2	mind
nan	3	78	5488	2	nan_
nana	4	66	3290	2	nana
nans	4	61	3940	2	nans
nard	5	66	3445	2	nard
pad	6	80	5732	2	pa_d
paid	7	57	3748	2	paid
pan	5	84	6645	2	pan_
panda	8	50	2261	2	panda
pandy	11	50	2117	2	pandy
pane	6	49	5029	2	pane
paned	8	54	3718	2	paned
pang	7	53	3629	2	pang
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
pard	7	64	4132	2	pard
pend	7	59	3453	2	pend
pond	7	55	3049	2	pond
qaid	14	60	2384	2	qaid
rad	4	76	6200	2	ra_d
raid	5	52	4307	2	raid
ran	3	82	6662	2	ran_
rands	6	59	3045	2	rands
randy	9	50	2208	2	randy
rang	5	69	3916	2	rang
rani	4	66	4011	2	rani
ranid	6	64	2933	2	ranid
rank	8	51	3553	2	rank
rant	4	58	6468	2	rant
rend	5	61	3657	2	rend
riband	9	23	962	2	riband
rind	5	65	3560	2	rind
roband	9	23	1072	2	roband
rynd	8	64	1410	2	rynd
sad	4	74	5920	2	sa_d
said	5	57	4211	2	said
sands	6	52	2858	2	sands
sandy	9	42	2113	2	sandy
sane	4	59	5434	2	sane
saned	6	56	3627	2	saned
sang	5	54	4123	2	sang
sank	8	52	3683	2	sank
sans	4	51	5336	2	sans
sard	5	53	4424	2	sard
send	5	52	3729	2	send
stand	6	59	2328	2	stand
tad	4	79	5982	2	ta_d
tan	3	71	6757	2	tan_
tang	5	61	3867	2	tang
tank	8	51	3402	2	tank
tans	4	61	5482	2	tans
tend	5	64	3377	2	tend
van	6	62	4633	2	van_
vanda	9	45	1592	2	vanda
vane	7	55	3469	2	vane
vaned	9	46	2242	2	vaned
vang	8	49	2604	2	vang
vans	7	62	3673	2	vans
vend	8	66	2642	2	vend
viand	9	5	1107	2	viand
wad	7	70	5389	2	wa_d
wan	6	67	6194	2	wan_
wands	9	64	2548	2	wands
wane	7	63	4472	2	wane
waned	9	58	3178	2	waned
wank	11	56	3251	2	wank
wans	7	64	5227	2	wans
want	7	61	5617	2	want
wany	10	64	3236	2	wany
ward	8	65	4225	2	ward
wend	8	53	3045	2	wend
wind	8	55	3385	2	wind
wynd	11	61	1446	2	wynd
yald	8	69	2061	2	yald
yang	8	56	2607	2	yang
yank	11	54	2367	2	yank
yard	8	56	3325	2	yard
yaud	8	70	2008	2	yaud
yond	8	61	2231	2	yond
zany	16	73	1699	2	zany

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.266	671770.7
2	DLD Change Limit	29872	335	0.876	34100.5
3	Display Results	335	335	0.076	4407.9
	(SQL Overall)	178691	335	1.218	146708.5