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

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

328 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
old	4	70	3346	(None)
bold	7	54	3281	1	bold
cold	7	73	3877	1	cold
eld	4	67	3379	1	eld
fold	8	65	2894	1	fold
gold	6	54	3016	1	gold
hold	8	62	3506	1	hold
mold	7	60	3433	1	mold
od	3	92	5524	1	o_d
odd	5	77	2545	1	odd
olds	5	59	2657	1	olds
oldy	8	53	1684	1	oldy
ole	3	71	5521	1	ole
oud	4	74	3907	1	oud
sold	5	48	3741	1	sold
told	5	61	3220	1	told
wold	8	54	2907	1	wold
acold	8	62	1493	2	acold
ad	3	119	7503	2	_ad
add	5	101	3236	2	add
ahold	9	47	1425	2	ahold
aid	4	92	6908	2	aid
al	2	106	7404	2	al_
ala	3	124	6360	2	ala
alb	5	73	4265	2	alb
ale	3	65	7234	2	ale
all	3	61	4823	2	all
alp	5	66	4113	2	alp
als	3	66	6302	2	als
alt	3	64	6796	2	alt
and	4	72	4417	2	and
auld	5	41	2536	2	auld
bad	6	77	6315	2	bad
bald	7	64	3290	2	bald
bed	6	79	5062	2	bed
bid	6	77	5181	2	bid
bled	7	57	2931	2	bled
bod	6	70	5554	2	bod
bola	6	60	3556	2	bola
bolds	8	58	2528	2	bolds
bole	6	64	4869	2	bole
boll	6	56	3475	2	boll
bolo	6	55	3595	2	bolo
bolt	6	62	5417	2	bolt
bond	7	53	3436	2	bond
bud	6	70	4127	2	bud
cad	6	74	5636	2	cad
clad	7	62	2582	2	clad
clod	7	61	2461	2	clod
cod	6	96	6012	2	cod
coed	7	71	4054	2	coed
col	5	93	6035	2	col_
cola	6	65	4139	2	cola
colds	8	57	2697	2	colds
cole	6	69	5611	2	cole
coled	8	55	4076	2	coled
cols	6	65	5308	2	cols
colt	6	71	5824	2	colt
coly	9	69	4053	2	coly
cord	7	67	4092	2	cord
could	8	65	1771	2	could
cud	6	79	3745	2	cud
dad	5	84	5616	2	dad
did	5	68	5052	2	did
dol	4	71	5065	2	dol_
dole	5	65	5000	2	dole
doled	7	54	3091	2	doled
doll	5	66	3249	2	doll
dols	5	69	4305	2	dols
dolt	5	66	4942	2	dolt
dud	5	67	3759	2	dud
ed	3	86	4518	2	_ed
el	2	67	4529	2	el_
elds	5	63	2485	2	elds
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
end	4	68	3435	2	end
fad	7	74	5241	2	fad
fed	7	65	4835	2	fed
fid	7	68	4769	2	fid
fled	8	54	2977	2	fled
flu	6	65	3021	2	flu
fly	9	71	2495	2	fly
folds	9	52	2169	2	folds
folk	11	60	2154	2	folk
fond	8	63	3095	2	fond
food	8	68	3057	2	food
ford	8	68	3549	2	ford
fud	7	63	3515	2	fud
gad	5	75	5665	2	gad
ged	5	70	4453	2	ged
geld	6	58	2843	2	geld
gid	5	70	4727	2	gid
gild	6	55	2651	2	gild
glad	6	56	2401	2	glad
gled	6	56	3114	2	gled
goad	6	68	3098	2	goad
god	5	74	4979	2	god
golds	7	54	2131	2	golds
golf	8	57	3118	2	golf
good	6	65	3180	2	good
gowd	9	65	1998	2	gowd
had	7	76	5876	2	had
held	8	53	3040	2	held
hid	7	62	4838	2	hid
hod	7	68	5246	2	hod
hoed	8	78	3798	2	hoed
holds	9	46	2324	2	holds
hole	7	75	5339	2	hole
holed	9	56	3413	2	holed
holk	11	60	2794	2	holk
holm	9	56	2811	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
hood	8	51	3233	2	hood
id	3	89	4184	2	_id
ilk	7	83	2530	2	ilk
ill	3	74	3709	2	ill
jole	11	72	3382	2	jole
jolt	11	66	3912	2	jolt
kid	8	65	4062	2	kid
kola	8	51	2496	2	kola
kolo	8	70	2622	2	kolo
la	2	192	6163	2	_la
lad	4	81	6570	2	lad
led	4	62	5455	2	led
li	2	99	4875	2	_li
lid	4	74	5352	2	lid
lo	2	80	5344	2	_lo
load	5	67	3060	2	load
lob	5	71	5446	2	lob
lode	5	62	4011	2	lode
log	4	62	5268	2	log
loid	5	55	3149	2	loid
loll	4	61	2838	2	loll
loo	3	83	5982	2	loo
lop	5	82	5531	2	lop
lord	5	50	3208	2	lord
lot	3	81	7926	2	lot
loud	5	52	2804	2	loud
low	6	60	5187	2	low
lox	10	82	4096	2	lox
mad	6	89	5871	2	mad
med	6	61	4674	2	med
meld	7	58	3047	2	meld
mid	6	73	5447	2	mid
mild	7	53	3085	2	mild
mod	6	90	5440	2	mod
mol	5	66	5459	2	mol_
mola	6	60	3563	2	mola
molds	8	53	2483	2	molds
moldy	11	50	1465	2	moldy
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
mood	7	63	3206	2	mood
mould	8	60	1575	2	mould
mud	6	73	3686	2	mud
nod	4	75	4956	2	nod
nolo	4	62	2931	2	nolo
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
oca	5	67	3173	2	oca
oda	4	81	3304	2	oda
odds	6	89	1992	2	odds
ode	4	74	4658	2	ode
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
ogle	5	63	2505	2	ogle
ogled	7	59	1596	2	ogled
oh	5	74	4700	2	o_h
ohed	8	78	2518	2	ohed
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
oiled	6	44	2947	2	oiled
oils	4	63	3797	2	oils
oily	7	79	3225	2	oily
oka	7	69	2680	2	oka
oke	7	58	3948	2	oke
olden	6	51	1485	2	olden
older	6	51	2117	2	older
oldie	6	4	1547	2	oldie
olea	4	65	3272	2	olea
oleo	4	66	3048	2	oleo
oles	4	64	5347	2	oles
olio	4	68	2967	2	olio
olla	4	48	2117	2	olla
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
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
ope	5	68	4524	2	ope
oped	7	62	3015	2	oped
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
orad	5	60	3169	2	orad
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
ordo	5	46	2235	2	ordo
ore	3	66	6183	2	ore
orle	4	56	3046	2	orle
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
os	2	113	5988	2	o_s
ose	3	81	4734	2	ose
ouds	5	64	3010	2	ouds
our	3	60	4289	2	our
out	3	80	7215	2	out
ova	6	68	2379	2	ova
ow	5	89	5017	2	o_w
owe	6	70	4103	2	owe
owed	8	68	3387	2	owed
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
oxid	12	8	1548	2	oxid
oxo	10	73	2296	2	oxo
oxy	13	63	2098	2	oxy
oy	5	89	5013	2	o_y
pad	6	80	5732	2	pad
ped	6	67	5152	2	ped
pled	7	52	3143	2	pled
plod	7	67	2327	2	plod
ply	8	63	2355	2	ply
pod	6	63	5148	2	pod
pol	5	64	4938	2	pol_
pole	6	59	5130	2	pole
poled	8	49	3484	2	poled
poll	6	63	3213	2	poll
polo	6	62	3663	2	polo
pols	6	60	4456	2	pols
poly	9	62	3515	2	poly
pond	7	55	3049	2	pond
pood	7	59	3432	2	pood
pud	6	58	3665	2	pud
rad	4	76	6200	2	rad
red	4	67	5580	2	red
rid	4	67	5463	2	rid
road	5	63	3211	2	road
rod	4	79	5389	2	rod
role	4	58	5182	2	role
rolf	7	51	3487	2	rolf
roll	4	63	3165	2	roll
rood	5	67	3300	2	rood
sad	4	74	5920	2	sad
scold	8	54	1486	2	scold
sild	5	50	3058	2	sild
sled	5	53	3437	2	sled
slid	5	58	2898	2	slid
sly	6	62	2856	2	sly
sod	4	60	5370	2	sod
sol	3	72	5662	2	sol_
sola	4	55	4186	2	sola
soldi	6	57	1720	2	soldi
soldo	6	71	1656	2	soldo
sole	4	60	5367	2	sole
soled	6	58	3517	2	soled
soli	4	66	3701	2	soli
solid	6	50	2508	2	solid
solo	4	55	3894	2	solo
sols	4	54	4816	2	sols
sord	5	62	3720	2	sord
tad	4	79	5982	2	tad
ted	4	64	4656	2	ted
toad	5	58	3018	2	toad
tod	4	94	5707	2	tod
toed	5	61	3704	2	toed
tola	4	52	3633	2	tola
tole	4	60	5290	2	tole
toled	6	59	3492	2	toled
toll	4	55	3526	2	toll
tolu	4	55	2915	2	tolu
ulu	3	60	2870	2	ulu
urd	4	64	2705	2	urd
veld	8	53	2320	2	veld
vid	7	72	4181	2	vid
void	8	62	2056	2	void
vole	7	52	3698	2	vole
voled	9	53	2372	2	voled
volt	7	64	3953	2	volt
wad	7	70	5389	2	wad
wed	7	58	4362	2	wed
weld	8	47	2773	2	weld
wild	8	51	2651	2	wild
woad	8	55	2394	2	woad
woald	9	48	1307	2	woald
wolds	9	54	2018	2	wolds
wolf	10	57	2956	2	wolf
wood	8	53	2938	2	wood
word	8	98	3200	2	word
world	9	69	1536	2	world
would	9	55	1315	2	would
wud	7	62	2715	2	wud
yald	8	69	2061	2	yald
yeld	8	114	2387	2	yeld
yid	7	66	4083	2	yid
yod	7	75	4550	2	yod
yolk	11	62	1899	2	yolk
yond	8	61	2231	2	yond
zed	13	54	3117	2	zed

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	14084	0.283	631417.0
2	DLD Change Limit	14084	328	0.670	21020.9
3	Display Results	328	328	0.080	4100.0
	(SQL Overall)	178691	328	1.033	172982.6