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

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

437 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
hole	7	75	5339	(None)
bole	6	64	4869	1	bole
cole	6	69	5611	1	cole
dhole	9	52	1536	1	dhole
dole	5	65	5000	1	dole
hale	7	60	5283	1	hale
haole	8	48	2008	1	haole
hoe	6	75	6272	1	ho_e
hoke	11	59	3593	1	hoke
hold	8	62	3506	1	hold
holed	9	56	3413	1	holed
holes	8	47	4865	1	holes
holey	11	56	2690	1	holey
holk	11	60	2794	1	holk
holm	9	56	2811	1	holm
holp	9	57	2755	1	holp
hols	7	69	4629	1	hols
holt	7	78	5258	1	holt
holy	10	63	3343	1	holy
home	9	80	4244	1	home
hone	7	75	4932	1	hone
hope	9	66	3967	1	hope
hose	7	65	4724	1	hose
hove	10	71	3222	1	hove
howe	10	67	3410	1	howe
hoyle	11	3	1441	1	hoyle
jole	11	72	3382	1	jole
mole	6	62	5183	1	mole
ole	3	71	5521	1	_ole
pole	6	59	5130	1	pole
role	4	58	5182	1	role
sole	4	60	5367	1	sole
thole	8	56	2084	1	thole
tole	4	60	5290	1	tole
vole	7	52	3698	1	vole
whole	11	44	1809	1	whole
able	6	63	4053	2	able
ahold	9	47	1425	2	ahold
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
bale	6	63	5384	2	bale
bile	6	61	4718	2	bile
bode	7	58	3875	2	bode
bogle	8	58	2168	2	bogle
bola	6	60	3556	2	bola
bold	7	54	3281	2	bold
boles	7	54	4860	2	boles
boll	6	56	3475	2	boll
bolo	6	55	3595	2	bolo
bolt	6	62	5417	2	bolt
bone	6	59	4932	2	bone
bore	6	60	5133	2	bore
boule	7	48	2804	2	boule
chile	10	56	2689	2	chile
choke	14	51	1802	2	choke
chola	10	47	1803	2	chola
choler	11	37	1715	2	choler
cholo	10	52	1797	2	cholo
chore	10	51	2676	2	chore
chose	10	59	2540	2	chose
chyle	13	49	1348	2	chyle
coble	9	48	2317	2	coble
code	7	73	4773	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
dholes	10	49	1479	2	dholes
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	4664	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
hade	8	54	4019	2	hade
hae	6	73	6400	2	h_ae
hake	11	56	3784	2	hake
haled	9	53	3582	2	haled
haler	8	50	3352	2	haler
hales	8	54	4984	2	hales
half	10	62	3845	2	half
hall	7	57	4116	2	hall
halm	9	58	3497	2	halm
halo	7	64	3732	2	halo
halt	7	60	5630	2	halt
halve	11	48	1892	2	halve
hame	9	70	4313	2	hame
haoles	9	49	1980	2	haoles
hare	7	62	5573	2	hare
hate	7	84	5017	2	hate
have	10	61	3707	2	have
haze	16	48	3339	2	haze
he	5	81	5195	2	h__e
hebe	9	64	2470	2	hebe
heel	7	50	3422	2	heel
held	8	53	3040	2	held
hell	7	56	3789	2	hell
helm	9	55	3002	2	helm
helo	7	53	3285	2	helo
help	9	53	2892	2	help
helve	11	50	1809	2	helve
heme	9	50	3441	2	heme
here	7	64	4710	2	here
hide	8	51	3464	2	hide
hie	6	76	5270	2	h_ie
hike	11	68	3039	2	hike
hila	7	62	2835	2	hila
hili	7	56	2663	2	hili
hill	7	64	3949	2	hill
hilt	7	58	5071	2	hilt
hire	7	55	3896	2	hire
hive	10	60	2967	2	hive
ho	5	102	5827	2	ho__
hoar	7	67	2916	2	hoar
hoax	14	77	1829	2	hoax
hob	8	75	5092	2	ho_b
hobble	13	39	1343	2	hobble
hobo	9	70	2608	2	hobo
hobs	9	70	3898	2	hobs
hock	13	60	3130	2	hock
hod	7	68	5246	2	ho_d
hods	8	72	3986	2	hods
hoed	8	78	3798	2	hoed
hoer	7	65	3398	2	hoer
hoes	7	57	5573	2	hoes
hog	7	80	4906	2	ho_g
hogg	9	66	1753	2	hogg
hogs	8	71	3966	2	hogs
hoise	8	52	2477	2	hoise
hoked	13	53	2699	2	hoked
hokes	12	62	3164	2	hokes
hokey	15	54	2218	2	hokey
holden	10	41	1395	2	holden
holder	10	46	1965	2	holder
holds	9	46	2324	2	holds
holier	9	49	2162	2	holier
holies	9	46	3003	2	holies
holked	14	49	1366	2	holked
holks	12	47	2056	2	holks
holla	8	49	1849	2	holla
holler	9	35	2061	2	holler
hollo	8	48	2216	2	hollo
holly	11	48	2443	2	holly
holms	10	51	1780	2	holms
holpen	11	29	941	2	holpen
holts	8	56	2791	2	holts
homed	11	54	2542	2	homed
homer	10	58	2845	2	homer
homes	10	69	3881	2	homes
homey	13	59	2484	2	homey
homie	10	46	2253	2	homie
homo	9	61	2647	2	homo
homy	12	66	2322	2	homy
hon	6	77	5938	2	ho_n
hondle	10	39	1452	2	hondle
honed	9	53	3226	2	honed
honer	8	53	3209	2	honer
hones	8	81	4449	2	hones
honey	11	56	2991	2	honey
hong	8	58	3395	2	hong
honk	11	69	3119	2	honk
hons	7	73	5078	2	hons
hood	8	51	3233	2	hood
hooey	11	49	2660	2	hooey
hoof	10	60	3658	2	hoof
hook	11	61	3328	2	hook
hoolie	9	32	1778	2	hoolie
hooly	11	50	2222	2	hooly
hoop	9	61	2998	2	hoop
hoot	7	57	5210	2	hoot
hop	8	75	5459	2	ho_p
hoped	11	56	2818	2	hoped
hoper	10	58	2914	2	hoper
hopes	10	58	3564	2	hopes
hopple	13	29	1048	2	hopple
hops	9	79	4263	2	hops
hora	7	61	3656	2	hora
horde	9	46	2305	2	horde
horn	7	67	3561	2	horn
horse	8	61	3265	2	horse
hos	6	83	6419	2	ho_s
hosed	9	58	3098	2	hosed
hosel	8	60	2481	2	hosel
hosen	8	56	2388	2	hosen
hoser	8	115	2976	2	hoser
hoses	8	54	4317	2	hoses
hosey	11	61	2702	2	hosey
host	7	78	5283	2	host
hot	6	77	7606	2	ho_t
hotel	8	55	2075	2	hotel
hotly	11	58	1548	2	hotly
hots	7	83	4933	2	hots
hour	7	58	2731	2	hour
house	8	91	3142	2	house
hovel	11	50	1768	2	hovel
hover	11	55	2413	2	hover
how	9	72	5243	2	ho_w
howes	11	47	3026	2	howes
howf	13	61	2720	2	howf
howk	14	52	2196	2	howk
howl	10	76	2569	2	howl
howled	13	40	1497	2	howled
howler	12	35	1431	2	howler
howlet	12	35	1834	2	howlet
howls	11	62	1922	2	howls
hows	10	63	4560	2	hows
hoy	9	74	4791	2	ho_y
hoya	10	74	1837	2	hoya
hoyles	12	3	1501	2	hoyles
hoys	10	77	3393	2	hoys
hue	6	66	4230	2	h_ue
huge	8	63	2165	2	huge
hula	7	49	2375	2	hula
hulk	11	53	2161	2	hulk
hull	7	54	2878	2	hull
hyla	10	67	1651	2	hyla
hype	12	55	1981	2	hype
hyte	10	90	1894	2	hyte
idle	5	54	2376	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	3375	2	kale
koel	8	45	1994	2	koel
kola	8	51	2496	2	kola
kolo	8	70	2622	2	kolo
kore	8	58	3416	2	kore
lobe	6	55	3536	2	lobe
lode	5	62	4011	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	5257	2	mile
mode	7	58	4030	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	3688	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
obole	7	59	1714	2	obole
ode	4	74	4658	2	_ode
oe	2	84	7306	2	_o_e
ogle	5	63	2505	2	ogle
oke	7	58	3948	2	_oke
old	4	70	3346	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
phone	10	56	2193	2	phone
phyle	13	41	1115	2	phyle
pile	6	56	4969	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	5053	2	rile
robe	6	53	3564	2	robe
roble	7	52	2302	2	roble
rode	5	58	4430	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
shale	8	53	3283	2	shale
shoe	7	59	3344	2	sho_e
shone	8	37	2598	2	shone
shore	8	54	3265	2	shore
shote	8	55	2610	2	shote
shove	11	44	2104	2	shove
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
tholed	10	51	1387	2	tholed
tholes	9	49	1978	2	tholes
those	8	52	1814	2	those
tile	4	54	5144	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	3980	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	4643	2	wale
whale	11	55	1743	2	whale
while	11	54	1869	2	while
wholes	12	46	1677	2	wholes
whore	11	60	1804	2	whore
whose	11	49	1453	2	whose
wile	7	59	4437	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.296	603685.8
2	DLD Change Limit	29872	437	0.766	38997.4
3	Display Results	437	437	0.110	3972.7
	(SQL Overall)	178691	437	1.172	152466.7