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

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

268 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
meets	7	42	2461	(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
meats	7	50	3405	1	meats
meeds	8	49	2027	1	meeds
meet	6	53	5055	1	meet_
melts	7	49	3010	1	melts
metes	7	47	3621	1	metes
weets	8	54	2772	1	weets
abets	7	56	2167	2	abets
ameers	8	40	1557	2	ameers
aments	8	52	1980	2	aments
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
eats	4	70	5487	2	_eats
eels	4	65	3674	2	_eels
efts	7	65	1948	2	_efts
emeers	8	33	1418	2	emeers
emes	6	54	3466	2	eme_s
emeus	7	69	1333	2	emeus
emits	7	54	2146	2	emits
emmets	10	34	915	2	emmets
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	2961	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	4733	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
maes	6	69	4839	2	mae_s
malts	7	63	3175	2	malts
marts	7	74	4223	2	marts
masts	7	70	3576	2	masts
mates	7	52	5136	2	mates
mats	6	54	6028	2	m_ats
matts	7	68	2918	2	matts
mauts	7	59	2719	2	mauts
meads	8	54	2532	2	meads
meals	7	59	3337	2	meals
means	7	58	3122	2	means
meat	6	63	5960	2	meat_
meatus	8	51	1292	2	meatus
meaty	10	70	2131	2	meaty
meds	7	57	3536	2	m_eds
meed	7	49	3470	2	mee_d
meek	10	56	2483	2	mee_k
meeter	8	36	1650	2	meeter
meeters	9	47	1454	2	meeters
meetly	11	3	867	2	meetly
megs	7	55	3063	2	m_egs
melds	8	48	2238	2	melds
melees	8	36	1808	2	melees
mells	7	50	3133	2	mells
mels	6	59	4153	2	m_els
melt	6	57	5289	2	melt_
melty	10	49	1836	2	melty
memes	9	49	2770	2	memes
memos	9	57	1911	2	memos
mems	8	59	3150	2	m_ems
mends	8	49	2769	2	mends
menta	7	44	2442	2	menta
menus	7	58	2284	2	menus
meous	7	61	2006	2	meous
meows	10	46	1268	2	meows
mercs	9	60	2045	2	mercs
meres	7	51	4357	2	meres
merest	8	47	2511	2	merest
merits	8	3	2087	2	merits
merks	11	47	2240	2	merks
merls	7	74	2390	2	merls
mesas	7	68	2320	2	mesas
mess	6	59	3243	2	m_ess
met	5	60	7243	2	m_et_
meta	6	59	3241	2	m_eta
mete	6	44	3813	2	m_ete
meted	8	54	2443	2	meted
meter	7	51	3032	2	meter
meters	8	56	2583	2	meters
meth	9	58	2784	2	m_eth
meths	10	53	2023	2	meths
metis	7	50	2590	2	metis
mewls	10	58	1323	2	mewls
mews	9	66	2933	2	m_ews
mezes	16	77	1926	2	mezes
miens	7	61	1830	2	miens
milts	7	54	3071	2	milts
mints	7	68	3404	2	mints
mists	7	66	3390	2	mists
mites	7	51	4180	2	mites
mitts	7	55	2375	2	mitts
moats	7	58	2764	2	moats
molts	7	60	3209	2	molts
moots	7	58	3166	2	moots
morts	7	55	3356	2	morts
mosts	7	60	2854	2	mosts
motes	7	59	4400	2	motes
motets	8	42	1619	2	motets
mots	6	68	5316	2	m_ots
motts	7	65	2700	2	motts
musts	7	55	2744	2	musts
mutes	7	50	3378	2	mutes
muts	6	48	3998	2	m_uts
mutts	7	51	2025	2	mutts
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
omelets	9	3	833	2	omelets
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
remeets	9	37	1241	2	remeets
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	1849	2	sheets
skeets	10	45	1325	2	skeets
sleets	6	43	1887	2	sleets
smeeks	12	42	843	2	smeeks
smelts	8	54	1277	2	smelts
stets	5	54	2391	2	stets
suets	5	51	2610	2	suets
sweets	9	42	1443	2	sweets
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	4745	2	_tets
texts	12	55	1504	2	texts
trets	5	59	2802	2	trets
tweets	9	42	1010	2	tweets
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
weeds	9	52	2221	2	weeds
weeks	12	50	1786	2	weeks
weens	8	52	2405	2	weens
weeps	10	41	2056	2	weeps
wees	7	62	4912	2	wee_s
weest	8	50	2677	2	weest
weet	7	52	5415	2	weet_
wefts	11	67	1549	2	wefts
welts	8	52	2519	2	welts
wests	8	57	2700	2	wests
wets	7	59	4029	2	_wets
whets	11	50	1961	2	whets
yetts	8	67	1513	2	yetts
zees	13	63	3189	2	zee_s
zests	14	54	1974	2	zests

Search took 6 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.283	631417.0
2	DLD Change Limit	53800	268	5.360	10037.3
3	Display Results	268	268	0.216	1240.7
	(SQL Overall)	178691	268	5.859	30498.5