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

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

258 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
weets	8	54	2772	(None)
beets	7	61	3144	1	beets
deets	6	53	3024	1	deets
keets	9	51	2348	1	keets
leets	5	49	2712	1	leets
meets	7	42	2461	1	meets
sweets	9	42	1443	1	sweets
tweets	9	42	1010	1	tweets
weeds	9	52	2221	1	weeds
weeks	12	50	1786	1	weeks
weens	8	52	2405	1	weens
weeps	10	41	2056	1	weeps
wees	7	62	4912	1	wee_s
weest	8	50	2677	1	weest
weet	7	52	5415	1	weet_
wefts	11	67	1549	1	wefts
welts	8	52	2519	1	welts
wests	8	57	2700	1	wests
wets	7	59	4029	1	w_ets
whets	11	50	1961	1	whets
abets	7	56	2167	2	abets
beats	7	60	4224	2	beats
beefs	10	56	1856	2	beefs
beeps	9	53	2097	2	beeps
beers	7	56	2839	2	beers
bees	6	54	5338	2	bee_s
beet	6	64	5754	2	beet_
begets	9	62	1552	2	begets
belts	7	59	3116	2	belts
bents	7	60	3369	2	bents
berets	8	58	2252	2	berets
besets	8	57	1880	2	besets
bests	7	59	3261	2	bests
bets	6	70	5144	2	_bets
blets	7	53	2494	2	blets
cees	6	59	4159	2	cee_s
celts	7	53	2578	2	celts
cents	7	47	3033	2	cents
cetes	7	57	3110	2	cetes
debts	8	64	1837	2	debts
deeds	7	54	2376	2	deeds
deems	8	54	2177	2	deems
deeps	8	49	2177	2	deeps
deers	6	49	3052	2	deers
dees	5	63	5663	2	dee_s
deet	5	73	5658	2	deet_
delts	6	57	3179	2	delts
dents	6	50	3180	2	dents
diets	6	60	2664	2	diets
duets	6	53	2388	2	duets
dweebs	12	3	365	2	dweebs
eats	4	70	5487	2	_eats
eels	4	65	3674	2	_eels
efts	7	65	1948	2	_efts
ewers	8	60	1882	2	ewers
ewes	7	63	2870	2	ewe_s
feats	8	64	3275	2	feats
feebs	10	61	1268	2	feebs
feeds	9	49	2114	2	feeds
feels	8	52	2304	2	feels
fees	7	64	5060	2	fee_s
feet	7	53	5221	2	feet_
felts	8	53	2454	2	felts
fests	8	58	2804	2	fests
fetes	8	56	3014	2	fetes
fets	7	53	4594	2	_fets
fleets	9	69	1506	2	fleets
frets	8	55	2340	2	frets
geeks	10	49	1584	2	geeks
gees	5	56	4788	2	gee_s
geest	6	48	2962	2	geest
geests	7	59	1216	2	geests
gelts	6	59	2461	2	gelts
genets	7	57	1666	2	genets
gents	6	57	2961	2	gents
gests	6	60	2881	2	gests
gets	5	54	4248	2	_gets
gleets	7	53	1505	2	gleets
greets	7	51	1742	2	greets
haets	8	65	2512	2	haets
heats	8	58	3840	2	heats
heeds	9	54	2042	2	heeds
heels	8	56	2553	2	heels
hefts	11	62	1815	2	hefts
hents	8	73	3074	2	hents
hests	8	58	2993	2	hests
hets	7	55	4720	2	_hets
jeeps	14	47	1537	2	jeeps
jeers	12	48	1813	2	jeers
jees	11	59	3854	2	jee_s
jests	12	59	2245	2	jests
jetes	12	49	2284	2	jetes
jets	11	58	3410	2	_jets
keefs	12	51	1628	2	keefs
keeks	8	47	1725	2	keeks
keels	9	46	2241	2	keels
keens	9	57	2118	2	keens
keeps	11	60	2028	2	keeps
keet	8	53	4735	2	keet_
kelts	9	52	2263	2	kelts
khets	12	49	1343	2	khets
leeks	9	53	1889	2	leeks
leers	5	48	2898	2	leers
lees	4	54	5588	2	lee_s
leet	4	59	5790	2	leet_
lefts	8	65	1781	2	lefts
lets	4	71	4794	2	_lets
meats	7	50	3405	2	meats
meeds	8	49	2027	2	meeds
meet	6	53	5055	2	meet_
melts	7	49	3010	2	melts
metes	7	47	3621	2	metes
neats	5	59	3190	2	neats
needs	6	57	1963	2	needs
neems	7	73	1629	2	neems
neeps	7	56	1788	2	neeps
nerts	5	59	2498	2	nerts
nests	5	57	2800	2	nests
nets	4	59	4153	2	_nets
netts	5	53	2072	2	netts
newts	8	60	1528	2	newts
owlets	9	31	1039	2	owlets
peats	7	61	4019	2	peats
peeks	11	50	2111	2	peeks
peels	7	52	2642	2	peels
peens	7	64	2819	2	peens
peeps	9	58	2236	2	peeps
peers	7	51	3027	2	peers
pees	6	52	5737	2	pee_s
pelts	7	61	2881	2	pelts
pests	7	59	3327	2	pests
pets	6	62	4833	2	_pets
poets	7	60	2444	2	poets
reeds	6	54	3090	2	reeds
reefs	8	51	2166	2	reefs
reeks	9	41	2403	2	reeks
reels	5	53	3326	2	reels
rees	4	53	6419	2	ree_s
reest	5	49	3809	2	reest
reests	6	46	1889	2	reests
relets	6	40	2567	2	relets
rents	5	59	3518	2	rents
resets	6	54	2761	2	resets
rests	5	49	3587	2	rests
rets	4	53	5256	2	_rets
revets	9	40	2217	2	revets
rewets	9	46	1721	2	rewets
seats	5	48	4434	2	seats
sects	7	56	2289	2	sects
seeds	6	43	3006	2	seeds
seeks	9	47	2464	2	seeks
seels	5	56	3282	2	seels
seems	7	55	2502	2	seems
seeps	7	48	2875	2	seeps
seers	5	51	3638	2	seers
sees	4	53	6105	2	see_s
septs	7	54	2060	2	septs
sets	4	55	4950	2	_sets
setts	5	51	2432	2	setts
sexts	12	51	1838	2	sexts
sheets	9	39	1850	2	sheets
skeets	10	45	1325	2	skeets
sleets	6	43	1887	2	sleets
stets	5	54	2391	2	stets
suets	5	51	2610	2	suets
sweats	9	48	1461	2	sweats
sweeps	11	41	1051	2	sweeps
sweet	8	53	3052	2	sweet_
teats	5	56	3681	2	teats
teels	5	57	2637	2	teels
teems	7	60	1978	2	teems
teens	5	62	2748	2	teens
tees	4	53	5358	2	tee_s
teeth	8	73	1585	2	teeth
tenets	6	55	1895	2	tenets
tents	5	64	3421	2	tents
tests	5	65	3019	2	tests
tets	4	58	4746	2	_tets
texts	12	55	1504	2	texts
trets	5	59	2802	2	trets
tweeds	10	49	843	2	tweeds
tweens	9	48	984	2	tweens
tweet	8	48	2398	2	tweet_
veeps	10	47	1572	2	veeps
veers	8	45	2136	2	veers
vees	7	54	3943	2	vee_s
vents	8	61	2593	2	vents
verts	8	57	2473	2	verts
vests	8	53	2598	2	vests
vets	7	68	3509	2	_vets
waes	7	60	4860	2	wae_s
wafts	11	69	2055	2	wafts
waits	8	83	3352	2	waits
wants	8	79	3221	2	wants
warts	8	148	4040	2	warts
wasts	8	74	3367	2	wasts
wats	7	75	5588	2	w_ats
watts	8	69	2309	2	watts
weals	8	54	2874	2	weals
weans	8	53	2674	2	weans
wears	8	60	3030	2	wears
webers	11	3	1094	2	webers
webs	9	66	2212	2	w_ebs
wechts	14	4	625	2	wechts
wedels	10	38	1103	2	wedels
weds	8	66	2894	2	w_eds
wee	6	67	6081	2	wee__
weed	8	56	3751	2	wee_d
weedy	12	51	1500	2	weedy
week	11	64	2815	2	wee_k
weel	7	58	3408	2	wee_l
ween	7	58	3546	2	wee_n
weensy	12	41	682	2	weensy
weeny	11	53	1616	2	weeny
weep	9	51	3165	2	wee_p
weepy	13	42	1259	2	weepy
weer	7	55	3509	2	wee_r
weeted	10	39	1379	2	weeted
weft	10	54	3501	2	weft_
weirs	8	43	1649	2	weirs
wekas	12	39	1179	2	wekas
welds	9	47	1916	2	welds
wells	8	54	2619	2	wells
welt	7	55	4786	2	welt_
wends	9	58	2281	2	wends
wens	7	63	3793	2	w_ens
went	7	60	5187	2	went_
wept	9	56	3505	2	wept_
wert	7	97	4982	2	wert_
west	7	57	4808	2	west_
wet	6	59	6662	2	w_et_
whats	11	77	1899	2	whats
wheats	12	50	1322	2	wheats
wheels	12	38	1172	2	wheels
wheens	12	46	1061	2	wheens
wheeps	14	43	995	2	wheeps
whens	11	46	1876	2	whens
whet	10	51	3378	2	whet_
whews	14	51	1449	2	whews
wheys	14	59	1155	2	wheys
whits	11	59	2382	2	whits
wilts	8	50	2350	2	wilts
wists	8	67	2852	2	wists
wites	8	55	3696	2	wites
wits	7	60	4488	2	w_its
woes	7	64	4066	2	woe_s
wonts	8	76	2154	2	wonts
worts	8	86	3118	2	worts
wots	7	63	4289	2	w_ots
wrens	8	50	1624	2	wrens
wrest	8	49	2543	2	wrest
wrests	9	53	1308	2	wrests
writs	8	66	2438	2	writs
wyes	10	57	2750	2	wye_s
wytes	11	41	1343	2	wytes
yetts	8	67	1513	2	yetts
zees	13	63	3189	2	zee_s
zests	14	54	1974	2	zests

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	53800	0.326	548131.9
2	DLD Change Limit	53800	258	1.610	33416.1
3	Display Results	258	258	0.080	3225.0
	(SQL Overall)	178691	258	2.016	88636.4