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

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

453 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
pole	6	59	5130	(None)
bole	6	64	4869	1	bole
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
ole	3	71	5521	1	_ole
pale	6	60	5501	1	pale
pele	6	55	3955	1	pele
pile	6	56	4969	1	pile
poke	10	53	3536	1	poke
pol	5	64	4938	1	pol_
poled	8	49	3484	1	poled
poler	7	44	3179	1	poler
poles	7	53	5100	1	poles
poll	6	63	3213	1	poll
polo	6	62	3663	1	polo
pols	6	60	4456	1	pols
poly	9	62	3515	1	poly
pome	8	56	3669	1	pome
pone	6	57	4753	1	pone
pope	8	55	3561	1	pope
pore	6	64	5126	1	pore
pose	6	64	4173	1	pose
prole	7	45	2779	1	prole
pule	6	50	4095	1	pule
role	4	58	5182	1	role
sole	4	60	5367	1	sole
tole	4	60	5290	1	tole
vole	7	52	3698	1	vole
able	6	63	4053	2	able
ale	3	65	7234	2	_ale
aloe	4	55	4019	2	aloe
amole	7	57	2459	2	amole
anole	5	53	3038	2	anole
apple	9	45	1767	2	apple
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
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
dhole	9	52	1536	2	dhole
dipole	9	11	1285	2	dipole
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
epode	8	51	1409	2	epode
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
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	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
pace	8	63	4577	2	pace
padle	8	45	2234	2	padle
page	7	60	3610	2	page
pal	5	67	6167	2	pal_
palea	7	50	2866	2	palea
paled	8	55	3872	2	paled
paler	7	54	3693	2	paler
pales	7	57	5380	2	pales
palet	7	46	5080	2	palet
pall	6	50	3934	2	pall
palm	8	53	3136	2	palm
palp	8	58	2857	2	palp
pals	6	69	5135	2	pals
paly	9	58	3553	2	paly
pane	6	49	5029	2	pane
pare	6	67	6084	2	pare
parle	7	58	3616	2	parle
parole	8	44	2525	2	parole
pase	6	53	4686	2	pase
pate	6	53	5046	2	pate
pave	9	61	3389	2	pave
pe	4	76	4903	2	p__e
pee	5	60	6651	2	p_ee
peel	6	55	3561	2	peel
peke	10	59	2620	2	peke
peles	7	57	3808	2	peles
pelf	9	70	3145	2	pelf
pelt	6	76	5108	2	pelt
people	10	3	1019	2	people
pere	6	64	5026	2	pere
phone	10	56	2193	2	phone
phyle	13	41	1115	2	phyle
pice	8	46	4109	2	pice
pie	5	54	5740	2	p_ie
pike	10	63	3521	2	pike
pilea	7	51	2395	2	pilea
piled	8	52	3299	2	piled
pilei	7	40	2178	2	pilei
piles	7	47	4261	2	piles
pili	6	61	3035	2	pili
pill	6	53	3946	2	pill
pily	9	61	3273	2	pily
pine	6	77	5571	2	pine
pinole	8	32	1878	2	pinole
piolet	8	32	2564	2	piolet
pipe	8	64	3443	2	pipe
plea	6	68	3060	2	p_lea
pleb	8	61	2381	2	p_leb
pled	7	52	3143	2	p_led
plew	9	72	2281	2	p_lew
plex	13	73	2137	2	p_lex
plie	6	51	2739	2	plie
plod	7	67	2327	2	plod
plop	8	66	2574	2	plop
plot	6	61	4123	2	plot
plow	9	59	2323	2	plow
ploy	9	61	2360	2	ploy
ply	8	63	2355	2	p_ly
pock	12	61	2929	2	pock
poco	8	68	2615	2	poco
pod	6	63	5148	2	po_d
pods	7	65	4015	2	pods
poem	8	62	2577	2	poem
poet	6	55	5290	2	poet
pogey	11	60	1789	2	pogey
pogy	10	56	2355	2	pogy
poh	8	67	4053	2	po_h
poi	5	72	4466	2	po_i
poilu	7	23	1600	2	poilu
pois	6	65	3904	2	pois
poise	7	51	2789	2	poise
poked	12	54	2539	2	poked
poker	11	51	2288	2	poker
pokes	11	61	3301	2	pokes
pokey	14	53	1897	2	pokey
poky	13	59	2215	2	poky
polar	7	56	2345	2	polar
polder	9	40	1925	2	polder
poleax	15	4	799	2	poleax
poleis	8	60	1835	2	poleis
polers	8	42	2564	2	polers
poleyn	11	5	732	2	poleyn
police	10	29	1856	2	police
polies	8	40	3458	2	polies
polio	7	57	2255	2	polio
polis	7	47	3116	2	polis
polite	8	36	2507	2	polite
polka	11	3	1041	2	polka
polled	9	40	2200	2	polled
pollee	8	36	2327	2	pollee
pollen	8	34	1645	2	pollen
poller	8	39	2185	2	poller
pollex	15	37	1116	2	pollex
polls	7	46	2772	2	polls
polos	7	61	2991	2	polos
polyp	12	56	1153	2	polyp
polys	10	57	1876	2	polys
pom	7	82	4991	2	po_m
pomes	9	48	3393	2	pomes
pomo	8	58	2845	2	pomo
pomp	10	62	2546	2	pomp
poms	8	70	3774	2	poms
ponce	9	52	2251	2	ponce
pond	7	55	3049	2	pond
pones	7	45	4704	2	pones
pong	7	62	3114	2	pong
pons	6	58	5060	2	pons
pony	9	64	3405	2	pony
poo	5	77	5711	2	po_o
pood	7	59	3432	2	pood
poodle	9	31	1204	2	poodle
pooed	8	52	2624	2	pooed
poof	9	55	4166	2	poof
pooh	9	60	2738	2	pooh
pool	6	58	3595	2	pool
pooled	9	46	1981	2	pooled
pooler	8	38	1984	2	pooler
pools	7	44	2770	2	pools
poon	6	73	4126	2	poon
poop	8	65	3281	2	poop
poor	6	56	3022	2	poor
poos	6	59	4911	2	poos
poove	10	45	1430	2	poove
pop	7	62	5225	2	po_p
popes	9	59	3381	2	popes
popple	9	27	1098	2	popple
pops	8	63	4095	2	pops
pored	8	52	3451	2	pored
pores	7	58	4903	2	pores
pork	10	69	2968	2	pork
porn	6	56	3602	2	porn
port	6	60	5963	2	port
posed	8	58	2841	2	posed
poser	7	51	2877	2	poser
poses	7	46	4276	2	poses
posh	9	54	2732	2	posh
posole	8	3	1422	2	posole
posse	7	47	2227	2	posse
post	6	79	5336	2	post
posy	9	60	2842	2	posy
pot	5	80	7843	2	po_t
pots	6	64	5236	2	pots
pottle	8	44	1610	2	pottle
pouf	9	57	3264	2	pouf
poult	7	69	2887	2	poult
pour	6	115	2747	2	pour
pout	6	57	5255	2	pout
pow	8	71	4728	2	po_w
power	10	53	2595	2	power
pows	9	55	3766	2	pows
pox	12	61	4069	2	po_x
poxed	15	48	1786	2	poxed
poxes	14	53	2572	2	poxes
poxy	16	68	2089	2	poxy
pozole	17	5	891	2	pozole
pree	6	70	4473	2	pree
probe	9	43	2081	2	probe
proleg	9	46	1211	2	proleg
proles	8	46	2720	2	proles
prone	7	53	3262	2	prone
prose	7	58	3512	2	prose
prove	10	48	2319	2	prove
psoae	7	44	1162	2	psoae
puce	8	51	2788	2	puce
puke	10	50	2546	2	puke
pul	5	61	3806	2	pul_
pula	6	51	2937	2	pula
puled	8	49	2652	2	puled
puler	7	48	2662	2	puler
pules	7	45	3881	2	pules
puli	6	55	2762	2	puli
pull	6	47	3166	2	pull
pulp	8	48	2535	2	pulp
puls	6	54	3756	2	puls
pulse	7	42	1997	2	pulse
pure	6	55	4333	2	pure
pye	8	64	3250	2	p_ye
pyre	9	49	2555	2	pyre
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
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
spale	7	49	2921	2	spale
spile	7	52	3008	2	spile
spode	8	46	1770	2	spode
spoke	11	48	1866	2	spoke
spore	7	54	2859	2	spore
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	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
whole	11	44	1809	2	whole
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 8 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	1.190	150160.5
2	DLD Change Limit	29872	453	4.156	7187.7
3	Display Results	453	453	0.623	727.1
	(SQL Overall)	178691	453	5.969	29936.5