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

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

303 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
ono	3	68	3803	(None)
mono	6	60	3672	1	mono
no	2	93	5324	1	_no
noo	3	71	5404	1	noo
oho	6	65	3438	1	oho
on	2	80	5718	1	on_
one	3	70	5091	1	one
onos	4	62	2900	1	onos
ons	3	61	4851	1	ons
onto	4	61	2766	1	onto
oxo	10	73	2296	1	oxo
abo	5	90	4596	2	abo
ado	4	91	4687	2	ado
ago	4	88	4552	2	ago
an	2	118	7908	2	an_
ana	3	95	5983	2	ana
and	4	72	4417	2	and
ane	3	78	6695	2	ane
ani	3	77	5118	2	ani
anoa	4	56	3447	2	anoa
anon	4	61	3485	2	anon
ant	3	72	7079	2	ant
any	6	84	4049	2	any
apo	5	111	4212	2	apo
avo	6	89	3623	2	avo
azo	12	82	3339	2	azo
bio	5	78	4608	2	bio
bo	4	109	5757	2	_bo
boho	9	69	2332	2	boho
bolo	6	55	3595	2	bolo
bond	7	53	3436	2	bond
bone	6	59	4932	2	bone
bong	7	56	3341	2	bong
bongo	8	57	2094	2	bongo
bonk	10	55	3171	2	bonk
bony	9	67	3208	2	bony
boo	5	81	6366	2	boo
boon	6	71	4217	2	boon
boyo	9	69	2384	2	boyo
bozo	15	68	2141	2	bozo
bro	5	62	3660	2	bro
coco	8	73	3060	2	coco
coho	9	75	2449	2	coho
con	5	102	6802	2	con_
condo	8	53	2259	2	condo
cone	6	72	5696	2	cone
congo	8	56	2313	2	congo
coni	6	55	3480	2	coni
conk	10	65	3144	2	conk
conn	6	62	2913	2	conn
cons	6	60	5769	2	cons
conto	7	60	2717	2	conto
cony	9	65	3783	2	cony
coo	5	95	6636	2	coo
coon	6	72	4894	2	coon
dino	5	60	3675	2	dino
do	3	101	5525	2	_do
dodo	6	60	2491	2	dodo
dojo	12	60	1614	2	dojo
don	4	67	5765	2	don_
dona	5	55	2963	2	dona
done	5	57	4791	2	done
dong	6	60	3165	2	dong
donor	6	44	1819	2	donor
dons	5	60	4870	2	dons
duo	4	85	3614	2	duo
ego	4	67	2605	2	ego
en	2	80	5239	2	en_
end	4	68	3435	2	end
eng	4	67	2678	2	eng
enol	4	58	2382	2	enol
enow	7	78	1987	2	enow
ens	3	72	4592	2	ens
eon	3	60	5208	2	eon_
eons	4	66	3871	2	eons
fano	7	58	3169	2	fano
fino	7	60	3469	2	fino
fon	6	63	5227	2	fon_
fond	8	63	3095	2	fond
fons	7	69	4389	2	fons
font	7	71	4375	2	font
fro	6	55	3064	2	fro
gnu	4	55	2204	2	gnu
go	3	87	4874	2	_go
gobo	7	61	2690	2	gobo
gogo	6	97	2283	2	gogo
gone	5	56	3904	2	gone
gong	6	68	2719	2	gong
gonof	9	52	1865	2	gonof
gonzo	15	3	1024	2	gonzo
goo	4	77	5477	2	goo
goon	5	72	3617	2	goon
hao	6	72	5112	2	hao
ho	5	102	5827	2	_ho
hobo	9	70	2608	2	hobo
homo	9	61	2647	2	homo
hon	6	77	5938	2	hon_
hone	7	75	4932	2	hone
hong	8	58	3395	2	hong
honk	11	69	3119	2	honk
honor	8	57	1862	2	honor
hons	7	73	5078	2	hons
in	2	81	5086	2	in_
info	7	56	1735	2	info
ink	7	64	3363	2	ink
inn	3	67	2743	2	inn
inro	4	59	2079	2	inro
ins	3	59	4560	2	ins
into	4	50	2615	2	into
ion	3	60	5102	2	ion_
ions	4	67	3785	2	ions
jo	9	95	3960	2	_jo
keno	8	79	2643	2	keno
kino	8	62	3362	2	kino
knob	10	74	1701	2	knob
knop	10	71	1659	2	knop
knot	8	56	3050	2	knot
know	11	61	1584	2	know
kobo	10	74	2210	2	kobo
kolo	8	70	2622	2	kolo
konk	7	93	2061	2	konk
koto	8	63	2347	2	koto
leno	4	73	3139	2	leno
lino	4	63	4337	2	lino
lo	2	80	5344	2	_lo
lobo	6	72	2986	2	lobo
loco	6	70	3074	2	loco
logo	5	79	3176	2	logo
lone	4	58	4913	2	lone
long	5	69	3334	2	long
loo	3	83	5982	2	loo
loon	4	73	4479	2	loon
mano	6	65	3681	2	mano
meno	6	60	3136	2	meno
mho	8	66	2462	2	mho
mo	4	91	5848	2	_mo
mojo	13	69	1722	2	mojo
mon	5	75	6158	2	mon_
mondo	8	57	2123	2	mondo
mongo	8	101	2241	2	mongo
monk	10	59	2852	2	monk
monos	7	59	3086	2	monos
mons	6	81	5226	2	mons
mony	9	68	3001	2	mony
moo	5	84	6051	2	moo
moon	6	71	4081	2	moon
mozo	15	77	1974	2	mozo
na	2	86	5248	2	_na
ne	2	70	4510	2	_ne
nob	5	89	5442	2	nob
nod	4	75	4956	2	nod
nog	4	68	4731	2	nog
noh	6	66	4064	2	noh
nolo	4	62	2931	2	nolo
nom	5	104	5064	2	nom
nona	4	69	2906	2	nona
none	4	57	4317	2	none
nook	8	57	2849	2	nook
noon	4	71	3462	2	noon
nor	3	80	4882	2	nor
nos	3	88	5932	2	nos
not	3	94	7466	2	not
now	6	59	5019	2	now
nu	2	63	3195	2	_nu
oaf	6	59	5288	2	oaf
oak	7	62	3865	2	oak
oar	3	70	5795	2	oar
oat	3	98	8826	2	oat
oba	5	75	3155	2	oba
obe	5	66	3864	2	obe
obi	5	71	2773	2	obi
oboe	6	68	2294	2	oboe
obol	6	52	2061	2	obol
oca	5	67	3173	2	oca
od	3	92	5524	2	o_d
oda	4	81	3304	2	oda
odd	5	77	2545	2	odd
ode	4	74	4658	2	ode
odor	5	57	1809	2	odor
ods	4	75	4621	2	ods
oe	2	84	7306	2	o_e
oes	3	58	6619	2	oes
of	5	82	4777	2	o_f
off	9	63	3163	2	off
oft	6	77	4406	2	oft
oh	5	74	4700	2	o_h
ohm	8	65	2301	2	ohm
ohs	6	62	3231	2	ohs
oi	2	90	6148	2	o_i
oil	3	74	5205	2	oil
oink	8	54	2934	2	oink
oka	7	69	2680	2	oka
oke	7	58	3948	2	oke
old	4	70	3346	2	old
ole	3	71	5521	2	ole
oleo	4	66	3048	2	oleo
olio	4	68	2967	2	olio
om	4	85	5300	2	o_m
oms	5	63	3751	2	oms
once	6	54	2308	2	once
ones	4	61	4653	2	ones
onion	5	43	2097	2	onion
only	7	53	1972	2	only
onus	4	58	2681	2	onus
onyx	14	7	836	2	onyx
ooh	6	76	3709	2	ooh
oot	3	112	7469	2	oot
op	4	58	5016	2	o_p
ope	5	68	4524	2	ope
ops	5	66	4125	2	ops
opt	5	75	4554	2	opt
or	2	73	5473	2	o_r
ora	3	72	5083	2	ora
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
ordo	5	46	2235	2	ordo
ore	3	66	6183	2	ore
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
orzo	13	45	1678	2	orzo
os	2	113	5988	2	o_s
ose	3	81	4734	2	ose
otto	4	52	2064	2	otto
oud	4	74	3907	2	oud
our	3	60	4289	2	our
out	3	80	7215	2	out
ouzo	13	35	1693	2	ouzo
ova	6	68	2379	2	ova
ow	5	89	5017	2	o_w
owe	6	70	4103	2	owe
owl	6	62	2897	2	owl
own	6	64	2970	2	own
owns	7	68	1958	2	owns
ox	9	82	4238	2	o_x
oxy	13	63	2098	2	oxy
oy	5	89	5013	2	o_y
phono	10	49	1702	2	phono
poco	8	68	2615	2	poco
polo	6	62	3663	2	polo
pomo	8	58	2845	2	pomo
pond	7	55	3049	2	pond
pone	6	57	4753	2	pone
pong	7	62	3114	2	pong
pons	6	58	5060	2	pons
pony	9	64	3405	2	pony
poo	5	77	5711	2	poo
poon	6	73	4126	2	poon
porno	7	51	2065	2	porno
pro	5	58	3726	2	pro
rho	6	59	2483	2	rho
rondo	6	52	1837	2	rondo
roto	4	59	3505	2	roto
snob	6	58	2559	2	snob
snog	5	56	2363	2	snog
snot	4	47	4545	2	snot
snow	7	63	2479	2	snow
so	2	88	5544	2	_so
solo	4	55	3894	2	solo
son	3	77	6195	2	son_
sone	4	66	4998	2	sone
song	5	51	3367	2	song
sons	4	60	4955	2	sons
soon	4	62	4050	2	soon
tao	3	83	5895	2	tao
tho	6	74	3396	2	tho
to	2	188	5898	2	_to
ton	3	102	6510	2	ton_
tondo	6	97	1868	2	tondo
tone	4	69	5374	2	tone
tong	5	64	3436	2	tong
tons	4	65	5305	2	tons
tony	7	56	3515	2	tony
too	3	89	6542	2	too
toon	4	77	4063	2	toon
topo	6	69	3240	2	topo
toro	4	80	4568	2	toro
toyo	7	69	2545	2	toyo
two	6	79	2583	2	two
udo	4	90	2730	2	udo
un	2	83	4114	2	un_
unco	6	60	2140	2	unco
undo	5	56	2015	2	undo
uns	3	59	3676	2	uns
unto	4	58	2428	2	unto
upo	5	89	2586	2	upo
vino	7	61	2843	2	vino
who	9	55	2677	2	who
wino	7	59	3361	2	wino
wo	5	104	4776	2	_wo
won	6	62	5206	2	won_
wonk	11	61	2530	2	wonk
wons	7	49	4204	2	wons
wont	7	58	4250	2	wont
woo	6	69	4980	2	woo
yo	5	97	4855	2	_yo
yon	6	73	4895	2	yon_
yond	8	61	2231	2	yond
yoni	7	75	2439	2	yoni
zona	13	63	2196	2	zona
zone	13	52	3108	2	zone
zonk	17	50	1862	2	zonk
zoo	12	62	3891	2	zoo
zoon	13	73	2698	2	zoon

Search took 3 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	14084	0.906	197230.7
2	DLD Change Limit	14084	303	1.623	8677.8
3	Display Results	303	303	0.203	1492.6
	(SQL Overall)	178691	303	2.732	65406.7