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

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

281 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
anus	4	71	3111	(None)
amus	6	55	2961	1	amus
anas	4	66	4986	1	anas
ands	5	78	3361	1	ands
anes	4	52	5593	1	anes
anis	4	57	4646	1	anis
ankus	9	14	1068	1	ankus
ants	4	72	4347	1	ants
gnus	5	65	1800	1	gnus
manus	7	59	2493	1	manus
nus	3	79	3939	1	_nus
onus	4	58	2681	1	onus
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
abuse	7	71	1956	2	abuse
abut	6	68	3495	2	abut
abuts	7	54	1707	2	abuts
abys	9	72	2188	2	abys
aces	6	76	4509	2	aces
acinus	8	3	1125	2	acinus
acnes	7	59	2262	2	acnes
acts	6	69	2986	2	acts
adds	6	76	2245	2	adds
ados	5	76	3351	2	ados
ads	4	97	5573	2	a_ds
adust	6	41	1745	2	adust
aeneus	6	11	1114	2	aeneus
agas	5	59	3884	2	agas
ages	5	58	4459	2	ages
ags	4	75	5166	2	a_gs
ague	5	57	2592	2	ague
agues	6	49	1905	2	agues
ahis	7	61	3538	2	ahis
ahs	6	86	4482	2	a_hs
aids	5	78	4636	2	aids
ails	4	56	5471	2	ails
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
airs	4	64	4742	2	airs
ais	3	90	8357	2	a_is
aits	4	63	5553	2	aits
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
alum	6	52	2761	2	alum
alums	7	57	2060	2	alums
amas	6	77	4629	2	amas
amis	6	64	4532	2	amis
amps	8	62	3034	2	amps
amu	5	82	3732	2	amu_
amuse	7	59	2083	2	amuse
an	2	118	7908	2	an__
ana	3	95	5983	2	an_a
anal	4	80	3752	2	anal
and	4	72	4417	2	an_d
ane	3	78	6695	2	an_e
anew	7	66	2313	2	anew
anga	5	68	3135	2	anga
angas	6	58	2798	2	angas
angst	6	4	1549	2	angst
ani	3	77	5118	2	an_i
anil	4	64	3743	2	anil
anils	5	63	2672	2	anils
animus	8	42	1161	2	animus
anise	5	51	2970	2	anise
ankh	11	11	1441	2	ankh
ankhs	12	11	672	2	ankhs
ankush	13	11	443	2	ankush
anlas	5	56	2693	2	anlas
anna	4	55	2901	2	anna
annas	5	58	2488	2	annas
annul	5	58	1338	2	annul
annuls	6	47	1173	2	annuls
anoa	4	56	3447	2	anoa
anoas	5	72	2649	2	anoas
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
anuses	6	62	1877	2	anuses
any	6	84	4049	2	an_y
apes	6	60	4743	2	apes
apos	6	54	3382	2	apos
apps	8	63	1969	2	apps
aqua	13	28	1396	2	aqua
aquas	14	24	1261	2	aquas
arbs	6	68	3473	2	arbs
arcs	6	78	3478	2	arcs
arcus	7	69	1886	2	arcus
ares	4	58	7102	2	ares
arfs	7	60	2996	2	arfs
argus	6	67	1654	2	argus
arks	8	59	3687	2	arks
arms	6	61	3749	2	arms
ars	3	76	7093	2	a_rs
arts	4	96	5026	2	arts
arum	6	61	2903	2	arum
arums	7	55	1783	2	arums
as	2	110	8307	2	a__s
ascus	7	50	1358	2	ascus
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
auk	7	62	3414	2	a_uk
auks	8	55	2526	2	auks
aunt	4	65	5365	2	aunt
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
babus	9	56	2033	2	babus
bands	8	52	3342	2	bands
banes	7	49	4558	2	banes
bangs	8	56	2777	2	bangs
banks	11	55	2790	2	banks
banns	7	53	2123	2	banns
bans	6	65	5514	2	ban_s
bonus	7	53	2432	2	bonus
buns	6	62	4372	2	buns
bus	5	69	5097	2	_bus
canes	7	53	5037	2	canes
cans	6	50	5085	2	can_s
cants	7	70	3694	2	cants
cantus	8	51	1776	2	cantus
casus	7	64	1925	2	casus
conus	7	67	2653	2	conus
crus	6	58	2848	2	crus
dangs	7	56	2320	2	dangs
dans	5	67	4815	2	dan_s
duns	5	51	4043	2	duns
ecus	6	54	2146	2	ecus
emus	6	68	2168	2	emus
ends	5	65	2852	2	ends
engs	5	61	2139	2	engs
ens	3	72	4592	2	en_s
enuf	7	3	2384	2	enuf
fanes	8	46	3989	2	fanes
fangs	9	62	2407	2	fangs
fanos	8	59	2650	2	fanos
fans	7	62	4737	2	fan_s
fanum	10	3	1344	2	fanum
fanums	11	3	726	2	fanums
fauns	8	45	1675	2	fauns
favus	11	43	1173	2	favus
feus	7	58	3075	2	feus
flus	7	56	2654	2	flus
funs	7	52	3573	2	funs
gangs	7	62	2257	2	gangs
genus	6	53	1983	2	genus
gnu	4	55	2204	2	gnu_
guns	5	55	3348	2	guns
habus	10	63	1714	2	habus
hakus	12	51	1411	2	hakus
hands	9	53	2738	2	hands
hangs	9	57	2672	2	hangs
hanks	12	62	2686	2	hanks
hants	8	63	3540	2	hants
huns	7	61	3693	2	huns
incus	7	33	1505	2	incus
inks	8	69	2650	2	inks
inns	4	69	2093	2	inns
ins	3	59	4560	2	in_s
janes	12	49	2812	2	janes
jus	10	69	3022	2	_jus
kagus	10	58	1203	2	kagus
kanas	9	53	2691	2	kanas
kanes	9	55	2937	2	kanes
kanzus	19	4	460	2	kanzus
knur	8	53	1197	2	knur
knurs	9	45	1115	2	knurs
lands	6	54	2690	2	lands
lanes	5	49	4679	2	lanes
magus	8	53	1875	2	magus
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
menus	7	58	2284	2	menus
minus	7	52	2393	2	minus
muns	6	55	3592	2	muns
mus	5	59	4675	2	_mus
nabs	6	62	3619	2	nabs
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
nays	7	59	3159	2	nays
nos	3	88	5932	2	_nos
nous	4	61	3698	2	nous
nu	2	63	3195	2	_nu_
nub	5	64	3914	2	_nub
nubs	6	59	2714	2	_nubs
nun	3	55	3774	2	_nun
nuns	4	52	2823	2	_nuns
nut	3	66	5196	2	_nut
nuts	4	50	3267	2	_nuts
ones	4	61	4653	2	ones
onos	4	62	2900	2	onos
ons	3	61	4851	2	on_s
opus	6	64	2059	2	opus
panes	7	61	4869	2	panes
pangs	8	46	2866	2	pangs
pans	6	58	5573	2	pan_s
pants	7	65	3692	2	pants
plus	6	63	2483	2	plus
puns	6	66	4148	2	puns
pus	5	55	4784	2	_pus
rakus	9	44	1367	2	rakus
ramus	7	64	1828	2	ramus
rands	6	59	3045	2	rands
ranis	5	52	3583	2	ranis
ranks	9	52	2573	2	ranks
rants	5	59	3534	2	rants
rhus	7	51	1405	2	rhus
runs	4	64	3808	2	runs
sands	6	52	2858	2	sands
sanes	5	56	4907	2	sanes
sans	4	51	5336	2	san_s
sinus	5	55	2385	2	sinus
snub	6	53	2076	2	snub
snubs	7	54	1255	2	snubs
snug	5	52	1869	2	snug
snugs	6	49	1302	2	snugs
sous	4	69	4721	2	sous
suns	4	58	4190	2	suns
tabus	7	48	2092	2	tabus
talus	5	54	2326	2	talus
tangs	6	50	2834	2	tangs
tanks	9	46	2473	2	tanks
tans	4	61	5482	2	tan_s
taus	4	63	4273	2	taus
taxus	12	55	1248	2	taxus
thus	7	67	2147	2	thus
tonus	5	63	2430	2	tonus
tuns	4	51	3866	2	tuns
ulus	4	56	2256	2	ulus
unaus	5	32	1657	2	unaus
uncus	7	40	1498	2	uncus
uns	3	59	3676	2	un_s
urus	4	64	2614	2	urus
us	2	69	3743	2	__us
vagus	9	67	1381	2	vagus
vanes	8	51	3097	2	vanes
vangs	9	63	1958	2	vangs
vans	7	62	3673	2	van_s
varus	8	59	2118	2	varus
vatus	8	61	1464	2	vatus
vaus	7	59	2892	2	vaus
venus	8	49	1890	2	venus
wamus	10	55	1468	2	wamus
wands	9	64	2548	2	wands
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
yangs	9	56	1869	2	yangs
yanks	12	53	1657	2	yanks
yous	7	62	3065	2	yous

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.280	638182.1
2	DLD Change Limit	29872	281	0.876	34100.5
3	Display Results	281	281	0.063	4460.3
	(SQL Overall)	178691	281	1.219	146588.2