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

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

468 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
tao	3	83	5895	(None)
hao	6	72	5112	1	hao
ta	2	116	6245	1	ta_
tab	5	74	6032	1	tab
taco	6	70	3135	1	taco
tad	4	79	5982	1	tad
tae	3	82	6705	1	tae
tag	4	72	5949	1	tag
taj	10	64	4219	1	taj
tam	5	86	6342	1	tam
tan	3	71	6757	1	tan
taos	4	55	4100	1	taos
tap	5	76	6387	1	tap
tar	3	75	7069	1	tar
taro	4	68	4691	1	taro
tas	3	84	7710	1	tas
tat	3	76	9029	1	tat
tau	3	68	5690	1	tau
tav	6	60	4321	1	tav
taw	6	101	5545	1	taw
tax	10	94	4915	1	tax
tho	6	74	3396	1	tho
to	2	188	5898	1	t_o
too	3	89	6542	1	too
two	6	79	2583	1	two
aa	2	191	7995	2	_aa
aah	6	162	5296	2	aah
aal	3	90	5867	2	aal
aas	3	109	7539	2	aas
ab	4	106	7476	2	_ab
abo	5	90	4596	2	abo
ad	3	119	7503	2	_ad
ado	4	91	4687	2	ado
ae	2	125	9029	2	_ae
ag	3	110	6746	2	_ag
ago	4	88	4552	2	ago
ah	5	138	6879	2	_ah
ai	2	112	8839	2	_ai
al	2	106	7404	2	_al
am	4	118	7556	2	_am
an	2	118	7908	2	_an
apo	5	111	4212	2	apo
ar	2	113	7938	2	_ar
as	2	110	8307	2	_as
at	2	123	9340	2	_at
atap	6	67	2245	2	atap
ate	3	70	5924	2	ate
atom	6	78	2452	2	atom
atop	6	61	2475	2	atop
att	3	54	5465	2	att
avo	6	89	3623	2	avo
aw	5	125	6340	2	_aw
ax	9	110	5778	2	_ax
ay	5	117	7389	2	_ay
azo	12	82	3339	2	azo
ba	4	99	6234	2	ba_
baa	5	106	5042	2	baa
bad	6	77	6315	2	bad
bag	6	70	5922	2	bag
bah	8	77	5535	2	bah
bal	5	66	6272	2	bal
bam	7	85	6014	2	bam
ban	5	83	6684	2	ban
bap	7	64	5584	2	bap
bar	5	80	7055	2	bar
bas	5	86	8175	2	bas
bat	5	109	8895	2	bat
bay	8	96	6164	2	bay
bio	5	78	4608	2	bio
bo	4	109	5757	2	_bo
boa	5	69	5403	2	boa
boo	5	81	6366	2	boo
bro	5	62	3660	2	bro
cab	7	83	5540	2	cab
cad	6	74	5636	2	cad
calo	6	49	3644	2	calo
cam	7	80	5898	2	cam
camo	8	57	3175	2	camo
can	5	77	6014	2	can
cap	7	67	5898	2	cap
capo	8	58	2921	2	capo
car	5	91	6556	2	car
cat	5	82	8234	2	cat
caw	8	66	4793	2	caw
cay	8	71	5598	2	cay
chao	9	57	2731	2	chao
ciao	6	49	2418	2	ciao
coo	5	95	6636	2	coo
dab	6	74	5556	2	dab
dad	5	84	5616	2	dad
dado	6	71	2633	2	dado
dag	5	77	5301	2	dag
dago	6	57	2509	2	dago
dah	7	81	4898	2	dah
dak	8	63	4069	2	dak
dal	4	75	5495	2	dal
dam	6	74	5704	2	dam
dan	4	68	5967	2	dan
dap	6	66	5245	2	dap
dato	5	61	2994	2	dato
daw	7	71	4836	2	daw
day	7	62	5411	2	day
do	3	101	5525	2	_do
duo	4	85	3614	2	duo
ear	3	68	6788	2	ear
eat	3	69	8905	2	eat
eau	3	74	5094	2	eau
ego	4	67	2605	2	ego
eta	3	58	3419	2	eta_
etas	4	64	3227	2	etas
fa	5	101	4845	2	fa_
fab	8	74	5313	2	fab
fad	7	74	5241	2	fad
fado	8	72	2646	2	fado
fag	7	68	5236	2	fag
fan	6	71	5886	2	fan
fano	7	58	3169	2	fano
far	6	77	6260	2	far
faro	7	61	3692	2	faro
fas	6	82	6293	2	fas
fat	6	81	7808	2	fat
fax	13	81	4331	2	fax
fay	9	74	5486	2	fay
fro	6	55	3064	2	fro
gab	6	71	5599	2	gab
gad	5	75	5665	2	gad
gae	4	64	5770	2	gae
gag	5	77	5363	2	gag
gal	4	60	5551	2	gal
gam	6	70	6006	2	gam
gan	4	80	6013	2	gan
gaol	5	69	2541	2	gaol
gap	6	70	5561	2	gap
gar	4	72	5990	2	gar
gas	4	88	7025	2	gas
gat	4	68	8051	2	gat
gay	7	68	5649	2	gay
go	3	87	4874	2	_go
goa	4	73	4380	2	goa
goo	4	77	5477	2	goo
ha	5	102	5994	2	ha_
had	7	76	5876	2	had
hae	6	73	6400	2	hae
hag	7	72	5574	2	hag
hah	9	106	5522	2	hah
haj	13	81	4060	2	haj
halo	7	64	3732	2	halo
ham	8	63	6328	2	ham
hap	8	73	6005	2	hap
has	6	73	7265	2	has
hat	6	72	8996	2	hat
haw	9	71	5327	2	haw
hay	9	73	5877	2	hay
ho	5	102	5827	2	_ho
jab	12	84	4411	2	jab
jag	11	65	4271	2	jag
jam	12	69	4252	2	jam
jar	10	76	4615	2	jar
jato	11	58	2268	2	jato
jaw	13	62	3768	2	jaw
jay	13	62	4267	2	jay
jiao	11	50	1784	2	jiao
jo	9	95	3960	2	_jo
ka	6	91	4508	2	ka_
kab	9	71	4585	2	kab
kae	7	67	4454	2	kae
kaf	10	68	4551	2	kaf
kaon	8	75	2102	2	kaon
kas	7	70	5858	2	kas
kat	7	74	6829	2	kat
kay	10	67	4554	2	kay
kayo	11	64	1755	2	kayo
koa	7	67	3777	2	koa
la	2	192	6163	2	la_
lab	5	88	6478	2	lab
lac	5	101	5582	2	lac
lad	4	81	6570	2	lad
lag	4	78	6212	2	lag
lam	5	76	6671	2	lam
lap	5	85	6527	2	lap
lar	3	79	6753	2	lar
las	3	72	8147	2	las
lat	3	75	9340	2	lat
lav	6	68	4734	2	lav
law	6	86	5664	2	law
lax	10	76	5152	2	lax
lay	6	88	6535	2	lay
lo	2	80	5344	2	_lo
loo	3	83	5982	2	loo
ma	4	100	6066	2	ma_
mac	7	80	5393	2	mac
mad	6	89	5871	2	mad
mae	5	76	5911	2	mae
mag	6	79	5648	2	mag
mako	10	56	2236	2	mako
man	5	74	6587	2	man
mano	6	65	3681	2	mano
map	7	72	5512	2	map
mar	5	79	6595	2	mar
mas	5	81	7582	2	mas
mat	5	80	8394	2	mat
maw	8	70	5010	2	maw
max	12	90	4545	2	max
may	8	87	5763	2	may
mayo	9	65	2430	2	mayo
mho	8	66	2462	2	mho
mo	4	91	5848	2	_mo
moa	5	72	4918	2	moa
moo	5	84	6051	2	moo
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
nam	5	59	5339	2	nam
nan	3	78	5488	2	nan
naoi	4	60	2463	2	naoi
naos	4	74	2973	2	naos
nap	5	67	5320	2	nap
naw	6	63	4649	2	naw
nay	6	69	5277	2	nay
no	2	93	5324	2	_no
noo	3	71	5404	2	noo
oaf	6	59	5288	2	oaf
oak	7	62	3865	2	oak
oar	3	70	5795	2	oar
oat	3	98	8826	2	oat
oho	6	65	3438	2	oho
ono	3	68	3803	2	ono
otto	4	52	2064	2	otto
oxo	10	73	2296	2	oxo
pa	4	104	5648	2	pa_
pac	7	90	5408	2	pac
pad	6	80	5732	2	pad
pah	8	88	5359	2	pah
pal	5	67	6167	2	pal
pam	7	78	5839	2	pam
pan	5	84	6645	2	pan
pap	7	67	5840	2	pap
par	5	74	6702	2	par
pas	5	87	7574	2	pas
pat	5	80	8946	2	pat
paw	8	76	5117	2	paw
pax	12	73	4685	2	pax
pay	8	84	6118	2	pay
poo	5	77	5711	2	poo
prao	6	62	2902	2	prao
pro	5	58	3726	2	pro
qat	12	52	5333	2	qat
rad	4	76	6200	2	rad
rag	4	57	6132	2	rag
rah	6	80	5240	2	rah
rai	3	76	5822	2	rai
raj	10	57	4022	2	raj
ram	5	68	6727	2	ram
ran	3	82	6662	2	ran
rap	5	62	6196	2	rap
ras	3	75	7539	2	ras
rat	3	78	9274	2	rat
rato	4	54	3697	2	rato
raw	6	72	5225	2	raw
rax	10	84	4572	2	rax
ray	6	63	6199	2	ray
rho	6	59	2483	2	rho
sab	5	65	6320	2	sab
sac	5	74	5286	2	sac
sad	4	74	5920	2	sad
sae	3	83	6518	2	sae
sag	4	61	6340	2	sag
sago	5	63	3267	2	sago
sal	3	64	6288	2	sal
sap	5	64	6323	2	sap
sat	3	62	8848	2	sat
sau	3	63	5657	2	sau
saw	6	82	5535	2	saw
sax	10	74	4764	2	sax
say	6	72	6476	2	say
so	2	88	5544	2	_so
stab	6	73	2993	2	stab
stag	5	73	3200	2	stag
star	4	80	3776	2	star
stat	4	73	5269	2	stat
staw	7	86	2769	2	staw
stay	7	83	3372	2	stay
stoa	4	54	2591	2	stoa
taboo	7	34	1809	2	taboo
tabor	7	55	1839	2	tabor
tabs	6	68	4298	2	tabs
tabu	6	63	2849	2	tabu
tace	6	53	4251	2	tace
tach	9	61	3275	2	tach
tack	10	65	3629	2	tack
tacos	7	70	2355	2	tacos
tact	6	73	4903	2	tact
tads	5	71	4394	2	tads
tael	4	60	3071	2	tael
tags	5	55	4523	2	tags
tahr	7	52	1715	2	tahr
tail	4	54	4365	2	tail
tain	4	55	4807	2	tain
taka	8	76	2359	2	taka
take	8	47	3926	2	take
tala	4	59	3805	2	tala
talc	6	62	2681	2	talc
tale	4	61	5416	2	tale
tali	4	68	3716	2	tali
talk	8	62	3009	2	talk
tall	4	72	4021	2	tall
talon	5	58	2411	2	talon
tame	6	63	4366	2	tame
tamp	8	61	3300	2	tamp
tams	6	72	4793	2	tams
tang	5	61	3867	2	tang
tango	6	69	2117	2	tango
tank	8	51	3402	2	tank
tans	4	61	5482	2	tans
tanto	5	57	2494	2	tanto
tapa	6	51	2914	2	tapa
tape	6	45	3814	2	tape
taps	6	60	5067	2	taps
tardo	6	53	2110	2	tardo
tare	4	59	5762	2	tare
tarn	4	68	4272	2	tarn
taroc	7	57	2164	2	taroc
tarok	9	79	2107	2	tarok
taros	5	56	4082	2	taros
tarot	5	59	4393	2	tarot
tarp	6	69	3641	2	tarp
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
task	8	53	2665	2	task
tass	4	56	4057	2	tass
tate	4	47	4860	2	tate
tats	4	68	5813	2	tats
tauon	5	48	1658	2	tauon
taus	4	63	4273	2	taus
taut	4	70	4896	2	taut
tavs	7	56	3097	2	tavs
taws	7	56	4159	2	taws
taxa	11	68	2009	2	taxa
taxi	11	71	2476	2	taxi
taxol	12	40	1136	2	taxol
taxon	12	44	1466	2	taxon
tea	3	73	5332	2	tea
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tear	4	52	4288	2	tear
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
ted	4	64	4656	2	ted
tee	3	83	6687	2	tee
teg	4	57	4162	2	teg
tel	3	56	4790	2	tel
ten	3	58	5611	2	ten
tet	3	92	7499	2	tet
tew	6	66	4015	2	tew
thae	7	68	2556	2	thae
than	7	61	2877	2	than
that	7	56	3932	2	that
thaw	10	75	2131	2	thaw
the	6	74	3605	2	the
thio	7	72	2541	2	thio
thou	7	67	2221	2	thou
thro	7	77	2642	2	thro
thy	9	70	2291	2	thy
ti	2	84	4829	2	t_i
tic	5	63	4346	2	tic
tie	3	65	5753	2	tie
til	3	63	5026	2	til
tin	3	63	6217	2	tin
tip	5	65	5122	2	tip
tiro	4	68	3236	2	tiro
tis	3	70	5664	2	tis
tit	3	67	7105	2	tit
toad	5	58	3018	2	toad
tod	4	94	5707	2	tod
toe	3	101	6685	2	toe
tog	4	102	5504	2	tog
tom	5	143	5805	2	tom
ton	3	102	6510	2	ton
took	8	65	3107	2	took
tool	4	67	3568	2	tool
toom	6	65	3293	2	toom
toon	4	77	4063	2	toon
toot	4	59	5888	2	toot
top	5	105	6068	2	top
topo	6	69	3240	2	topo
tor	3	92	6168	2	tor
toro	4	80	4568	2	toro
tot	3	88	8477	2	tot
tow	6	105	5736	2	tow
toy	6	96	5519	2	toy
toyo	7	69	2545	2	toyo
trad	5	56	3091	2	trad
tram	6	70	3455	2	tram
trap	6	75	3280	2	trap
tray	7	76	3259	2	tray
trio	4	52	3334	2	trio
trod	5	76	2795	2	trod
trog	5	76	2821	2	trog
trop	6	68	3330	2	trop
trot	4	63	5131	2	trot
trow	7	80	3142	2	trow
troy	7	74	2968	2	troy
try	6	65	2967	2	try
tsar	4	78	1980	2	tsar
tsk	7	58	1473	2	tsk
tub	5	56	4003	2	tub
tug	4	59	3740	2	tug
tui	3	70	3402	2	tui
tun	3	58	4519	2	tun
tup	5	60	3754	2	tup
tut	3	67	5809	2	tut
tux	10	54	2657	2	tux
twa	6	77	2164	2	twa
twae	7	47	1957	2	twae
twas	7	68	2408	2	twas
twat	7	58	3151	2	twat
twos	7	67	1802	2	twos
tye	6	58	3744	2	tye
typo	9	54	1812	2	typo
tyro	7	66	2236	2	tyro
tzar	13	63	1537	2	tzar
udo	4	90	2730	2	udo
upo	5	89	2586	2	upo
uta	3	74	2558	2	uta_
utas	4	59	2495	2	utas
vac	8	65	3714	2	vac
van	6	62	4633	2	van
var	6	61	4833	2	var
vas	6	77	5577	2	vas
vat	6	78	6345	2	vat
vau	6	68	4087	2	vau
vav	9	58	2943	2	vav
vaw	9	59	3746	2	vaw
wab	8	70	5183	2	wab
wad	7	70	5389	2	wad
wae	6	75	5695	2	wae
wag	7	64	5175	2	wag
wan	6	67	6194	2	wan
wap	8	65	5337	2	wap
war	6	72	6242	2	war
was	6	87	6756	2	was
wat	6	73	7892	2	wat
waw	9	70	4638	2	waw
wax	13	70	4118	2	wax
way	9	67	5766	2	way
who	9	55	2677	2	who
wo	5	104	4776	2	_wo
woo	6	69	4980	2	woo
ya	5	102	5150	2	ya_
yag	7	69	4773	2	yag
yah	9	90	4635	2	yah
yak	10	70	3856	2	yak
yam	8	74	4899	2	yam
yap	8	59	4982	2	yap
yar	6	72	5383	2	yar
yaw	9	71	4515	2	yaw
yay	9	69	4871	2	yay
yo	5	97	4855	2	_yo
za	11	149	3920	2	za_
zag	13	75	3947	2	zag
zap	14	58	4069	2	zap
zas	12	69	4683	2	zas
zax	19	76	3063	2	zax
zoa	12	85	2999	2	zoa
zoo	12	62	3891	2	zoo

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	468	0.406	34689.7
3	Display Results	468	468	0.093	5032.3
	(SQL Overall)	178691	468	0.562	317955.5