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

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

472 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
sole	4	60	5367	(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
pole	6	59	5130	1	pole
role	4	58	5182	1	role
sale	4	49	5970	1	sale
sloe	4	55	3495	1	sloe
socle	7	4	1957	1	socle
soke	8	54	3626	1	soke
sol	3	72	5662	1	sol_
sola	4	55	4186	1	sola
sold	5	48	3741	1	sold
soled	6	58	3517	1	soled
solei	5	56	2434	1	solei
soles	5	55	4792	1	soles
soli	4	66	3701	1	soli
solo	4	55	3894	1	solo
sols	4	54	4816	1	sols
solve	8	56	1894	1	solve
some	6	60	4038	1	some
sone	4	66	4998	1	sone
sore	4	70	5953	1	sore
stole	5	49	2881	1	stole
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
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
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
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
insole	6	35	1586	2	insole
isle	4	51	2170	2	isle
istle	5	22	1471	2	istle
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
osmole	8	12	851	2	osmole
owe	6	70	4103	2	_owe
pale	6	60	5501	2	pale
pele	6	55	3955	2	pele
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
posole	8	3	1422	2	posole
prole	7	45	2779	2	prole
psoae	7	44	1162	2	psoae
pule	6	50	4095	2	pule
rale	4	50	5056	2	rale
resole	6	46	2418	2	resole
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
sabe	6	61	4057	2	sabe
sable	7	47	3216	2	sable
sade	5	55	4447	2	sade
sae	3	83	6518	2	s_ae
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
sake	8	52	4496	2	sake
sal	3	64	6288	2	sal_
salep	7	70	2295	2	salep
sales	5	60	5559	2	sales
sall	4	45	4468	2	sall
salp	6	45	3409	2	salp
sals	4	68	5167	2	sals
salt	4	57	5852	2	salt
salve	8	50	2213	2	salve
same	6	52	4564	2	same
sane	4	59	5434	2	sane
sate	4	55	5610	2	sate
save	7	57	4136	2	save
scale	7	46	2914	2	scale
scold	8	54	1486	2	scold
scolex	15	3	824	2	scolex
scone	7	46	2183	2	scone
scope	9	48	2148	2	scope
score	7	55	2673	2	score
see	3	57	7226	2	s_ee
seel	4	50	4298	2	seel
sel	3	82	5332	2	sel_
self	7	51	3829	2	self
sell	4	58	4061	2	sell
selle	5	44	2831	2	selle
sels	4	63	4598	2	sels
seme	6	58	3665	2	seme
sene	4	68	4805	2	sene
sere	4	61	5347	2	sere
shale	8	53	3283	2	shale
she	6	68	3769	2	s_he
shlep	10	49	1483	2	shlep
shoe	7	59	3344	2	shoe
shone	8	37	2598	2	shone
shore	8	54	3265	2	shore
shote	8	55	2610	2	shote
shove	11	44	2104	2	shove
sice	6	55	4559	2	sice
side	5	54	4448	2	side
sidle	6	51	2403	2	sidle
sike	8	71	3878	2	sike
sild	5	50	3058	2	sild
silex	12	34	1741	2	silex
silk	8	55	2932	2	silk
sill	4	55	4515	2	sill
silo	4	60	3791	2	silo
silt	4	65	5819	2	silt
sine	4	65	6062	2	sine
sipe	6	73	4104	2	sipe
sire	4	61	5041	2	sire
site	4	70	5241	2	site
size	13	56	3096	2	size
skee	8	54	3147	2	skee
sled	5	53	3437	2	s_led
slew	7	62	2823	2	s_lew
slob	6	60	2942	2	slob
sloes	5	47	2887	2	sloes
slog	5	67	2827	2	slog
slop	6	65	3387	2	slop
slope	7	58	2356	2	slope
slot	4	60	4983	2	slot
slow	7	77	2949	2	slow
slue	4	53	3219	2	slue
sly	6	62	2856	2	s_ly
smile	7	48	2392	2	smile
smoke	11	50	1582	2	smoke
smolt	7	48	2416	2	smolt
smote	7	58	2028	2	smote
snore	5	54	2495	2	snore
snye	7	71	1549	2	snye
so	2	88	5544	2	so__
soak	8	72	2766	2	soak
soap	6	58	3113	2	soap
soar	4	68	3867	2	soar
soave	8	42	1905	2	soave
sob	5	78	5794	2	so_b
soba	6	49	2792	2	soba
sober	7	48	2241	2	sober
sobs	6	49	4175	2	sobs
soca	6	63	3005	2	soca
sock	10	52	3321	2	sock
socles	8	4	1845	2	socles
sod	4	60	5370	2	so_d
soda	5	63	2938	2	soda
sods	5	49	4021	2	sods
sofa	7	56	2560	2	sofa
soft	7	69	4282	2	soft
soil	4	61	3883	2	soil
soiled	7	38	2247	2	soiled
soils	5	53	2798	2	soils
soja	11	56	1951	2	soja
sokes	9	50	3142	2	sokes
solace	8	34	1582	2	solace
solan	5	53	2815	2	solan
solar	5	59	2734	2	solar
solate	6	45	2607	2	solate
solder	7	39	2134	2	solder
soldi	6	57	1720	2	soldi
soldo	6	71	1656	2	soldo
solely	9	37	1421	2	solely
solemn	8	3	864	2	solemn
soleus	6	46	1561	2	soleus
solgel	7	3	796	2	solgel
solid	6	50	2508	2	solid
soloed	7	45	1574	2	soloed
solon	5	50	2613	2	solon
solos	5	48	3079	2	solos
solum	7	47	1761	2	solum
solus	5	47	2698	2	solus
solute	6	40	1666	2	solute
solved	10	53	1293	2	solved
solver	9	40	1670	2	solver
solves	9	50	1822	2	solves
som	5	91	5381	2	so_m
soma	6	56	3529	2	soma
soms	6	62	3937	2	soms
son	3	77	6195	2	so_n
sonde	6	46	2283	2	sonde
sones	5	54	4414	2	sones
song	5	51	3367	2	song
sonly	8	57	1805	2	sonly
sons	4	60	4955	2	sons
sooey	8	45	2243	2	sooey
sook	8	49	3339	2	sook
soon	4	62	4050	2	soon
soot	4	57	6106	2	soot
sop	5	75	5786	2	so_p
soph	9	70	2420	2	soph
sops	6	52	4456	2	sops
sora	4	57	4691	2	sora
sorb	6	83	3304	2	sorb
sord	5	62	3720	2	sord
sored	6	61	4178	2	sored
sorel	5	62	3144	2	sorel
sorer	5	62	3658	2	sorer
sores	5	54	5428	2	sores
sori	4	60	3984	2	sori
sorn	4	66	4106	2	sorn
sort	4	62	6481	2	sort
sos	3	77	6160	2	so_s
sot	3	103	8430	2	so_t
soth	7	59	3252	2	soth
sots	4	55	5245	2	sots
sou	3	78	5369	2	so_u
souk	8	61	2717	2	souk
soul	4	64	3571	2	soul
souled	7	54	1982	2	souled
souls	5	51	2736	2	souls
soup	6	62	3291	2	soup
sour	4	59	3589	2	sour
sous	4	69	4721	2	sous
souse	5	65	3077	2	souse
sow	6	65	5476	2	so_w
sowed	9	49	3386	2	sowed
sower	8	52	2931	2	sower
sown	7	51	2745	2	sown
sows	7	53	4249	2	sows
sox	10	64	4419	2	so_x
soy	6	78	5145	2	so_y
soya	7	57	2443	2	soya
soys	7	52	3393	2	soys
spae	6	50	3432	2	spae
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
spue	6	60	2552	2	spue
stale	5	56	3710	2	stale
stele	5	50	2684	2	stele
stile	5	49	3157	2	stile
stoae	5	50	2426	2	stoae
stoke	9	49	2251	2	stoke
stoled	7	45	2159	2	stoled
stolen	6	43	1506	2	stolen
stoles	6	39	2767	2	stoles
stone	5	54	3118	2	stone
stope	7	47	2724	2	stope
store	5	63	3381	2	store
stove	8	52	2025	2	stove
stye	7	62	1897	2	stye
style	8	55	1936	2	style
sue	3	56	5146	2	s_ue
sulk	8	53	2665	2	sulk
sulu	4	51	2842	2	sulu
supe	6	59	3276	2	supe
sure	4	54	4741	2	sure
swale	8	52	2159	2	swale
swore	8	49	2081	2	swore
syce	9	58	2028	2	syce
syke	11	54	2056	2	syke
syli	7	43	1898	2	syli
syne	7	57	2576	2	syne
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 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.063	2836365.1
2	DLD Change Limit	29872	472	0.843	35435.3
3	Display Results	472	472	0.110	4290.9
	(SQL Overall)	178691	472	1.016	175877.0