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

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

293 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
sned	5	60	2605	(None)
saned	6	56	3627	1	saned
seed	5	55	4948	1	seed
send	5	52	3729	1	send
shed	8	65	3615	1	shed
sled	5	53	3437	1	sled
sneds	6	57	1535	1	sneds
sped	7	60	3149	1	sped
sued	5	65	3793	1	sued
abed	7	97	3413	2	abed
aced	7	95	4088	2	aced
acned	8	75	2067	2	acned
aged	6	73	3425	2	aged
ahed	8	95	3625	2	ahed
and	4	72	4417	2	an_d
ane	3	78	6695	2	ane_
anes	4	52	5593	2	anes
anew	7	66	2313	2	anew
anted	6	63	2824	2	anted
aped	7	85	3815	2	aped
ashed	9	78	2977	2	ashed
asked	10	69	1931	2	asked
awed	8	84	3603	2	awed
awned	9	66	1595	2	awned
axed	12	88	2961	2	axed
baned	8	54	3635	2	baned
bed	6	79	5062	2	_bed
bend	7	64	3526	2	bend
bled	7	57	2931	2	bled
boned	8	51	3324	2	boned
bred	7	51	3097	2	bred
caned	8	58	3809	2	caned
coed	7	71	4054	2	coed
coned	8	60	4005	2	coned
cred	7	65	3088	2	cred
cued	7	63	2956	2	cued
deed	6	53	4090	2	deed
died	6	61	3785	2	died
dined	7	64	3199	2	dined
dyed	9	67	2076	2	dyed
ed	3	86	4518	2	__ed
eked	9	67	1802	2	eked
end	4	68	3435	2	en_d
ended	7	44	2126	2	ended
esne	4	70	1879	2	esne_
esnes	5	48	1736	2	esnes
exed	12	54	2059	2	exed
eyed	8	66	2323	2	eyed
fed	7	65	4835	2	_fed
feed	8	45	3890	2	feed
fend	8	48	3297	2	fend
fined	9	49	3050	2	fined
fled	8	54	2977	2	fled
gaed	6	60	3151	2	gaed
ged	5	70	4453	2	_ged
geed	6	54	3550	2	geed
gied	6	46	3198	2	gied
gled	6	56	3114	2	gled
haed	8	63	3858	2	haed
heed	8	64	3760	2	heed
hied	8	54	3404	2	hied
hoed	8	78	3798	2	hoed
honed	9	53	3226	2	honed
hued	8	69	2585	2	hued
iced	7	87	2189	2	iced
inked	10	42	1852	2	inked
inned	6	41	1842	2	inned
ired	5	51	3187	2	ired
isled	6	46	1599	2	isled
jeed	12	54	2850	2	jeed
knead	10	42	966	2	knead
knee	8	53	2360	2	knee
kneed	10	46	1205	2	kneed
knew	11	59	1212	2	knew
led	4	62	5455	2	_led
lend	5	62	3367	2	lend
lied	5	58	3809	2	lied
lined	6	49	3464	2	lined
maned	8	66	3410	2	maned
med	6	61	4674	2	_med
meed	7	49	3470	2	meed
mend	7	53	3403	2	mend
mined	8	53	3335	2	mined
ne	2	70	4510	2	_ne_
neb	5	72	3862	2	_neb
nee	3	66	5778	2	_nee
need	5	49	3415	2	need
neg	4	72	3734	2	_neg
nerd	5	66	2494	2	_nerd
net	3	66	7029	2	_net
new	6	62	3709	2	_new
nod	4	75	4956	2	_nod
ohed	8	78	2518	2	ohed
one	3	70	5091	2	one_
ones	4	61	4653	2	ones
oped	7	62	3015	2	oped
owed	8	68	3387	2	owed
owned	9	51	1323	2	owned
paned	8	54	3718	2	paned
ped	6	67	5152	2	_ped
peed	7	62	3918	2	peed
pend	7	59	3453	2	pend
pied	7	50	3536	2	pied
pined	8	59	3532	2	pined
pled	7	52	3143	2	pled
red	4	67	5580	2	_red
reed	5	55	4962	2	reed
rend	5	61	3657	2	rend
rued	5	57	2979	2	rued
sabed	8	65	2681	2	sabed
sad	4	74	5920	2	s_ad
sade	5	55	4447	2	sade
sae	3	83	6518	2	sae_
said	5	57	4211	2	said
sained	7	54	2424	2	sained
sand	5	53	3847	2	sand
sanded	8	49	2061	2	sanded
sane	4	59	5434	2	sane_
saner	5	43	3432	2	saner
sanes	5	56	4907	2	sanes
sard	5	53	4424	2	sard
sated	6	62	3853	2	sated
saved	9	51	2711	2	saved
sawed	9	56	2840	2	sawed
sayed	9	61	2714	2	sayed
scad	7	57	2577	2	scad
scend	8	55	1629	2	scend
scud	7	62	2128	2	scud
sea	3	61	6129	2	s_ea
sec	5	59	4532	2	s_ec
see	3	57	7226	2	s_ee
seeds	6	43	3006	2	seeds
seedy	9	48	2153	2	seedy
seek	8	59	3548	2	seek
seel	4	50	4298	2	seel
seem	6	54	3856	2	seem
seen	4	69	4312	2	seen
seep	6	65	4034	2	seep
seer	4	55	4704	2	seer
sees	4	53	6105	2	sees
seg	4	55	4488	2	s_eg
sei	3	60	4893	2	s_ei
seined	7	40	2306	2	seined
sel	3	82	5332	2	s_el
sen	3	60	5852	2	s_en
sended	8	51	2123	2	sended
sends	6	55	2824	2	sends
sene	4	68	4805	2	sene
sensed	7	39	1816	2	sensed
sent	4	69	6301	2	sent
ser	3	67	5240	2	s_er
sered	6	57	3729	2	sered
set	3	66	8125	2	s_et
sew	6	62	4726	2	s_ew
sewed	9	53	2516	2	sewed
sex	10	70	4322	2	s_ex
sexed	13	66	1854	2	sexed
shad	8	62	3091	2	shad
she	6	68	3769	2	she_
shea	7	60	3157	2	shea
sheds	9	61	2270	2	sheds
shend	9	47	1997	2	shend
sherd	9	63	2115	2	sherd
shes	7	57	3435	2	shes
shew	10	80	3076	2	shew
shied	9	61	2549	2	shied
shined	10	46	2078	2	shined
shod	8	62	2506	2	shod
shoed	9	57	2301	2	shoed
shred	9	81	2561	2	shred
side	5	54	4449	2	side
sided	7	48	2595	2	sided
signed	8	34	1375	2	signed
sild	5	50	3058	2	sild
sine	4	65	6062	2	sine_
sines	5	59	5482	2	sines
sinew	8	47	1892	2	sinew
singed	8	54	2229	2	singed
sinned	7	38	1841	2	sinned
siped	8	49	2768	2	siped
sired	6	61	3428	2	sired
sited	6	51	3074	2	sited
sized	15	55	1924	2	sized
skee	8	54	3147	2	skee
skeed	10	50	1898	2	skeed
skeg	9	53	1616	2	skeg
skep	10	52	1935	2	skep
skew	11	62	1876	2	skew
skid	9	57	2093	2	skid
skied	10	44	1775	2	skied
skyed	13	52	992	2	skyed
sleds	6	44	1885	2	sleds
slew	7	62	2823	2	slew
slid	5	58	2898	2	slid
slued	6	42	2051	2	slued
smew	9	50	1773	2	smew
snag	5	58	2787	2	snag
snaked	11	50	1759	2	snaked
snap	6	57	2703	2	snap
snared	7	48	2455	2	snared
snaw	7	89	2307	2	snaw
snawed	10	48	1373	2	snawed
sneak	9	60	1617	2	sneak
sneap	7	55	1482	2	sneap
sneck	11	47	1366	2	sneck
sneer	5	49	1995	2	sneer
snell	5	45	1730	2	snell
snib	6	65	2298	2	snib
snide	6	43	1872	2	snide
snip	6	64	2465	2	snip
sniped	9	49	1348	2	sniped
snit	4	63	4247	2	snit
snob	6	58	2559	2	snob
snog	5	56	2363	2	snog
snood	6	46	1616	2	snood
snored	7	48	1954	2	snored
snot	4	47	4545	2	snot
snow	7	63	2479	2	snow
snowed	10	46	1362	2	snowed
snub	6	53	2076	2	snub
snug	5	52	1869	2	snug
snye	7	71	1549	2	snye
snyes	8	50	1275	2	snyes
sod	4	60	5370	2	s_od
sold	5	48	3741	2	sold
soled	6	58	3517	2	soled
sonde	6	46	2283	2	sonde
sone	4	66	4998	2	sone_
sones	5	54	4414	2	sones
sord	5	62	3720	2	sord
sored	6	61	4178	2	sored
sorned	7	48	2004	2	sorned
sowed	9	49	3386	2	sowed
spaed	8	55	2227	2	spaed
spec	8	58	2197	2	spec
speed	8	55	2662	2	speed
spend	8	56	1933	2	spend
spew	9	54	2187	2	spew
spied	8	54	2771	2	spied
spined	9	54	2394	2	spined
spud	7	58	1849	2	spud
spued	8	49	1847	2	spued
staned	7	48	2464	2	staned
stead	6	55	2027	2	stead
steed	6	60	2494	2	steed
stem	6	106	2825	2	stem
step	6	71	2629	2	step
stet	4	59	4732	2	stet
stew	7	75	2546	2	stew
stey	7	62	2441	2	stey
stied	6	57	2303	2	stied
stoned	7	59	2314	2	stoned
stud	5	62	2009	2	stud
styed	9	58	1548	2	styed
sudd	6	47	1977	2	sudd
sue	3	56	5146	2	sue_
suede	6	44	1975	2	suede
suer	4	53	3403	2	suer
sues	4	62	4765	2	sues
suet	4	67	5482	2	suet
sunned	7	42	1632	2	sunned
surd	5	64	3381	2	surd
swede	9	44	1320	2	swede
synced	12	26	696	2	synced
syne	7	57	2576	2	syne_
synod	9	6	1028	2	synod
ted	4	64	4656	2	_ted
teed	5	54	3926	2	teed
tend	5	64	3377	2	tend
tied	5	55	3521	2	tied
tined	6	54	3453	2	tined
toed	5	61	3704	2	toed
toned	6	54	3534	2	toned
tsked	10	59	1003	2	tsked
tuned	6	46	2231	2	tuned
tyned	9	59	1501	2	tyned
unde	5	58	2548	2	unde
unfed	9	46	1422	2	unfed
unled	6	40	2107	2	unled
unwed	9	41	1487	2	unwed
used	5	57	2282	2	used
usnea	5	3	939	2	usnea
vaned	9	46	2242	2	vaned
vend	8	66	2642	2	vend
vied	8	63	2863	2	vied
vined	9	56	2615	2	vined
waned	9	58	3178	2	waned
wed	7	58	4362	2	_wed
weed	8	56	3751	2	weed
wend	8	53	3045	2	wend
wined	9	44	3418	2	wined
zed	13	54	3117	2	_zed
zoned	15	40	2026	2	zoned

Search took 3 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.546	327272.9
2	DLD Change Limit	29872	293	1.826	16359.3
3	Display Results	293	293	0.140	2092.9
	(SQL Overall)	178691	293	2.512	71135.0