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

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

303 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
sold	5	48	3741	(None)
bold	7	54	3281	1	bold
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
scold	8	54	1486	1	scold
sild	5	50	3058	1	sild
sod	4	60	5370	1	so_d
sol	3	72	5662	1	sol_
sola	4	55	4186	1	sola
soldi	6	57	1719	1	soldi
soldo	6	71	1656	1	soldo
sole	4	60	5367	1	sole
soled	6	58	3517	1	soled
soli	4	66	3700	1	soli
solid	6	50	2507	1	solid
solo	4	55	3894	1	solo
sols	4	54	4816	1	sols
sord	5	62	3720	1	sord
told	5	61	3220	1	told
wold	8	54	2907	1	wold
acold	8	62	1492	2	acold
ahold	9	47	1425	2	ahold
auld	5	41	2536	2	auld
bald	7	64	3290	2	bald
bod	6	70	5554	2	bo_d
bola	6	60	3556	2	bola
bolds	8	58	2528	2	bolds
bole	6	64	4869	2	bole
boll	6	56	3475	2	boll
bolo	6	55	3595	2	bolo
bolt	6	62	5417	2	bolt
bond	7	53	3436	2	bond
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	4075	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	2810	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
kola	8	51	2496	2	kola
kolo	8	70	2622	2	kolo
load	5	67	3060	2	load
loid	5	55	3148	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	3084	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
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
resold	7	39	1536	2	resold
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
sad	4	74	5920	2	s_ad
said	5	57	4211	2	said
sal	3	64	6288	2	sal_
salad	6	53	2183	2	salad
sale	4	49	5970	2	sale
sall	4	45	4468	2	sall
salp	6	45	3409	2	salp
sals	4	68	5167	2	sals
salt	4	57	5852	2	salt
sand	5	53	3846	2	sand
sard	5	53	4424	2	sard
scad	7	57	2576	2	scad
scald	8	48	1812	2	scald
scolds	9	50	1123	2	scolds
scud	7	62	2128	2	scud
seed	5	55	4948	2	seed
sel	3	82	5332	2	sel_
self	7	51	3829	2	self
sell	4	58	4061	2	sell
sels	4	63	4598	2	sels
send	5	52	3729	2	send
shad	8	62	3091	2	shad
shed	8	65	3615	2	shed
shod	8	62	2505	2	shod
shoed	9	57	2300	2	shoed
should	10	3	802	2	should
silds	6	55	2052	2	silds
silk	8	55	2932	2	silk
sill	4	55	4515	2	sill
silo	4	60	3791	2	silo
silt	4	65	5819	2	silt
skald	10	42	1017	2	skald
skid	9	57	2091	2	skid
sled	5	53	3437	2	sled
slid	5	58	2898	2	slid
slob	6	60	2942	2	slob
sloe	4	55	3495	2	sloe
slog	5	67	2827	2	slog
sloid	6	46	1969	2	sloid
slojd	13	37	884	2	slojd
slop	6	65	3387	2	slop
slot	4	60	4982	2	slot
slow	7	77	2949	2	slow
sloyd	9	40	968	2	sloyd
sly	6	62	2856	2	s_ly
smolt	7	48	2416	2	smolt
sned	5	60	2605	2	sned
snood	6	46	1616	2	snood
so	2	88	5544	2	so__
soak	8	72	2766	2	soak
soap	6	58	3113	2	soap
soar	4	68	3867	2	soar
sob	5	78	5794	2	so_b
soba	6	49	2792	2	soba
sobs	6	49	4175	2	sobs
soca	6	63	3005	2	soca
sock	10	52	3321	2	sock
socle	7	4	1957	2	socle
soda	5	63	2938	2	soda
soddy	10	42	1070	2	soddy
sods	5	49	4021	2	sods
sofa	7	56	2560	2	sofa
soft	7	69	4282	2	soft
soil	4	61	3882	2	soil
soiled	7	38	2247	2	soiled
soils	5	53	2798	2	soils
soja	11	56	1951	2	soja
soke	8	54	3626	2	soke
solan	5	53	2815	2	solan
soland	7	51	1504	2	soland
solar	5	59	2734	2	solar
soldan	7	35	1185	2	soldan
solder	7	39	2134	2	solder
solei	5	56	2433	2	solei
soles	5	55	4792	2	soles
solidi	7	38	1315	2	solidi
solids	7	41	1640	2	solids
soloed	7	45	1574	2	soloed
solon	5	50	2613	2	solon
solos	5	48	3079	2	solos
solum	7	47	1760	2	solum
solus	5	47	2698	2	solus
solve	8	56	1894	2	solve
solved	10	53	1293	2	solved
som	5	91	5380	2	so_m
soma	6	56	3529	2	soma
some	6	60	4038	2	some
soms	6	62	3937	2	soms
son	3	77	6195	2	so_n
sonde	6	46	2283	2	sonde
sone	4	66	4998	2	sone
song	5	51	3367	2	song
sonly	8	57	1805	2	sonly
sons	4	60	4955	2	sons
sook	8	49	3339	2	sook
soon	4	62	4050	2	soon
soot	4	57	6105	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
sords	6	45	2780	2	sords
sore	4	70	5953	2	sore
sored	6	61	4178	2	sored
sori	4	60	3983	2	sori
sorn	4	66	4106	2	sorn
sort	4	62	6481	2	sort
sos	3	77	6160	2	so_s
sot	3	103	8429	2	so_t
soth	7	59	3251	2	soth
sots	4	55	5244	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
sound	6	44	2002	2	sound
soup	6	62	3291	2	soup
sour	4	59	3589	2	sour
sous	4	69	4721	2	sous
sow	6	65	5476	2	so_w
sowed	9	49	3386	2	sowed
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
sped	7	60	3149	2	sped
spud	7	58	1849	2	spud
stole	5	49	2881	2	stole
stoled	7	45	2159	2	stoled
stolid	7	42	1317	2	stolid
stood	6	55	1771	2	stood
stud	5	62	2009	2	stud
sudd	6	47	1977	2	sudd
sued	5	65	3793	2	sued
sulk	8	53	2665	2	sulk
sulu	4	51	2842	2	sulu
surd	5	64	3381	2	surd
sword	9	52	1411	2	sword
syli	7	43	1898	2	syli
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
unsold	7	14	1051	2	unsold
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	2060	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 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.080	2233637.5
2	DLD Change Limit	29872	303	1.000	29872.0
3	Display Results	303	303	0.076	3986.8
	(SQL Overall)	178691	303	1.156	154577.0