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

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

400 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
ala	3	124	6360	1	ala
bola	6	60	3556	1	bola
cola	6	65	4139	1	cola
kola	8	51	2496	1	kola
la	2	192	6163	1	_la
mola	6	60	3563	1	mola
oba	5	75	3155	1	oba
oca	5	67	3173	1	oca
oda	4	81	3304	1	oda
oka	7	69	2680	1	oka
old	4	70	3346	1	old
ole	3	71	5521	1	ole
olea	4	65	3272	1	olea
olla	4	48	2117	1	olla
ora	3	72	5083	1	ora
ova	6	68	2379	1	ova
sola	4	55	4186	1	sola
tola	4	52	3633	1	tola
aa	2	191	7995	2	_aa
aal	3	90	5867	2	aal
aba	5	128	5095	2	aba
aga	4	104	4723	2	aga
aha	6	112	4664	2	aha
al	2	106	7404	2	al_
alae	4	56	4375	2	alae
alan	4	68	4408	2	alan
alar	4	63	4007	2	alar
alas	4	63	5812	2	alas
alb	5	73	4265	2	alb
alba	6	83	2833	2	alba
ale	3	65	7234	2	ale
alfa	7	76	2427	2	alfa
alga	5	79	2760	2	alga
all	3	61	4823	2	all
alma	6	63	3302	2	alma
alp	5	66	4113	2	alp
als	3	66	6302	2	als
alt	3	64	6796	2	alt
ama	5	108	5330	2	ama
ana	3	95	5982	2	ana
ava	6	101	3932	2	ava
awa	6	119	3967	2	awa
ba	4	99	6234	2	_ba
baa	5	106	5042	2	baa
bal	5	66	6272	2	bal
blab	8	66	2913	2	blab
blae	6	61	3464	2	blae
blah	9	86	2506	2	blah
blam	8	61	3170	2	blam
blat	6	65	5095	2	blat
blaw	9	70	2672	2	blaw
boa	5	69	5403	2	boa
bolar	7	51	2347	2	bolar
bolas	7	47	3376	2	bolas
bold	7	54	3281	2	bold
bole	6	64	4869	2	bole
boll	6	56	3475	2	boll
bolo	6	55	3595	2	bolo
bolt	6	62	5417	2	bolt
bora	6	61	4163	2	bora
bota	6	62	3650	2	bota
boyla	10	29	1236	2	boyla
bra	5	63	3946	2	bra
chola	10	47	1803	2	chola
clad	7	62	2582	2	clad
clag	7	59	2457	2	clag
clam	8	63	3229	2	clam
clan	6	56	3392	2	clan
clap	8	64	2904	2	clap
claw	9	56	2434	2	claw
clay	9	59	2741	2	clay
coal	6	69	3925	2	coal
coala	7	75	2112	2	coala
coca	8	80	3064	2	coca
coda	7	70	2934	2	coda
col	5	93	6035	2	col_
colas	7	54	3677	2	colas
cold	7	73	3877	2	cold
cole	6	69	5611	2	cole
cols	6	65	5308	2	cols
colt	6	71	5824	2	colt
coly	9	69	4053	2	coly
colza	16	51	1298	2	colza
coma	8	71	3485	2	coma
coxa	13	69	2296	2	coxa
dal	4	75	5495	2	dal
dobla	8	49	1364	2	dobla
dol	4	71	5065	2	dol_
dole	5	65	5000	2	dole
doll	5	66	3249	2	doll
dolma	8	62	1417	2	dolma
dols	5	69	4305	2	dols
dolt	5	66	4942	2	dolt
dona	5	55	2963	2	dona
dopa	7	72	2090	2	dopa
doula	6	57	1777	2	doula
el	2	67	4529	2	el_
elan	4	67	3424	2	elan
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
era	3	57	4150	2	era
eta	3	58	3419	2	eta
fa	5	101	4845	2	_fa
fila	7	47	2913	2	fila
flab	9	66	2835	2	flab
flag	8	74	2708	2	flag
flak	11	60	2617	2	flak
flam	9	63	3329	2	flam
flan	7	61	3418	2	flan
flap	9	61	2870	2	flap
flat	7	71	4782	2	flat
flaw	10	63	2664	2	flaw
flax	14	73	2563	2	flax
flay	10	63	3280	2	flay
flea	7	56	2849	2	flea
flu	6	65	3021	2	flu
fly	9	71	2495	2	fly
foal	7	66	3092	2	foal
fold	8	65	2894	2	fold
folia	8	36	1893	2	folia
folk	11	60	2154	2	folk
fora	7	59	3739	2	fora
gal	4	60	5551	2	gal
gala	5	56	3516	2	gala
glad	6	56	2401	2	glad
glam	7	65	2934	2	glam
glia	5	64	2315	2	glia
goa	4	73	4380	2	goa
goal	5	58	2930	2	goal
gold	6	54	3016	2	gold
golf	8	57	3118	2	golf
ha	5	102	5994	2	_ha
hila	7	62	2835	2	hila
hold	8	62	3506	2	hold
hole	7	75	5339	2	hole
holk	11	60	2794	2	holk
holla	8	49	1849	2	holla
holm	9	56	2810	2	holm
holp	9	57	2755	2	holp
hols	7	69	4629	2	hols
holt	7	78	5258	2	holt
holy	10	63	3343	2	holy
hora	7	61	3655	2	hora
hoya	10	74	1837	2	hoya
hula	7	49	2375	2	hula
hyla	10	67	1651	2	hyla
ilea	4	59	3146	2	ilea
ilia	4	60	2681	2	ilia
ilk	7	83	2530	2	ilk
ilka	8	72	1515	2	ilka
ill	3	74	3709	2	ill
iota	4	51	2783	2	iota
jole	11	72	3382	2	jole
jolt	11	66	3912	2	jolt
jota	11	64	2362	2	jota
ka	6	91	4508	2	_ka
kea	7	65	4091	2	kea
koa	7	67	3777	2	koa
koala	9	51	1221	2	koala
kolas	9	48	2223	2	kolas
kolo	8	70	2622	2	kolo
kora	8	64	3155	2	kora
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
lea	3	76	6018	2	lea
li	2	99	4875	2	_li
lo	2	80	5344	2	_lo
load	5	67	3060	2	load
loaf	7	67	3490	2	loaf
loam	6	56	3048	2	loam
loan	4	74	3645	2	loan
lob	5	71	5446	2	lob
loca	6	55	2768	2	loca
log	4	62	5268	2	log
loll	4	61	2838	2	loll
loo	3	83	5982	2	loo
lop	5	82	5531	2	lop
lot	3	81	7926	2	lot
lota	4	72	3350	2	lota
low	6	60	5187	2	low
lox	10	82	4096	2	lox
ma	4	100	6065	2	_ma
moa	5	72	4918	2	moa
mol	5	66	5459	2	mol_
molal	7	51	2034	2	molal
molar	7	52	2309	2	molar
molas	7	51	3209	2	molas
mold	7	60	3433	2	mold
mole	6	62	5183	2	mole
moll	6	67	3570	2	moll
mols	6	59	4857	2	mols
molt	6	63	5616	2	molt
moly	9	60	3191	2	moly
moola	7	51	1703	2	moola
mora	6	66	4127	2	mora
moxa	13	69	1774	2	moxa
na	2	86	5248	2	_na
nala	4	69	3039	2	nala
nolo	4	62	2931	2	nolo
noma	6	75	2946	2	noma
nona	4	69	2906	2	nona
nota	4	68	3077	2	nota
nova	7	65	1895	2	nova
oaf	6	59	5288	2	oaf
oak	7	62	3865	2	oak
oar	3	70	5795	2	oar
oat	3	98	8826	2	oat
obas	6	57	3093	2	obas
obe	5	66	3864	2	obe
obi	5	71	2772	2	obi
obia	6	79	2310	2	obia
ocas	6	67	2963	2	ocas
od	3	92	5524	2	o_d
odah	8	70	1893	2	odah
odas	5	72	3026	2	odas
odd	5	77	2545	2	odd
ode	4	74	4658	2	ode
odea	5	62	2457	2	odea
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
ofay	10	64	1610	2	ofay
off	9	63	3163	2	off
oft	6	77	4406	2	oft
ogam	7	51	2003	2	ogam
ogle	5	63	2505	2	ogle
oh	5	74	4700	2	o_h
ohia	7	57	1936	2	ohia
ohm	8	65	2301	2	ohm
oho	6	65	3438	2	oho
ohs	6	62	3231	2	ohs
oi	2	90	6148	2	o_i
oil	3	74	5205	2	oil
oils	4	63	3797	2	oils
oily	7	79	3225	2	oily
okas	8	52	2539	2	okas
okay	11	59	1766	2	okay
oke	7	58	3948	2	oke
okra	8	64	1357	2	okra
olds	5	59	2657	2	olds
oldy	8	53	1684	2	oldy
oleo	4	66	3048	2	oleo
oles	4	64	5347	2	oles
olio	4	68	2967	2	olio
ollas	5	42	1828	2	ollas
om	4	85	5300	2	o_m
oms	5	63	3751	2	oms
on	2	80	5718	2	o_n
one	3	70	5091	2	one
onlay	8	42	1294	2	onlay
only	7	53	1972	2	only
ono	3	68	3803	2	ono
ons	3	61	4851	2	ons
ooh	6	76	3709	2	ooh
oot	3	112	7469	2	oot
op	4	58	5016	2	o_p
opah	9	62	1840	2	opah
opal	6	69	2352	2	opal
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
orad	5	60	3169	2	orad
oral	4	76	3812	2	oral
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
orca	6	55	2277	2	orca
ore	3	66	6183	2	ore
orle	4	56	3046	2	orle
orra	4	61	2072	2	orra
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
os	2	113	5988	2	o_s
osar	4	68	2095	2	osar
ose	3	81	4734	2	ose
ossa	4	37	1416	2	ossa
oud	4	74	3907	2	oud
our	3	60	4289	2	our
out	3	80	7215	2	out
oval	7	71	1952	2	oval
ow	5	89	5017	2	o_w
owe	6	70	4103	2	owe
owl	6	62	2897	2	owl
owls	7	60	2293	2	owls
own	6	64	2970	2	own
ox	9	82	4238	2	o_x
oxo	10	73	2296	2	oxo
oxy	13	63	2098	2	oxy
oy	5	89	5013	2	o_y
pa	4	104	5648	2	_pa
pal	5	67	6167	2	pal
pea	5	66	5724	2	pea
pia	5	68	4803	2	pia
plan	6	58	3394	2	plan
plat	6	60	4887	2	plat
play	9	59	2898	2	play
plea	6	68	3060	2	plea
ply	8	63	2355	2	ply
pol	5	64	4938	2	pol_
polar	7	56	2345	2	polar
pole	6	59	5130	2	pole
polka	11	3	1041	2	polka
poll	6	63	3213	2	poll
polo	6	62	3663	2	polo
pols	6	60	4456	2	pols
poly	9	62	3515	2	poly
pula	6	51	2937	2	pula
pya	8	70	2375	2	pya
qua	12	48	2197	2	qua
ria	3	67	4550	2	ria
role	4	58	5182	2	role
rolf	7	51	3487	2	rolf
roll	4	63	3165	2	roll
rota	4	58	3434	2	rota
rya	6	76	2201	2	rya
sal	3	64	6288	2	sal
sea	3	61	6129	2	sea
sha	6	98	3778	2	sha
ska	7	69	2586	2	ska
slab	6	71	3376	2	slab
slag	5	59	3435	2	slag
slam	6	77	3797	2	slam
slap	6	64	3404	2	slap
slat	4	69	5902	2	slat
slaw	7	79	3071	2	slaw
slay	7	64	3638	2	slay
sly	6	62	2856	2	sly
soba	6	49	2792	2	soba
soca	6	63	3005	2	soca
soda	5	63	2938	2	soda
sofa	7	56	2560	2	sofa
soja	11	56	1951	2	soja
sol	3	72	5662	2	sol_
solan	5	53	2815	2	solan
solar	5	59	2734	2	solar
sold	5	48	3741	2	sold
sole	4	60	5367	2	sole
soli	4	66	3700	2	soli
solo	4	55	3894	2	solo
sols	4	54	4816	2	sols
soma	6	56	3529	2	soma
sora	4	57	4691	2	sora
soya	7	57	2443	2	soya
spa	5	57	3081	2	spa
ta	2	116	6245	2	_ta
tala	4	59	3805	2	tala
tea	3	73	5332	2	tea
tela	4	55	3297	2	tela
toea	4	67	3233	2	toea
toga	5	70	2741	2	toga
tolan	5	51	2401	2	tolan
tolar	5	55	2411	2	tolar
tolas	5	45	3277	2	tolas
told	5	61	3220	2	told
tole	4	60	5290	2	tole
toll	4	55	3526	2	toll
tolu	4	55	2915	2	tolu
tora	4	75	4599	2	tora
twa	6	77	2164	2	twa
ulan	4	65	2739	2	ulan
ulna	4	63	1732	2	ulna
ulu	3	60	2870	2	ulu
ulva	7	54	1269	2	ulva
uta	3	74	2558	2	uta
vela	7	57	2554	2	vela
via	6	56	3624	2	via
viola	8	59	1554	2	viola
voila	8	48	1394	2	voila
volar	8	69	1741	2	volar
vole	7	52	3698	2	vole
volt	7	64	3953	2	volt
volta	8	52	1562	2	volta
volva	11	39	900	2	volva
wha	9	64	2207	2	wha
wold	8	54	2907	2	wold
wolf	10	57	2956	2	wolf
ya	5	102	5150	2	_ya
yea	6	64	4575	2	yea
yoga	8	74	1805	2	yoga
yolk	11	62	1899	2	yolk
za	11	149	3920	2	_za
zoa	12	85	2999	2	zoa
zoea	13	71	1842	2	zoea
zona	13	63	2196	2	zona

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.060	2978183.3
2	DLD Change Limit	14084	400	0.423	33295.5
3	Display Results	400	400	0.076	5263.2
	(SQL Overall)	178691	400	0.559	319661.9