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

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

458 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
bole	6	64	4869	(None)
bale	6	63	5384	1	bale
bile	6	61	4719	1	bile
bode	7	58	3876	1	bode
bogle	8	58	2168	1	bogle
bola	6	60	3556	1	bola
bold	7	54	3281	1	bold
boles	7	54	4860	1	boles
boll	6	56	3475	1	boll
bolo	6	55	3595	1	bolo
bolt	6	62	5417	1	bolt
bone	6	59	4932	1	bone
bore	6	60	5133	1	bore
boule	7	48	2804	1	boule
cole	6	69	5611	1	cole
dole	5	65	5000	1	dole
hole	7	75	5339	1	hole
jole	11	72	3382	1	jole
mole	6	62	5183	1	mole
obole	7	59	1714	1	obole
ole	3	71	5521	1	_ole
pole	6	59	5130	1	pole
role	4	58	5182	1	role
sole	4	60	5367	1	sole
tole	4	60	5290	1	tole
vole	7	52	3698	1	vole
abele	7	63	2325	2	abele
able	6	63	4053	2	able
abode	8	55	1881	2	abode
above	10	54	1432	2	above
ale	3	65	7234	2	_ale
aloe	4	55	4019	2	aloe
amole	7	57	2459	2	amole
anole	5	53	3038	2	anole
axle	11	64	2460	2	axle
azole	14	51	1803	2	azole
babe	8	68	3582	2	babe
bade	7	51	4089	2	bade
bake	10	56	3751	2	bake
bal	5	66	6272	2	bal_
bald	7	64	3290	2	bald
baled	8	54	3644	2	baled
baler	7	56	3528	2	baler
bales	7	62	5008	2	bales
balk	10	51	3222	2	balk
ball	6	60	4332	2	ball
balm	8	55	3420	2	balm
bals	6	63	5404	2	bals
bane	6	52	5043	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
be	4	79	4894	2	b__e
bee	5	62	6240	2	b_ee
bel	5	71	4846	2	bel_
belie	7	56	3038	2	belie
bell	6	62	3718	2	bell
belle	7	58	2783	2	belle
bels	6	61	4249	2	bels
belt	6	57	5403	2	belt
bene	6	64	3949	2	bene
bible	9	51	1942	2	bible
bice	8	62	3557	2	bice
bide	7	60	4151	2	bide
bike	10	65	3261	2	bike
biles	7	55	4214	2	biles
bilge	8	76	1891	2	bilge
bilk	10	58	2443	2	bilk
bill	6	72	3995	2	bill
bine	6	66	5087	2	bine
biome	9	49	1699	2	biome
birle	7	50	2363	2	birle
bise	6	64	3711	2	bise
bite	6	65	4701	2	bite
bize	15	59	2630	2	bize
blae	6	61	3464	2	blae
bleb	8	54	2522	2	b_leb
bled	7	57	2931	2	b_led
blet	6	62	4767	2	b_let
blew	9	47	2243	2	b_lew
blob	8	60	2709	2	blob
bloc	8	50	2327	2	bloc
blog	7	57	2382	2	blog
bloke	11	43	1663	2	bloke
blot	6	58	4232	2	blot
blow	9	58	2719	2	blow
blue	6	53	2846	2	blue
bo	4	109	5757	2	bo__
boa	5	69	5403	2	bo_a
boar	6	61	3429	2	boar
boas	6	61	5083	2	boas
boat	6	63	6031	2	boat
bob	7	67	5567	2	bo_b
bobble	9	41	1514	2	bobble
bobs	8	63	4065	2	bobs
bocce	11	43	1311	2	bocce
boche	12	42	1695	2	boche
bock	12	60	3251	2	bock
bod	6	70	5555	2	bo_d
boded	9	51	2496	2	boded
bodes	8	49	3510	2	bodes
bods	7	62	4472	2	bods
body	10	74	2568	2	body
boff	12	47	2733	2	boff
bog	6	78	5241	2	bo_g
bogey	11	52	2023	2	bogey
boggle	10	45	1194	2	boggle
bogie	8	95	2410	2	bogie
bogles	9	50	2083	2	bogles
bogs	7	57	4275	2	bogs
bogy	10	64	2619	2	bogy
bohea	10	50	1373	2	bohea
boho	9	69	2332	2	boho
boil	6	63	3518	2	boil
boiled	9	50	2095	2	boiled
boiler	8	43	1927	2	boiler
boils	7	54	2719	2	boils
boite	7	44	2632	2	boite
bolar	7	51	2347	2	bolar
bolas	7	47	3376	2	bolas
bolder	9	48	2093	2	bolder
bolds	8	58	2528	2	bolds
bolero	8	4	1209	2	bolero
bolete	8	5	1961	2	bolete
boleti	8	4	1340	2	boleti
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
bolter	8	39	2075	2	bolter
bolts	7	62	3211	2	bolts
bolus	7	91	2554	2	bolus
bomb	10	69	2742	2	bomb
bombe	11	55	1931	2	bombe
bond	7	53	3436	2	bond
boned	8	51	3324	2	boned
boner	7	51	3308	2	boner
bones	7	64	4653	2	bones
boney	10	52	2731	2	boney
bong	7	56	3341	2	bong
bonk	10	55	3171	2	bonk
bonne	7	51	2471	2	bonne
bony	9	67	3208	2	bony
bonze	16	51	1935	2	bonze
boo	5	81	6366	2	bo_o
boob	8	59	3258	2	boob
boodle	9	32	1503	2	boodle
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
booze	16	47	1891	2	booze
bop	7	75	4948	2	bo_p
bops	8	60	3798	2	bops
bora	6	61	4163	2	bora
bored	8	50	3430	2	bored
borer	7	51	3127	2	borer
bores	7	64	4825	2	bores
bork	10	69	3382	2	bork
born	6	73	3841	2	born
borne	7	79	2679	2	borne
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
botel	7	51	2186	2	botel
both	9	65	3343	2	both
bots	6	64	5395	2	bots
bott	6	65	4857	2	bott
bottle	8	49	1607	2	bottle
boucle	10	37	1278	2	boucle
boules	8	49	2597	2	boules
boulle	8	46	1461	2	boulle
bouse	7	59	3185	2	bouse
bout	6	63	5329	2	bout
bow	8	70	5190	2	bo_w
bowed	11	45	3342	2	bowed
bowel	10	56	2120	2	bowel
bower	10	73	2818	2	bower
bowl	9	68	2770	2	bowl
bowled	12	50	1814	2	bowled
bowleg	12	36	918	2	bowleg
bowler	11	42	1731	2	bowler
bowls	10	61	2143	2	bowls
bows	9	62	4286	2	bows
bowse	10	54	2063	2	bowse
box	12	101	4234	2	bo_x
boxed	15	43	1861	2	boxed
boxer	14	50	1652	2	boxer
boxes	14	56	2507	2	boxes
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
brae	6	56	3911	2	brae
bree	6	72	4126	2	bree
brie	6	58	3790	2	brie
broke	11	60	1978	2	broke
brome	9	44	2197	2	brome
brose	7	52	2703	2	brose
bugle	8	47	2194	2	bugle
bulb	8	56	2669	2	bulb
bulge	8	64	1987	2	bulge
bulk	10	54	2615	2	bulk
bull	6	56	3487	2	bull
bute	6	67	3967	2	bute
butle	7	50	2310	2	butle
bye	8	61	3459	2	b_ye
byre	9	50	2385	2	byre
byte	9	65	2181	2	byte
coble	9	48	2317	2	coble
code	7	73	4774	2	code
coke	10	70	3838	2	coke
col	5	93	6035	2	col_
cola	6	65	4139	2	cola
cold	7	73	3877	2	cold
coled	8	55	4076	2	coled
coles	7	60	5506	2	coles
cols	6	65	5308	2	cols
colt	6	71	5824	2	colt
coly	9	69	4053	2	coly
come	8	75	4770	2	come
cone	6	72	5696	2	cone
cope	8	68	4738	2	cope
core	6	72	6311	2	core
cote	6	66	4873	2	cote
cove	9	58	3707	2	cove
dale	5	56	4398	2	dale
dele	5	68	4308	2	dele
dhole	9	52	1536	2	dhole
doe	4	73	6195	2	do_e
doge	6	62	3380	2	doge
dol	4	71	5065	2	dol_
dolce	8	58	1668	2	dolce
doled	7	54	3091	2	doled
doles	6	78	4375	2	doles
doll	5	66	3249	2	doll
dols	5	69	4305	2	dols
dolt	5	66	4942	2	dolt
dome	7	72	4073	2	dome
done	5	57	4791	2	done
dope	7	60	3889	2	dope
dore	5	63	5330	2	dore
dose	5	64	4243	2	dose
dote	5	54	4288	2	dote
dove	8	51	3156	2	dove
doze	14	58	2908	2	doze
file	7	54	4665	2	file
floe	7	61	2977	2	floe
foe	6	63	5081	2	fo_e
fold	8	65	2894	2	fold
foley	11	52	2230	2	foley
folk	11	60	2154	2	folk
fore	7	83	5147	2	fore
gale	5	63	4732	2	gale
gold	6	54	3016	2	gold
golem	8	4	1611	2	golem
golf	8	57	3118	2	golf
gone	5	56	3904	2	gone
gore	5	57	4496	2	gore
hale	7	60	5283	2	hale
haole	8	48	2008	2	haole
hoe	6	75	6272	2	ho_e
hoke	11	59	3593	2	hoke
hold	8	62	3506	2	hold
holed	9	56	3413	2	holed
holes	8	47	4865	2	holes
holey	11	56	2690	2	holey
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
home	9	80	4244	2	home
hone	7	75	4932	2	hone
hope	9	66	3967	2	hope
hose	7	65	4724	2	hose
hove	10	71	3222	2	hove
howe	10	67	3410	2	howe
hoyle	11	3	1441	2	hoyle
idle	5	54	2377	2	idle
isle	4	51	2170	2	isle
joe	10	66	4235	2	jo_e
joke	15	59	2616	2	joke
joles	12	52	3083	2	joles
jolt	11	66	3912	2	jolt
joule	12	49	1820	2	joule
kale	8	65	3376	2	kale
koel	8	45	1995	2	koel
kola	8	51	2497	2	kola
kolo	8	70	2623	2	kolo
kore	8	58	3417	2	kore
lobe	6	55	3536	2	lobe
lode	5	62	4012	2	lode
loge	5	68	3719	2	loge
loll	4	61	2838	2	loll
lone	4	58	4913	2	lone
lope	6	59	4192	2	lope
lore	4	58	5035	2	lore
lose	4	51	4458	2	lose
love	7	52	3476	2	love
lowe	7	54	3531	2	lowe
male	6	60	5230	2	male
mile	6	63	5258	2	mile
mode	7	58	4031	2	mode
moke	10	62	3422	2	moke
mol	5	66	5459	2	mol_
mola	6	60	3563	2	mola
mold	7	60	3433	2	mold
moles	7	47	4792	2	moles
moll	6	67	3570	2	moll
mols	6	59	4857	2	mols
molt	6	63	5616	2	molt
moly	9	60	3191	2	moly
mome	8	52	3935	2	mome
mope	8	68	3804	2	mope
more	6	71	5452	2	more
mote	6	70	4808	2	mote
moue	6	58	3557	2	moue
move	9	66	3072	2	move
mule	6	52	3697	2	mule
noble	7	44	2099	2	noble
node	5	130	3689	2	node
noel	4	52	2655	2	noel
nolo	4	62	2931	2	nolo
nome	6	60	3842	2	nome
none	4	57	4317	2	none
nope	6	59	3419	2	nope
nose	4	67	3936	2	nose
note	4	62	3996	2	note
obe	5	66	3864	2	_obe
oboe	6	68	2294	2	oboe
obol	6	52	2061	2	obol_
oboles	8	38	1583	2	oboles
oboli	7	37	1287	2	oboli
obols	7	37	1586	2	obols
ode	4	74	4659	2	_ode
oe	2	84	7306	2	_o_e
ogle	5	63	2505	2	ogle
oke	7	58	3948	2	_oke
old	4	70	3347	2	_old
olea	4	65	3272	2	_olea
oleo	4	66	3048	2	_oleo
oles	4	64	5347	2	_oles
one	3	70	5091	2	_one
ooze	13	64	2060	2	ooze
ope	5	68	4524	2	_ope
ore	3	66	6183	2	_ore
orle	4	56	3046	2	orle
ose	3	81	4734	2	_ose
owe	6	70	4103	2	_owe
pale	6	60	5501	2	pale
pele	6	55	3955	2	pele
pile	6	56	4970	2	pile
poke	10	53	3536	2	poke
pol	5	64	4938	2	pol_
poled	8	49	3484	2	poled
poler	7	44	3179	2	poler
poles	7	53	5100	2	poles
poll	6	63	3213	2	poll
polo	6	62	3663	2	polo
pols	6	60	4456	2	pols
poly	9	62	3515	2	poly
pome	8	56	3669	2	pome
pone	6	57	4753	2	pone
pope	8	55	3561	2	pope
pore	6	64	5126	2	pore
pose	6	64	4173	2	pose
prole	7	45	2779	2	prole
pule	6	50	4095	2	pule
rale	4	50	5056	2	rale
rile	4	56	5054	2	rile
robe	6	53	3564	2	robe
roble	7	52	2302	2	roble
rode	5	58	4431	2	rode
roe	3	68	6108	2	ro_e
roles	5	67	4798	2	roles
rolf	7	51	3487	2	rolf
roll	4	63	3165	2	roll
rope	6	55	4291	2	rope
rose	4	61	4890	2	rose
rote	4	62	4902	2	rote
roue	4	59	4174	2	roue
rove	7	51	3698	2	rove
rule	4	99	3842	2	rule
sale	4	49	5970	2	sale
sloe	4	55	3495	2	sloe
socle	7	4	1957	2	socle
soke	8	54	3626	2	soke
sol	3	72	5662	2	sol_
sola	4	55	4186	2	sola
sold	5	48	3741	2	sold
soled	6	58	3517	2	soled
solei	5	56	2434	2	solei
soles	5	55	4792	2	soles
soli	4	66	3701	2	soli
solo	4	55	3894	2	solo
sols	4	54	4816	2	sols
solve	8	56	1894	2	solve
some	6	60	4038	2	some
sone	4	66	4998	2	sone
sore	4	70	5953	2	sore
stole	5	49	2881	2	stole
tale	4	61	5416	2	tale
tele	4	50	4087	2	tele
thole	8	56	2084	2	thole
tile	4	54	5145	2	tile
toe	3	101	6685	2	to_e
toile	5	46	2649	2	toile
toke	8	67	3849	2	toke
tola	4	52	3633	2	tola
told	5	61	3220	2	told
toled	6	59	3492	2	toled
toles	5	51	4713	2	toles
toll	4	55	3526	2	toll
tolu	4	55	2915	2	tolu
tome	6	75	4319	2	tome
tone	4	69	5374	2	tone
tope	6	59	4638	2	tope
tore	4	73	5932	2	tore
tote	4	66	4367	2	tote
tule	4	57	3587	2	tule
vale	7	49	3734	2	vale
vile	7	61	3981	2	vile
voe	6	77	3905	2	vo_e
voile	8	47	1972	2	voile
voled	9	53	2372	2	voled
voles	8	62	3404	2	voles
volt	7	64	3953	2	volt
volte	8	53	2130	2	volte
vote	7	47	2862	2	vote
wale	7	45	4644	2	wale
whole	11	44	1809	2	whole
wile	7	59	4438	2	wile
woe	6	66	5124	2	wo_e
woke	11	55	2796	2	woke
wold	8	54	2907	2	wold
wolf	10	57	2956	2	wolf
wore	7	71	4467	2	wore
wove	10	56	2431	2	wove
wyle	10	55	1938	2	wyle
yodle	9	45	1504	2	yodle
yoke	11	56	2639	2	yoke
yolk	11	62	1899	2	yolk
yore	7	63	3594	2	yore
yowe	10	67	2874	2	yowe
yule	7	57	2514	2	yule
zone	13	52	3108	2	zone

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	29872	0.280	638182.1
2	DLD Change Limit	29872	458	0.860	34734.9
3	Display Results	458	458	0.110	4163.6
	(SQL Overall)	178691	458	1.250	142952.8