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

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

368 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
ani	3	77	5118	(None)
ahi	6	80	4023	1	ahi
ai	2	112	8840	1	a_i
ain	3	75	7910	1	ain
ami	5	66	4681	1	ami
an	2	118	7908	1	an_
ana	3	95	5983	1	ana
and	4	72	4418	1	and
ane	3	78	6695	1	ane
anil	4	64	3743	1	anil
anis	4	57	4647	1	anis
ant	3	72	7079	1	ant
anti	4	55	3636	1	anti
any	6	84	4049	1	any
bani	6	53	3496	1	bani
rani	4	66	4011	1	rani
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
abo	5	90	4596	2	abo
abri	6	55	2221	2	abri
abs	5	93	5607	2	abs
aby	8	102	3806	2	aby
ace	5	96	5683	2	ace
acid	7	75	3340	2	acid
acini	7	57	1898	2	acini
acne	6	66	2587	2	acne
act	5	95	5784	2	act
ad	3	119	7504	2	a_d
add	5	101	3237	2	add
adit	5	64	4366	2	adit
ado	4	91	4688	2	ado
ads	4	97	5574	2	ads
adz	13	123	3287	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
agin	5	61	3271	2	agin
agio	5	78	2845	2	agio
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
ahis	7	61	3538	2	ahis
ahs	6	86	4482	2	ahs
aid	4	92	6909	2	aid
ail	3	71	7105	2	ail
aim	5	78	5822	2	aim
ains	4	61	5889	2	ains
air	3	80	5840	2	air
ais	3	90	8358	2	ais
ait	3	80	9391	2	ait
akin	8	63	2804	2	akin
al	2	106	7404	2	a_l
ala	3	124	6360	2	ala
alb	5	73	4265	2	alb
ale	3	65	7234	2	ale
alif	7	62	4214	2	alif
alit	4	61	5569	2	alit
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	5331	2	ama
amia	6	68	3690	2	amia
amid	7	70	3636	2	amid
amie	6	63	3985	2	amie
amin	6	60	4225	2	amin
amir	6	51	2975	2	amir
amis	6	64	4532	2	amis
amnia	7	59	1864	2	amnia
amnic	9	55	1624	2	amnic
amnio	7	52	1805	2	amnio
amp	7	75	4102	2	amp
amu	5	82	3732	2	amu
anal	4	80	3752	2	anal
anas	4	66	4986	2	anas
ands	5	78	3362	2	ands
anes	4	52	5593	2	anes
anew	7	66	2313	2	anew
anga	5	68	3136	2	anga
anile	5	46	3446	2	anile
anils	5	63	2672	2	anils
anima	7	46	2007	2	anima
anime	7	54	2320	2	anime
animi	7	40	1666	2	animi
anion	5	50	2881	2	anion
anise	5	51	2971	2	anise
ankh	11	11	1441	2	ankh
anna	4	55	2901	2	anna
anoa	4	56	3447	2	anoa
anon	4	61	3485	2	anon
ansa	4	59	2777	2	ansa
anta	4	68	3958	2	anta
ante	4	65	3890	2	ante
antic	7	57	2886	2	antic
antis	5	50	3331	2	antis
ants	4	72	4347	2	ants
anus	4	71	3111	2	anus
anvil	8	27	1260	2	anvil
ape	5	72	5118	2	ape
apo	5	111	4212	2	apo
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
aria	4	62	4543	2	aria
arid	5	76	4272	2	arid
aril	4	58	4302	2	aril
ark	7	70	4496	2	ark
arm	5	84	4963	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
as	2	110	8307	2	a_s
asci	6	65	1914	2	asci
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
aunt	4	65	5365	2	aunt
ava	6	101	3932	2	ava
ave	6	77	4870	2	ave
avid	8	83	2597	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
awl	6	76	3530	2	awl
awn	6	80	3591	2	awn
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
axil	11	64	2445	2	axil
axis	11	61	2791	2	axis
ay	5	117	7389	2	a_y
aye	6	71	5176	2	aye
ayin	7	63	3174	2	ayin
ays	6	70	5029	2	ays
azo	12	82	3339	2	azo
ban	5	83	6684	2	ban_
band	7	67	4092	2	band
bane	6	52	5043	2	bane
bang	7	48	3701	2	bang
bank	10	58	3575	2	bank
bans	6	65	5514	2	bans
bi	4	80	4648	2	_bi
bin	5	66	5865	2	bin
cadi	7	57	3219	2	cadi
cain	6	56	4391	2	cain
can	5	77	6014	2	can_
cane	6	66	5312	2	cane
canid	8	55	2634	2	canid
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
chi	8	62	2865	2	chi
coni	6	55	3480	2	coni
dan	4	68	5967	2	dan_
dang	6	51	3155	2	dang
danio	6	3	1978	2	danio
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
deni	5	69	2939	2	deni
din	4	64	5947	2	din
dui	4	64	3338	2	dui
en	2	80	5239	2	en_
end	4	68	3436	2	end
eng	4	67	2678	2	eng
ens	3	72	4592	2	ens
fain	7	58	4056	2	fain
fan	6	71	5886	2	fan_
fane	7	53	4357	2	fane
fang	8	54	3256	2	fang
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
fin	6	64	5804	2	fin
gadi	6	63	2973	2	gadi
gain	5	60	4216	2	gain
gan	4	80	6013	2	gan_
gane	5	51	4530	2	gane
gang	6	60	3198	2	gang
garni	6	3	1570	2	garni
ghi	7	70	1988	2	ghi
gin	4	60	5576	2	gin
gnu	4	55	2204	2	gnu
haji	14	85	2019	2	haji
hand	8	68	3371	2	hand
hang	8	55	3556	2	hang
hank	11	51	3414	2	hank
hant	7	54	6159	2	hant
hi	5	79	4759	2	_hi
hin	6	75	5957	2	hin
in	2	81	5087	2	in_
inia	4	50	2470	2	inia
ink	7	64	3364	2	ink
inn	3	67	2744	2	inn
ins	3	59	4561	2	ins
inti	4	66	2608	2	inti
jane	11	50	3148	2	jane
jin	10	64	4394	2	jin
kadi	9	62	2484	2	kadi
kain	8	53	3430	2	kain
kaki	7	65	2092	2	kaki
kami	10	58	2366	2	kami
kana	8	59	2855	2	kana
kane	8	51	3398	2	kane
kanji	16	4	745	2	kanji
khi	10	63	1831	2	khi
ki	6	75	3797	2	_ki
kin	7	63	5398	2	kin
knit	8	57	2815	2	knit
koi	7	75	3476	2	koi
lain	4	61	4628	2	lain
lanai	5	3	1957	2	lanai
land	5	63	3731	2	land
lane	4	51	5333	2	lane
lang	5	66	3739	2	lang
lank	8	47	3445	2	lank
lari	4	58	3915	2	lari
lati	4	64	3827	2	lati
lei	3	68	4638	2	lei
li	2	99	4876	2	_li
lin	3	79	6738	2	lin
magi	7	63	2953	2	magi
main	6	53	4552	2	main
man	5	74	6587	2	man_
mana	6	53	4196	2	mana
mane	6	50	5203	2	mane
mania	7	56	3415	2	mania
manic	9	46	2944	2	manic
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
many	9	57	3186	2	many
maxi	13	70	2356	2	maxi
mi	4	82	4906	2	_mi
mini	6	56	3457	2	mini
muni	6	58	2441	2	muni
na	2	86	5248	2	_na
nab	5	69	5492	2	nab
nae	3	59	5274	2	nae
nag	4	64	5081	2	nag
nah	6	98	4700	2	nah
naif	7	68	3902	2	naif
nail	4	58	3865	2	nail
nam	5	59	5339	2	nam
nan	3	78	5488	2	nan
nana	4	66	3290	2	nana
nans	4	61	3940	2	nans
naoi	4	60	2463	2	naoi
nap	5	67	5320	2	nap
naw	6	63	4649	2	naw
nay	6	69	5277	2	nay
nazi	13	62	1987	2	nazi
ne	2	70	4510	2	_ne
nib	5	67	4520	2	_nib
nil	3	61	4420	2	_nil
nim	5	71	4296	2	_nim
nip	5	69	4599	2	_nip
nit	3	70	6595	2	_nit
nix	10	69	3284	2	_nix
no	2	93	5324	2	_no
nu	2	63	3195	2	_nu
obi	5	71	2773	2	obi
oi	2	90	6149	2	_oi
on	2	80	5718	2	on_
one	3	70	5091	2	one
ono	3	68	3803	2	ono
ons	3	61	4851	2	ons
padi	7	63	3179	2	padi
pain	6	56	4724	2	pain
pan	5	84	6645	2	pan_
pane	6	49	5029	2	pane
pang	7	53	3630	2	pang
panic	9	39	2390	2	panic
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
phi	8	65	2420	2	phi
pi	4	81	4537	2	_pi
pin	5	70	6673	2	pin
poi	5	72	4466	2	poi
psi	5	66	2162	2	psi
qadi	14	56	2111	2	qadi
qi	11	65	2691	2	_qi
ragi	5	60	3228	2	ragi
rai	3	76	5822	2	rai
rain	4	62	5173	2	rain
raki	8	71	2783	2	raki
rami	6	60	3409	2	rami
ran	3	82	6662	2	ran_
rand	5	58	3957	2	rand
rang	5	69	3917	2	rang
ranid	6	64	2933	2	ranid
ranis	5	52	3584	2	ranis
rank	8	51	3553	2	rank
rant	4	58	6468	2	rant
rei	3	56	4725	2	rei
rin	3	66	6319	2	rin
sadi	5	58	3465	2	sadi
sain	4	55	5129	2	sain
saki	8	56	2848	2	saki
sand	5	53	3847	2	sand
sane	4	59	5434	2	sane
sang	5	54	4124	2	sang
sank	8	52	3683	2	sank
sans	4	51	5336	2	sans
sari	4	54	4404	2	sari
sati	4	55	3933	2	sati
sei	3	60	4893	2	sei
si	2	91	4958	2	_si
sin	3	62	6590	2	sin
ski	7	49	2570	2	ski
snib	6	65	2298	2	snib
snip	6	64	2465	2	snip
snit	4	63	4247	2	snit
sri	3	56	3400	2	sri
tain	4	55	4807	2	tain
tali	4	68	3716	2	tali
tan	3	71	6758	2	tan_
tang	5	61	3869	2	tang
tank	8	51	3403	2	tank
tans	4	61	5483	2	tans
taxi	11	71	2476	2	taxi
ti	2	84	4830	2	_ti
tin	3	63	6218	2	tin
tui	3	70	3402	2	tui
un	2	83	4114	2	un_
unai	4	48	2478	2	unai
unci	6	50	1946	2	unci
unit	4	51	4007	2	unit
uns	3	59	3676	2	uns
vagi	8	67	1936	2	vagi
vain	7	52	3300	2	vain
van	6	62	4633	2	van_
vane	7	55	3469	2	vane
vang	8	49	2605	2	vang
vans	7	62	3674	2	vans
wadi	8	62	2818	2	wadi
wain	7	58	4020	2	wain
wan	6	67	6194	2	wan_
wand	8	58	3388	2	wand
wane	7	63	4472	2	wane
wank	11	56	3251	2	wank
wans	7	64	5227	2	wans
want	7	61	5617	2	want
wany	10	64	3236	2	wany
win	6	64	5630	2	win
xi	9	81	2817	2	_xi
yagi	8	69	2224	2	yagi
yang	8	56	2608	2	yang
yank	11	54	2367	2	yank
yin	6	76	4874	2	yin
yoni	7	75	2439	2	yoni
zany	16	73	1699	2	zany
zin	12	56	4378	2	zin

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.326	548131.9
2	DLD Change Limit	14084	368	0.423	33295.5
3	Display Results	368	368	0.060	6133.3
	(SQL Overall)	178691	368	0.809	220878.9