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

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

393 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
and	4	72	4416	(None)
ad	3	119	7503	1	a_d
add	5	101	3236	1	add
aid	4	92	6907	1	aid
an	2	118	7907	1	an_
ana	3	95	5982	1	ana
ands	5	78	3361	1	ands
ane	3	78	6694	1	ane
ani	3	77	5117	1	ani
ant	3	72	7078	1	ant
any	6	84	4048	1	any
band	7	67	4090	1	band
end	4	68	3435	1	end
hand	8	68	3370	1	hand
land	5	63	3730	1	land
rand	5	58	3956	1	rand
sand	5	53	3846	1	sand
wand	8	58	3387	1	wand
aa	2	191	7995	2	a_a
aah	6	162	5296	2	aah
aal	3	90	5867	2	aal
aas	3	109	7539	2	aas
ab	4	106	7476	2	a_b
aba	5	128	5095	2	aba
abed	7	97	3413	2	abed
abo	5	90	4596	2	abo
abs	5	93	5607	2	abs
aby	8	102	3806	2	aby
ace	5	96	5683	2	ace
aced	7	95	4088	2	aced
acid	7	75	3339	2	acid
acne	6	66	2587	2	acne
acned	8	75	2066	2	acned
act	5	95	5784	2	act
adds	6	76	2245	2	adds
ado	4	91	4687	2	ado
ads	4	97	5573	2	ads
adz	13	123	3286	2	adz
ae	2	125	9029	2	a_e
aff	9	55	3761	2	aff
aft	6	68	4901	2	aft
ag	3	110	6746	2	a_g
aga	4	104	4723	2	aga
age	4	71	5433	2	age
aged	6	73	3425	2	aged
ago	4	88	4552	2	ago
ags	4	75	5166	2	ags
ah	5	138	6879	2	a_h
aha	6	112	4664	2	aha
ahed	8	95	3625	2	ahed
ahi	6	80	4023	2	ahi
ahs	6	86	4482	2	ahs
ai	2	112	8839	2	a_i
aide	5	60	4499	2	aide
aids	5	78	4635	2	aids
ail	3	71	7104	2	ail
aim	5	78	5821	2	aim
ain	3	75	7909	2	ain
ains	4	61	5888	2	ains
air	3	80	5839	2	air
ais	3	90	8357	2	ais
ait	3	80	9390	2	ait
al	2	106	7404	2	a_l
ala	3	124	6360	2	ala
aland	6	55	2641	2	aland
alb	5	73	4265	2	alb
ale	3	65	7234	2	ale
all	3	61	4823	2	all
alp	5	66	4113	2	alp
als	3	66	6302	2	als
alt	3	64	6796	2	alt
am	4	118	7556	2	a_m
ama	5	108	5330	2	ama
amend	8	57	1775	2	amend
ami	5	66	4680	2	ami
amid	7	70	3633	2	amid
amp	7	75	4102	2	amp
amu	5	82	3732	2	amu
anal	4	80	3752	2	anal
anas	4	66	4986	2	anas
andro	6	3	1416	2	andro
anes	4	52	5593	2	anes
anew	7	66	2313	2	anew
anga	5	68	3135	2	anga
anil	4	64	3743	2	anil
anis	4	57	4646	2	anis
ankh	11	11	1441	2	ankh
anna	4	55	2901	2	anna
anoa	4	56	3447	2	anoa
anode	6	50	2103	2	anode
anon	4	61	3485	2	anon
ansa	4	59	2777	2	ansa
anta	4	68	3958	2	anta
ante	4	65	3890	2	ante
anted	6	63	2824	2	anted
anti	4	55	3636	2	anti
ants	4	72	4347	2	ants
anus	4	71	3111	2	anus
ape	5	72	5118	2	ape
aped	7	85	3815	2	aped
apo	5	111	4212	2	apo
apod	7	81	2318	2	apod
app	7	68	2760	2	app
apt	5	73	5254	2	apt
ar	2	113	7938	2	a_r
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
are	3	78	7457	2	are
arf	6	74	5337	2	arf
arid	5	76	4271	2	arid
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
as	2	110	8307	2	a_s
ash	6	79	4460	2	ash
ask	7	71	3070	2	ask
asp	5	72	3534	2	asp
ass	3	78	4406	2	ass
at	2	123	9340	2	a_t
ate	3	70	5924	2	ate
att	3	54	5465	2	att
auk	7	62	3414	2	auk
auld	5	41	2536	2	auld
aunt	4	65	5365	2	aunt
ava	6	101	3932	2	ava
ave	6	77	4870	2	ave
avid	8	83	2596	2	avid
avo	6	89	3623	2	avo
aw	5	125	6340	2	a_w
awa	6	119	3967	2	awa
awe	6	77	4662	2	awe
awed	8	84	3603	2	awed
awl	6	76	3530	2	awl
awn	6	80	3591	2	awn
awned	9	66	1595	2	awned
awns	7	53	2443	2	awns
awny	10	59	1930	2	awny
ax	9	110	5778	2	a_x
axe	10	82	3949	2	axe
axed	12	88	2961	2	axed
ay	5	117	7389	2	a_y
aye	6	71	5176	2	aye
ays	6	70	5029	2	ays
azo	12	82	3339	2	azo
bad	6	77	6315	2	bad
bald	7	64	3290	2	bald
ban	5	83	6683	2	ban_
banda	8	52	2310	2	banda
bands	8	52	3342	2	bands
bandy	11	48	2418	2	bandy
bane	6	52	5042	2	bane
baned	8	54	3635	2	baned
bang	7	48	3699	2	bang
bani	6	53	3495	2	bani
bank	10	58	3574	2	bank
bans	6	65	5513	2	bans
bard	7	56	4886	2	bard
baud	7	49	2842	2	baud
bawd	10	55	2084	2	bawd
bed	6	79	5062	2	bed
bend	7	64	3526	2	bend
bid	6	77	5178	2	bid
bind	7	62	3450	2	bind
bland	8	53	2045	2	bland
bod	6	70	5554	2	bod
bond	7	53	3436	2	bond
brand	8	51	2449	2	brand
bud	6	70	4127	2	bud
bund	7	55	3066	2	bund
cad	6	74	5636	2	cad
caid	7	78	3753	2	caid
can	5	77	6013	2	can_
candy	11	51	1982	2	candy
cane	6	66	5311	2	cane
caned	8	58	3809	2	caned
canid	8	55	2634	2	canid
cans	6	50	5084	2	cans
cant	6	63	6202	2	cant
card	7	102	4587	2	card
cod	6	96	6012	2	cod
cud	6	79	3745	2	cud
dad	5	84	5616	2	dad
dan	4	68	5966	2	dan_
dandy	10	44	1670	2	dandy
dang	6	51	3153	2	dang
dank	9	58	2823	2	dank
dans	5	67	4814	2	dans
did	5	68	5051	2	did
dud	5	67	3759	2	dud
ed	3	86	4518	2	_ed
eland	6	58	2039	2	eland
eld	4	67	3379	2	eld
en	2	80	5239	2	en_
ends	5	65	2852	2	ends
eng	4	67	2678	2	eng
ens	3	72	4592	2	ens
fad	7	74	5241	2	fad
fan	6	71	5885	2	fan_
fane	7	53	4356	2	fane
fang	8	54	3254	2	fang
fano	7	58	3168	2	fano
fans	7	62	4736	2	fans
fard	8	56	3906	2	fard
fed	7	65	4835	2	fed
fend	8	48	3297	2	fend
fid	7	68	4768	2	fid
find	8	75	3260	2	find
fond	8	63	3095	2	fond
fud	7	63	3515	2	fud
fund	8	56	2498	2	fund
gad	5	75	5665	2	gad
gaed	6	60	3151	2	gaed
gan	4	80	6012	2	gan_
gane	5	51	4529	2	gane
gang	6	60	3196	2	gang
gaud	6	70	2543	2	gaud
ged	5	70	4453	2	ged
gid	5	70	4726	2	gid
gland	7	52	1771	2	gland
gnu	4	55	2204	2	gnu
god	5	74	4979	2	god
grand	7	51	2269	2	grand
had	7	76	5876	2	had
haed	8	63	3858	2	haed
hands	9	53	2738	2	hands
handy	12	55	2087	2	handy
hang	8	55	3554	2	hang
hank	11	51	3413	2	hank
hant	7	54	6158	2	hant
hard	8	54	4350	2	hard
hid	7	62	4836	2	hid
hind	8	55	2975	2	hind
hod	7	68	5246	2	hod
id	3	89	4183	2	_id
in	2	81	5086	2	in_
ink	7	64	3363	2	ink
inn	3	67	2743	2	inn
ins	3	59	4560	2	ins
jane	11	50	3147	2	jane
kana	8	59	2852	2	kana
kane	8	51	3396	2	kane
kid	8	65	4061	2	kid
kind	9	61	2855	2	kind
lad	4	81	6570	2	lad
laid	5	64	3914	2	laid
lands	6	54	2690	2	lands
lane	4	51	5332	2	lane
lang	5	66	3737	2	lang
lank	8	47	3444	2	lank
lard	5	67	4200	2	lard
laud	5	65	2772	2	laud
led	4	62	5455	2	led
lend	5	62	3367	2	lend
lid	4	74	5351	2	lid
mad	6	89	5870	2	mad
maid	7	55	3763	2	maid
man	5	74	6585	2	man_
mana	6	53	4194	2	mana
mane	6	50	5201	2	mane
maned	8	66	3409	2	maned
mano	6	65	3679	2	mano
mans	6	63	5453	2	mans
many	9	57	3184	2	many
maud	7	53	2539	2	maud
maund	8	55	1544	2	maund
med	6	61	4674	2	med
mend	7	53	3402	2	mend
mid	6	73	5445	2	mid
mind	7	54	3436	2	mind
mod	6	90	5440	2	mod
mud	6	73	3686	2	mud
na	2	86	5248	2	_na
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
nam	5	59	5339	2	nam
nan	3	78	5487	2	nan
nana	4	66	3289	2	nana
nans	4	61	3939	2	nans
nap	5	67	5320	2	nap
nard	5	66	3445	2	nard
naw	6	63	4649	2	naw
nay	6	69	5277	2	nay
ne	2	70	4510	2	_ne
no	2	93	5324	2	_no
nod	4	75	4956	2	nod
nu	2	63	3195	2	_nu
od	3	92	5524	2	_od
odd	5	77	2545	2	odd
old	4	70	3346	2	old
on	2	80	5718	2	on_
one	3	70	5091	2	one
ono	3	68	3803	2	ono
ons	3	61	4851	2	ons
oud	4	74	3907	2	oud
pad	6	80	5732	2	pad
paid	7	57	3748	2	paid
pan	5	84	6644	2	pan_
panda	8	50	2261	2	panda
pandy	11	50	2117	2	pandy
pane	6	49	5028	2	pane
paned	8	54	3718	2	paned
pang	7	53	3628	2	pang
pans	6	58	5572	2	pans
pant	6	60	6125	2	pant
pard	7	64	4132	2	pard
ped	6	67	5152	2	ped
pend	7	59	3453	2	pend
pod	6	63	5148	2	pod
pond	7	55	3049	2	pond
pud	6	58	3665	2	pud
qaid	14	60	2384	2	qaid
rad	4	76	6200	2	rad
raid	5	52	4307	2	raid
ran	3	82	6661	2	ran_
rands	6	59	3045	2	rands
randy	9	50	2208	2	randy
rang	5	69	3915	2	rang
rani	4	66	4010	2	rani
ranid	6	64	2933	2	ranid
rank	8	51	3552	2	rank
rant	4	58	6467	2	rant
red	4	67	5580	2	red
rend	5	61	3657	2	rend
rid	4	67	5462	2	rid
rind	5	65	3560	2	rind
rod	4	79	5389	2	rod
rynd	8	64	1410	2	rynd
sad	4	74	5920	2	sad
said	5	57	4211	2	said
sands	6	52	2858	2	sands
sandy	9	42	2113	2	sandy
sane	4	59	5433	2	sane
saned	6	56	3627	2	saned
sang	5	54	4122	2	sang
sank	8	52	3682	2	sank
sans	4	51	5335	2	sans
sard	5	53	4424	2	sard
send	5	52	3729	2	send
sned	5	60	2605	2	sned
sod	4	60	5370	2	sod
stand	6	59	2328	2	stand
tad	4	79	5982	2	tad
tan	3	71	6756	2	tan_
tang	5	61	3866	2	tang
tank	8	51	3401	2	tank
tans	4	61	5481	2	tans
ted	4	64	4656	2	ted
tend	5	64	3377	2	tend
tod	4	94	5707	2	tod
un	2	83	4113	2	un_
unde	5	58	2548	2	unde
undo	5	56	2015	2	undo
undy	8	50	1516	2	undy
uns	3	59	3675	2	uns
urd	4	64	2704	2	urd
van	6	62	4632	2	van_
vanda	9	45	1592	2	vanda
vane	7	55	3468	2	vane
vaned	9	46	2242	2	vaned
vang	8	49	2603	2	vang
vans	7	62	3672	2	vans
vend	8	66	2642	2	vend
viand	9	5	1107	2	viand
vid	7	72	4180	2	vid
wad	7	70	5389	2	wad
wan	6	67	6193	2	wan_
wands	9	64	2548	2	wands
wane	7	63	4471	2	wane
waned	9	58	3178	2	waned
wank	11	56	3250	2	wank
wans	7	64	5226	2	wans
want	7	61	5616	2	want
wany	10	64	3235	2	wany
ward	8	65	4225	2	ward
wed	7	58	4362	2	wed
wend	8	53	3045	2	wend
wind	8	55	3385	2	wind
wud	7	62	2715	2	wud
wynd	11	61	1446	2	wynd
yald	8	69	2060	2	yald
yang	8	56	2606	2	yang
yank	11	54	2366	2	yank
yard	8	56	3325	2	yard
yaud	8	70	2008	2	yaud
yid	7	66	4082	2	yid
yod	7	75	4550	2	yod
yond	8	61	2231	2	yond
zany	16	73	1698	2	zany
zed	13	54	3117	2	zed

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.063	2836365.1
2	DLD Change Limit	14084	393	0.376	37457.4
3	Display Results	393	393	0.093	4225.8
	(SQL Overall)	178691	393	0.532	335885.3