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

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

298 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
bold	7	54	3281	(None)
bald	7	64	3290	1	bald
bod	6	70	5554	1	bo_d
bola	6	60	3556	1	bola
bolds	8	58	2528	1	bolds
bole	6	64	4869	1	bole
boll	6	56	3475	1	boll
bolo	6	55	3595	1	bolo
bolt	6	62	5417	1	bolt
bond	7	53	3436	1	bond
cold	7	73	3877	1	cold
fold	8	65	2894	1	fold
gold	6	54	3016	1	gold
hold	8	62	3506	1	hold
mold	7	60	3433	1	mold
old	4	70	3346	1	_old
sold	5	48	3741	1	sold
told	5	61	3220	1	told
wold	8	54	2907	1	wold
acold	8	62	1493	2	acold
ahold	9	47	1425	2	ahold
auld	5	41	2536	2	auld
bad	6	77	6315	2	b_ad
bal	5	66	6272	2	bal_
balds	8	55	2464	2	balds
baldy	11	55	1893	2	baldy
bale	6	63	5384	2	bale
baled	8	54	3644	2	baled
balk	10	51	3222	2	balk
ball	6	60	4332	2	ball
balm	8	55	3420	2	balm
bals	6	63	5404	2	bals
band	7	67	4091	2	band
bard	7	56	4886	2	bard
baud	7	49	2842	2	baud
bawd	10	55	2084	2	bawd
bead	7	59	3792	2	bead
bed	6	79	5062	2	b_ed
behold	12	4	734	2	behold
bel	5	71	4846	2	bel_
bell	6	62	3718	2	bell
bels	6	61	4249	2	bels
belt	6	57	5403	2	belt
bend	7	64	3526	2	bend
bid	6	77	5181	2	b_id
bield	8	46	1465	2	bield
bifold	12	3	722	2	bifold
bile	6	61	4718	2	bile
bilk	10	58	2442	2	bilk
bill	6	72	3994	2	bill
bind	7	62	3451	2	bind
bird	7	61	2832	2	bird
bled	7	57	2931	2	bled
blob	8	60	2709	2	blob
bloc	8	50	2327	2	bloc
blog	7	57	2382	2	blog
blond	8	56	1837	2	blond
blood	8	53	1952	2	blood
blot	6	58	4232	2	blot
blow	9	58	2719	2	blow
bo	4	109	5757	2	bo__
boa	5	69	5403	2	bo_a
boar	6	61	3429	2	boar
board	8	55	2300	2	board
boas	6	61	5083	2	boas
boat	6	63	6031	2	boat
bob	7	67	5567	2	bo_b
bobs	8	63	4065	2	bobs
bock	12	60	3251	2	bock
bode	7	58	3875	2	bode
boded	9	51	2496	2	boded
bods	7	62	4471	2	bods
body	10	74	2567	2	body
boff	12	47	2733	2	boff
bog	6	78	5241	2	bo_g
bogle	8	58	2168	2	bogle
bogs	7	57	4275	2	bogs
bogy	10	64	2619	2	bogy
boho	9	69	2332	2	boho
boil	6	63	3518	2	boil
boiled	9	50	2095	2	boiled
boils	7	54	2719	2	boils
bolar	7	51	2347	2	bolar
bolas	7	47	3376	2	bolas
bolder	9	48	2093	2	bolder
boldly	12	39	942	2	boldly
boles	7	54	4860	2	boles
bolide	9	5	1556	2	bolide
bolled	9	47	2265	2	bolled
bolls	7	55	3131	2	bolls
bolos	7	55	3137	2	bolos
bolted	9	46	1780	2	bolted
bolts	7	62	3211	2	bolts
bolus	7	91	2554	2	bolus
bomb	10	69	2742	2	bomb
bonds	8	61	2684	2	bonds
bone	6	59	4932	2	bone
boned	8	51	3324	2	boned
bong	7	56	3341	2	bong
bonk	10	55	3171	2	bonk
bony	9	67	3208	2	bony
boo	5	81	6366	2	bo_o
boob	8	59	3258	2	boob
boody	11	54	2040	2	boody
booed	8	51	2727	2	booed
book	10	68	3633	2	book
boom	8	74	3567	2	boom
boon	6	71	4217	2	boon
boor	6	61	3068	2	boor
boos	6	79	5503	2	boos
boot	6	77	5937	2	boot
bop	7	75	4948	2	bo_p
bops	8	60	3798	2	bops
bora	6	61	4163	2	bora
bore	6	60	5133	2	bore
bored	8	50	3430	2	bored
bork	10	69	3382	2	bork
born	6	73	3841	2	born
bort	6	59	6096	2	bort
bos	5	79	6681	2	bo_s
bosh	9	63	2897	2	bosh
bosk	10	58	2573	2	bosk
boss	6	59	3834	2	boss
bot	5	96	8040	2	bo_t
bota	6	62	3650	2	bota
both	9	65	3343	2	both
bots	6	64	5395	2	bots
bott	6	65	4857	2	bott
boule	7	48	2804	2	boule
bound	8	48	1958	2	bound
bout	6	63	5329	2	bout
bovid	11	10	1162	2	bovid
bow	8	70	5190	2	bo_w
bowed	11	45	3342	2	bowed
bowl	9	68	2770	2	bowl
bowled	12	50	1814	2	bowled
bowls	10	61	2143	2	bowls
bows	9	62	4286	2	bows
box	12	101	4234	2	bo_x
boxed	15	43	1861	2	boxed
boxy	16	64	2073	2	boxy
boy	8	77	5356	2	bo_y
boyla	10	29	1236	2	boyla
boyo	9	69	2384	2	boyo
boys	9	67	3733	2	boys
bozo	15	68	2141	2	bozo
brad	7	52	3434	2	brad
bred	7	51	3097	2	bred
broad	8	48	1769	2	broad
brood	8	46	2024	2	brood
bud	6	70	4127	2	b_ud
build	8	44	1335	2	build
bulb	8	56	2669	2	bulb
bulk	10	54	2615	2	bulk
bull	6	56	3487	2	bull
bund	7	55	3066	2	bund
burd	7	55	3426	2	burd
clod	7	61	2461	2	clod
cod	6	96	6012	2	co_d
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
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
eld	4	67	3379	2	_eld
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
geld	6	58	2843	2	geld
gild	6	55	2651	2	gild
goad	6	68	3098	2	goad
god	5	74	4979	2	go_d
golds	7	54	2131	2	golds
golf	8	57	3118	2	golf
good	6	65	3180	2	good
gowd	9	65	1998	2	gowd
held	8	53	3040	2	held
hod	7	68	5246	2	ho_d
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
jole	11	72	3382	2	jole
jolt	11	66	3912	2	jolt
kobold	13	6	596	2	kobold
kola	8	51	2496	2	kola
kolo	8	70	2622	2	kolo
load	5	67	3060	2	load
loid	5	55	3149	2	loid
loll	4	61	2838	2	loll
lord	5	50	3208	2	lord
loud	5	52	2804	2	loud
meld	7	58	3047	2	meld
mild	7	53	3085	2	mild
mod	6	90	5440	2	mo_d
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
nod	4	75	4956	2	no_d
nolo	4	62	2931	2	nolo
obol	6	52	2061	2	obol_
obole	7	59	1714	2	obole
oboli	7	37	1287	2	oboli
obols	7	37	1586	2	obols
od	3	92	5524	2	_o_d
odd	5	77	2545	2	_odd
olds	5	59	2657	2	_olds
oldy	8	53	1684	2	_oldy
ole	3	71	5521	2	_ole
oud	4	74	3907	2	_oud
plod	7	67	2327	2	plod
pod	6	63	5148	2	po_d
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
road	5	63	3211	2	road
rod	4	79	5389	2	ro_d
role	4	58	5182	2	role
rolf	7	51	3487	2	rolf
roll	4	63	3165	2	roll
rood	5	67	3300	2	rood
scold	8	54	1486	2	scold
sild	5	50	3058	2	sild
sod	4	60	5370	2	so_d
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
toad	5	58	3018	2	toad
tod	4	94	5707	2	to_d
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
veld	8	53	2320	2	veld
void	8	62	2056	2	void
vole	7	52	3698	2	vole
voled	9	53	2372	2	voled
volt	7	64	3953	2	volt
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
yald	8	69	2061	2	yald
yeld	8	114	2387	2	yeld
yod	7	75	4550	2	yo_d
yolk	11	62	1899	2	yolk
yond	8	61	2231	2	yond

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	29872	0.550	324892.7
2	DLD Change Limit	29872	298	1.686	17717.7
3	Display Results	298	298	0.140	2128.6
	(SQL Overall)	178691	298	2.376	75206.6