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

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

330 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
ands	5	78	3362	(None)
adds	6	76	2246	1	adds
ads	4	97	5574	1	a_ds
aids	5	78	4637	1	aids
anas	4	66	4986	1	anas
and	4	72	4418	1	and_
anes	4	52	5593	1	anes
anis	4	57	4647	1	anis
ants	4	72	4347	1	ants
anus	4	71	3111	1	anus
bands	8	52	3343	1	bands
ends	5	65	2853	1	ends
hands	9	53	2738	1	hands
lands	6	54	2690	1	lands
rands	6	59	3045	1	rands
sands	6	52	2858	1	sands
wands	9	64	2548	1	wands
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	a_as
abas	6	86	4208	2	abas
abos	6	77	3441	2	abos
abs	5	93	5607	2	a_bs
abys	9	72	2188	2	abys
aces	6	76	4509	2	aces
acids	8	71	2101	2	acids
acnes	7	59	2262	2	acnes
acts	6	69	2986	2	acts
ad	3	119	7504	2	a_d_
add	5	101	3237	2	a_dd
ado	4	91	4688	2	a_do
ados	5	76	3351	2	ados
adz	13	123	3287	2	a_dz
aedes	6	46	2515	2	aedes
agas	5	59	3884	2	agas
ages	5	58	4459	2	ages
ags	4	75	5166	2	a_gs
ahis	7	61	3538	2	ahis
ahs	6	86	4482	2	a_hs
aid	4	92	6909	2	aid_
aide	5	60	4501	2	aide
aides	6	53	3661	2	aides
ails	4	56	5472	2	ails
aims	6	77	3819	2	aims
ains	4	61	5889	2	ains
airs	4	64	4743	2	airs
ais	3	90	8358	2	a_is
aits	4	63	5554	2	aits
alands	7	54	1837	2	alands
alas	4	63	5812	2	alas
albs	6	86	2857	2	albs
ales	4	70	6710	2	ales
alls	4	67	4092	2	alls
alms	6	58	3492	2	alms
alps	6	55	2924	2	alps
als	3	66	6302	2	a_ls
alts	4	66	3990	2	alts
amas	6	77	4630	2	amas
amends	9	47	1328	2	amends
amids	8	56	2752	2	amids
amis	6	64	4532	2	amis
amps	8	62	3034	2	amps
amus	6	55	2961	2	amus
an	2	118	7908	2	an__
ana	3	95	5983	2	an_a
anal	4	80	3752	2	anal
andro	6	3	1416	2	andro
andros	7	3	1330	2	andros
ane	3	78	6695	2	an_e
anew	7	66	2313	2	anew
anga	5	68	3136	2	anga
angas	6	58	2799	2	angas
angst	6	4	1550	2	angst
ani	3	77	5118	2	an_i
anil	4	64	3743	2	anil
anils	5	63	2672	2	anils
anise	5	51	2971	2	anise
ankh	11	11	1441	2	ankh
ankhs	12	11	672	2	ankhs
ankus	9	14	1068	2	ankus
anlas	5	56	2693	2	anlas
anna	4	55	2901	2	anna
annas	5	58	2488	2	annas
anoa	4	56	3447	2	anoa
anoas	5	72	2649	2	anoas
anode	6	50	2104	2	anode
anodes	7	44	1876	2	anodes
anon	4	61	3485	2	anon
ansa	4	59	2777	2	ansa
ant	3	72	7079	2	an_t
anta	4	68	3958	2	anta
antas	5	54	3203	2	antas
ante	4	65	3890	2	ante
antes	5	63	3432	2	antes
anti	4	55	3636	2	anti
antis	5	50	3331	2	antis
antsy	8	57	1279	2	antsy
any	6	84	4049	2	an_y
apes	6	60	4743	2	apes
apods	8	63	1634	2	apods
apos	6	54	3382	2	apos
apps	8	63	1969	2	apps
arbs	6	68	3473	2	arbs
arcs	6	78	3478	2	arcs
ares	4	58	7102	2	ares
arfs	7	60	2996	2	arfs
arks	8	59	3687	2	arks
arms	6	61	3750	2	arms
ars	3	76	7093	2	a_rs
arts	4	96	5026	2	arts
as	2	110	8307	2	a__s
asks	8	57	2121	2	asks
asps	6	56	2209	2	asps
ass	3	78	4406	2	a_ss
ates	4	50	4792	2	ates
auks	8	55	2526	2	auks
aunts	5	52	2763	2	aunts
aves	7	61	4260	2	aves
avos	7	72	2701	2	avos
awes	7	60	3755	2	awes
awls	7	59	2609	2	awls
awns	7	53	2443	2	awns
axes	11	73	3785	2	axes
axis	11	61	2791	2	axis
ayes	7	65	4351	2	ayes
ays	6	70	5029	2	a_ys
bads	7	70	4887	2	bads
balds	8	55	2464	2	balds
band	7	67	4092	2	band_
banda	8	52	2311	2	banda
bandas	9	51	2054	2	bandas
bandy	11	48	2419	2	bandy
banes	7	49	4558	2	banes
bangs	8	56	2778	2	bangs
banks	11	55	2790	2	banks
banns	7	53	2123	2	banns
bans	6	65	5514	2	ban_s
bards	8	71	3964	2	bards
bauds	8	58	2104	2	bauds
bawds	11	61	1549	2	bawds
beds	7	59	3779	2	beds
bends	8	56	2897	2	bends
bids	7	58	3846	2	bids
binds	8	66	2748	2	binds
bods	7	62	4472	2	bods
bonds	8	61	2684	2	bonds
brands	9	51	1894	2	brands
buds	7	52	3518	2	buds
bunds	8	55	2354	2	bunds
cads	7	61	4453	2	cads
caids	8	52	2643	2	caids
candy	11	51	1982	2	candy
canes	7	53	5037	2	canes
canids	9	51	1813	2	canids
cans	6	50	5085	2	can_s
cants	7	70	3694	2	cants
cards	8	51	3793	2	cards
cods	7	68	4811	2	cods
cuds	7	67	3048	2	cuds
dads	6	74	4278	2	dads
dandy	10	44	1670	2	dandy
dangs	7	56	2321	2	dangs
dans	5	67	4815	2	dan_s
duds	6	55	3015	2	duds
eds	4	66	3893	2	_eds
elands	7	49	1477	2	elands
elds	5	63	2486	2	elds
end	4	68	3436	2	end_
engs	5	61	2139	2	engs
ens	3	72	4592	2	en_s
fads	8	69	3988	2	fads
fanes	8	46	3989	2	fanes
fangs	9	62	2408	2	fangs
fanos	8	59	2650	2	fanos
fans	7	62	4737	2	fan_s
fards	9	66	2984	2	fards
feds	8	52	3432	2	feds
fends	9	63	2497	2	fends
fids	8	70	3475	2	fids
finds	9	54	2483	2	finds
fonds	9	58	2482	2	fonds
fuds	8	65	2857	2	fuds
funds	9	41	1925	2	funds
gads	6	78	4339	2	gads
gangs	7	62	2258	2	gangs
gauds	7	57	1772	2	gauds
geds	6	67	3082	2	geds
gids	6	59	3375	2	gids
glands	8	53	1440	2	glands
gnus	5	65	1800	2	gnus
gods	6	54	3805	2	gods
grands	8	42	1824	2	grands
hand	8	68	3371	2	hand_
handy	12	55	2087	2	handy
hangs	9	57	2673	2	hangs
hanks	12	62	2686	2	hanks
hants	8	63	3540	2	hants
hards	9	64	3565	2	hards
hinds	9	67	2148	2	hinds
hods	8	72	3987	2	hods
ids	4	75	3548	2	_ids
inks	8	69	2650	2	inks
inns	4	69	2093	2	inns
ins	3	59	4561	2	in_s
janes	12	49	2812	2	janes
kanas	9	53	2692	2	kanas
kanes	9	55	2937	2	kanes
kids	9	60	2965	2	kids
kinds	10	62	2183	2	kinds
lads	5	65	4914	2	lads
land	5	63	3731	2	land_
lanes	5	49	4679	2	lanes
lards	6	53	3186	2	lards
lauds	6	56	1848	2	lauds
lends	6	53	2625	2	lends
lids	5	63	3647	2	lids
mads	7	68	4538	2	mads
maids	8	63	2715	2	maids
manas	7	62	4043	2	manas
manes	7	66	4896	2	manes
manos	7	49	3362	2	manos
mans	6	63	5455	2	man_s
manus	7	59	2493	2	manus
mauds	8	55	1927	2	mauds
maunds	9	51	965	2	maunds
meds	7	57	3537	2	meds
mends	8	49	2769	2	mends
mids	7	65	4180	2	mids
minds	8	54	2713	2	minds
mods	7	79	4506	2	mods
muds	7	55	3066	2	muds
nabs	6	62	3619	2	nabs
nada	5	80	2291	2	nada
nadas	6	63	2081	2	nadas
nags	5	54	3602	2	nags
nanas	5	59	2863	2	nanas
nans	4	61	3940	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nards	6	59	2846	2	nards
nays	7	59	3159	2	nays
nods	5	58	3823	2	nods
nos	3	88	5932	2	_nos
nus	3	79	3939	2	_nus
odds	6	89	1993	2	odds
ods	4	75	4622	2	_ods
olds	5	59	2658	2	olds
ones	4	61	4653	2	ones
onos	4	62	2900	2	onos
ons	3	61	4851	2	on_s
onus	4	58	2681	2	onus
ouds	5	64	3011	2	ouds
pads	7	67	4296	2	pads
panda	8	50	2261	2	panda
pandas	9	55	2196	2	pandas
pandy	11	50	2117	2	pandy
panes	7	61	4869	2	panes
pangs	8	46	2867	2	pangs
pans	6	58	5573	2	pan_s
pants	7	65	3692	2	pants
pards	8	56	3433	2	pards
peds	7	58	3525	2	peds
pends	8	55	2719	2	pends
pods	7	65	4016	2	pods
ponds	8	53	2340	2	ponds
puds	7	56	3052	2	puds
qaids	15	61	1632	2	qaids
rads	5	60	4661	2	rads
raids	6	58	2752	2	raids
rand	5	58	3957	2	rand_
randy	9	50	2208	2	randy
ranids	7	51	1870	2	ranids
ranis	5	52	3584	2	ranis
ranks	9	52	2573	2	ranks
rants	5	59	3534	2	rants
reds	5	60	4287	2	reds
rends	6	51	2995	2	rends
rids	5	65	3956	2	rids
rinds	6	48	2615	2	rinds
rods	5	64	4207	2	rods
rynds	9	56	997	2	rynds
saids	6	53	2886	2	saids
sand	5	53	3847	2	sand_
sandy	9	42	2113	2	sandy
sanes	5	56	4907	2	sanes
sans	4	51	5336	2	san_s
sards	6	47	3618	2	sards
sends	6	55	2824	2	sends
sneds	6	57	1535	2	sneds
sods	5	49	4022	2	sods
stands	7	51	1805	2	stands
suds	5	61	3530	2	suds
tads	5	71	4395	2	tads
tangs	6	50	2836	2	tangs
tanks	9	46	2474	2	tanks
tans	4	61	5483	2	tan_s
teds	5	49	3258	2	teds
tends	6	54	2558	2	tends
tods	5	61	4185	2	tods
unde	5	58	2549	2	unde
undo	5	56	2016	2	undo
undy	8	50	1517	2	undy
uns	3	59	3676	2	un_s
urds	5	59	2244	2	urds
vanda	9	45	1592	2	vanda
vandas	10	39	1599	2	vandas
vanes	8	51	3098	2	vanes
vangs	9	63	1960	2	vangs
vans	7	62	3674	2	van_s
vends	9	55	2089	2	vends
viands	10	4	781	2	viands
vids	8	56	2755	2	vids
wads	8	73	4315	2	wads
wand	8	58	3388	2	wand_
wanes	8	50	4088	2	wanes
wanks	12	61	2448	2	wanks
wans	7	64	5227	2	wan_s
wants	8	79	3221	2	wants
wards	9	77	3440	2	wards
weds	8	66	2894	2	weds
wends	9	58	2281	2	wends
winds	9	54	2561	2	winds
wynds	12	63	1037	2	wynds
yangs	9	56	1870	2	yangs
yanks	12	53	1657	2	yanks
yards	9	53	2461	2	yards
yauds	9	50	1322	2	yauds
yids	8	52	2497	2	yids
yods	8	65	3119	2	yods
zeds	14	58	2181	2	zeds

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	330	0.860	34734.9
3	Display Results	330	330	0.076	4342.1
	(SQL Overall)	178691	330	1.202	148661.4