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

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

352 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
weed	8	56	3751	(None)
deed	6	53	4090	1	deed
feed	8	45	3890	1	feed
geed	6	54	3550	1	geed
heed	8	64	3760	1	heed
jeed	12	54	2850	1	jeed
meed	7	49	3470	1	meed
need	5	49	3415	1	need
peed	7	62	3918	1	peed
reed	5	55	4962	1	reed
seed	5	55	4948	1	seed
teed	5	54	3926	1	teed
tweed	9	49	1509	1	tweed
wed	7	58	4362	1	w_ed
wee	6	67	6081	1	wee_
weeds	9	52	2221	1	weeds
weedy	12	51	1500	1	weedy
week	11	64	2815	1	week
weel	7	58	3408	1	weel
ween	7	58	3546	1	ween
weep	9	51	3165	1	weep
weer	7	55	3509	1	weer
wees	7	62	4912	1	wees
weet	7	52	5415	1	weet
weld	8	47	2773	1	weld
wend	8	53	3045	1	wend
abed	7	97	3413	2	abed
aced	7	95	4088	2	aced
aged	6	73	3425	2	aged
ahed	8	95	3625	2	ahed
aped	7	85	3815	2	aped
awed	8	84	3603	2	awed
awee	7	63	3664	2	awee_
awned	9	66	1595	2	awned
axed	12	88	2961	2	axed
bead	7	59	3792	2	bead
bed	6	79	5062	2	_bed
bee	5	62	6240	2	bee_
beedi	8	7	1166	2	beedi
beef	9	62	3368	2	beef
been	6	53	3578	2	been
beep	8	59	3121	2	beep
beer	6	56	3599	2	beer
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
bend	7	64	3526	2	bend
bled	7	57	2931	2	bled
bleed	8	50	1980	2	bleed
bred	7	51	3097	2	bred
breed	8	55	2669	2	breed
cede	7	49	2877	2	cede
ceded	9	61	1856	2	ceded
cee	5	59	5270	2	cee_
cees	6	59	4159	2	cees
cered	8	52	2744	2	cered
coed	7	71	4054	2	coed
cred	7	65	3088	2	cred
creed	8	57	2739	2	creed
cued	7	63	2956	2	cued
dead	6	54	3424	2	dead
dee	4	76	6582	2	dee_
deeds	7	54	2376	2	deeds
deedy	10	43	1589	2	deedy
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
deked	11	57	1853	2	deked
deled	7	53	2654	2	deled
dewed	10	50	2030	2	dewed
died	6	61	3785	2	died
dreed	7	52	2284	2	dreed
dweeb	11	3	774	2	dweeb
dyed	9	67	2076	2	dyed
ed	3	86	4518	2	__ed
eek	7	79	3510	2	_eek
eel	3	79	4684	2	_eel
eked	9	67	1802	2	eked
eld	4	67	3379	2	_eld
end	4	68	3435	2	_end
ewe	6	66	3098	2	ewe_
ewer	7	75	2398	2	ewer
ewes	7	63	2870	2	ewes
exed	12	54	2059	2	exed
eyed	8	66	2323	2	eyed
fed	7	65	4835	2	_fed
fee	6	68	6201	2	fee_
feeb	9	69	2454	2	feeb
feeds	9	49	2114	2	feeds
feel	7	52	3384	2	feel
fees	7	64	5060	2	fees
feet	7	53	5221	2	feet
fend	8	48	3297	2	fend
feod	8	155	2300	2	feod
feted	9	44	2093	2	feted
feud	8	65	2302	2	feud
feued	9	47	1566	2	feued
fled	8	54	2977	2	fled
freed	9	52	2354	2	freed
gaed	6	60	3151	2	gaed
ged	5	70	4453	2	_ged
gee	4	53	5920	2	gee_
geek	9	53	2702	2	geek
gees	5	56	4788	2	gees
geez	14	64	2486	2	geez
geld	6	58	2843	2	geld
gied	6	46	3198	2	gied
gled	6	56	3114	2	gled
gleed	7	53	2057	2	gleed
greed	7	51	2569	2	greed
haed	8	63	3858	2	haed
head	8	71	3717	2	head
heeds	9	54	2042	2	heeds
heel	7	50	3422	2	heel
held	8	53	3040	2	held
herd	8	49	3306	2	herd
hewed	12	56	1943	2	hewed
hexed	16	56	1576	2	hexed
hied	8	54	3404	2	hied
hoed	8	78	3798	2	hoed
hued	8	69	2585	2	hued
iced	7	87	2189	2	iced
ired	5	51	3187	2	ired
jee	10	66	4864	2	jee_
jeep	13	56	2484	2	jeep
jeer	11	54	2646	2	jeer
jees	11	59	3854	2	jees
jeez	20	56	2203	2	jeez
jewed	16	51	1483	2	jewed
keef	11	58	3000	2	keef
keek	7	56	2497	2	keek
keel	8	57	2947	2	keel
keen	8	48	3041	2	keen
keep	10	63	2982	2	keep
keet	8	53	4734	2	keet
keyed	13	6	939	2	keyed
kneed	10	46	1205	2	kneed
lead	5	60	3885	2	lead
led	4	62	5455	2	_led
lee	3	60	6814	2	lee_
leek	8	53	3173	2	leek
leer	4	62	3935	2	leer
lees	4	54	5588	2	lees
leet	4	59	5790	2	leet
lend	5	62	3367	2	lend
leud	5	72	2342	2	leud
lewd	8	57	1659	2	lewd
lied	5	58	3809	2	lied
mead	7	55	3160	2	mead
med	6	61	4674	2	_med
meeds	8	49	2027	2	meeds
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
meld	7	58	3047	2	meld
mend	7	53	3403	2	mend
meted	8	54	2443	2	meted
mewed	11	52	1801	2	mewed
nee	3	66	5778	2	nee_
needs	6	57	1963	2	needs
needy	9	46	1469	2	needy
neem	6	73	2808	2	neem
neep	6	57	2831	2	neep
nerd	5	66	2494	2	nerd
ohed	8	78	2518	2	ohed
oped	7	62	3015	2	oped
owed	8	68	3387	2	owed
owned	9	51	1323	2	owned
ped	6	67	5152	2	_ped
pee	5	60	6651	2	pee_
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
pees	6	52	5737	2	pees
pend	7	59	3453	2	pend
pied	7	50	3536	2	pied
pled	7	52	3143	2	pled
preed	8	51	2812	2	preed
read	5	59	4253	2	read
red	4	67	5580	2	_red
redd	6	63	2317	2	redd
rede	5	50	3767	2	rede
reded	7	48	2912	2	reded
ree	3	79	7407	2	ree_
reeds	6	54	3090	2	reeds
reedy	9	100	2029	2	reedy
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
refed	9	39	2192	2	refed
rend	5	61	3657	2	rend
rewed	9	54	2545	2	rewed
rued	5	57	2979	2	rued
see	3	57	7226	2	see_
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
send	5	52	3729	2	send
sered	6	57	3729	2	sered
sewed	9	53	2516	2	sewed
sexed	13	66	1854	2	sexed
shed	8	65	3615	2	shed
skeed	10	50	1898	2	skeed
sled	5	53	3437	2	sled
sned	5	60	2605	2	sned
sped	7	60	3149	2	sped
speed	8	55	2662	2	speed
steed	6	60	2494	2	steed
sued	5	65	3793	2	sued
swede	9	44	1320	2	swede
sweep	10	47	1572	2	sweep
sweer	8	49	1857	2	sweer
sweet	8	53	3052	2	sweet
ted	4	64	4656	2	_ted
tee	3	83	6687	2	tee_
teel	4	63	3580	2	teel
teem	6	61	3260	2	teem
teen	4	59	3820	2	teen
tees	4	53	5358	2	tees
tend	5	64	3377	2	tend
tewed	9	47	1853	2	tewed
tied	5	55	3521	2	tied
toed	5	61	3704	2	toed
treed	6	56	2673	2	treed
twee	7	68	2708	2	twee_
tweeds	10	49	843	2	tweeds
tweedy	13	45	593	2	tweedy
tween	8	44	1374	2	tween
tweet	8	48	2398	2	tweet
used	5	57	2282	2	used
vee	6	57	5018	2	vee_
veep	9	53	2509	2	veep
veer	7	62	2957	2	veer
vees	7	54	3943	2	vees
veld	8	53	2320	2	veld
vend	8	66	2642	2	vend
vexed	16	57	1311	2	vexed
vied	8	63	2863	2	vied
wad	7	70	5389	2	w_ad
wade	8	52	3706	2	wade
waded	10	60	2475	2	waded
wae	6	75	5695	2	wae_
waes	7	60	4860	2	waes
waged	10	48	2278	2	waged
waked	13	56	2675	2	waked
waled	9	43	3099	2	waled
wand	8	58	3388	2	wand
waned	9	58	3178	2	waned
ward	8	65	4225	2	ward
wared	9	63	3987	2	wared
waved	12	52	2358	2	waved
waxed	16	60	1848	2	waxed
we	5	70	4345	2	w_e_
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
weald	9	56	1502	2	weald
wean	7	57	3435	2	wean
weaned	10	38	1615	2	weaned
wear	7	58	3672	2	wear
weaved	13	39	1348	2	weaved
web	8	57	3556	2	w_eb
webbed	14	3	643	2	webbed
weber	10	3	1352	2	weber
webfed	15	3	503	2	webfed
webs	9	66	2212	2	webs
wedded	12	38	1184	2	wedded
wedel	9	45	1396	2	wedel
wedged	12	51	1030	2	wedged
weds	8	66	2893	2	weds
weeded	11	39	1487	2	weeded
weeder	10	33	1551	2	weeder
weeks	12	50	1786	2	weeks
weened	10	40	1373	2	weened
weens	8	52	2405	2	weens
weeny	11	53	1616	2	weeny
weeps	10	41	2056	2	weeps
weepy	13	42	1259	2	weepy
weest	8	50	2677	2	weest
weeted	10	39	1379	2	weeted
weets	8	54	2772	2	weets
weft	10	54	3501	2	weft
weir	7	60	1992	2	weir
weird	9	51	1128	2	weird
weka	11	70	1387	2	weka
welded	11	40	1338	2	welded
welds	9	47	1916	2	welds
well	7	58	3204	2	well
welled	10	38	2021	2	welled
welt	7	55	4786	2	welt
welted	10	37	1582	2	welted
wen	6	62	4960	2	w_en
wended	11	36	1615	2	wended
wends	9	58	2281	2	wends
wens	7	63	3793	2	wens
went	7	60	5187	2	went
wept	9	56	3505	2	wept
were	7	62	3833	2	were
wert	7	97	4982	2	wert
west	7	57	4808	2	west
wet	6	59	6662	2	w_et
wets	7	59	4029	2	wets
wetted	10	37	1702	2	wetted
whee	10	54	2959	2	whee
wheel	11	55	1533	2	wheel
wheen	11	50	1605	2	wheen
wheep	13	62	1435	2	wheep
when	10	57	2304	2	when
whet	10	51	3378	2	whet
whew	13	76	1878	2	whew
whey	13	50	1871	2	whey
whid	11	54	1887	2	whid
wide	8	52	3541	2	wide
wield	9	52	1391	2	wield
wifed	12	51	1774	2	wifed
wild	8	51	2651	2	wild
wiled	9	52	3155	2	wiled
wind	8	55	3385	2	wind
wined	9	44	3418	2	wined
wiped	11	47	2208	2	wiped
wired	9	53	2764	2	wired
wised	9	51	2334	2	wised
wited	9	47	2714	2	wited
wived	12	51	2150	2	wived
woad	8	55	2394	2	woad
woe	6	66	5124	2	woe_
woes	7	64	4066	2	woes
wold	8	54	2907	2	wold
wood	8	53	2938	2	wood
wooed	9	44	1987	2	wooed
word	8	98	3200	2	word
wowed	12	40	2377	2	wowed
wren	7	82	2168	2	wren
wried	9	55	1856	2	wried
wud	7	62	2715	2	w_ud
wye	9	63	3197	2	wye_
wyes	10	57	2750	2	wyes
wyled	12	46	1184	2	wyled
wynd	11	61	1446	2	wynd
wyted	12	52	947	2	wyted
yeld	8	114	2387	2	yeld
zed	13	54	3117	2	_zed
zee	12	61	4323	2	zee_
zees	13	63	3189	2	zees

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.310	576422.6
2	DLD Change Limit	29872	352	0.846	35309.7
3	Display Results	352	352	0.093	3784.9
	(SQL Overall)	178691	352	1.249	143067.3