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

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

277 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
leets	5	49	2712	(None)
beets	7	61	3144	1	beets
deets	6	53	3024	1	deets
fleets	9	69	1506	1	fleets
gleets	7	53	1505	1	gleets
keets	9	51	2348	1	keets
leeks	9	53	1889	1	leeks
leers	5	48	2898	1	leers
lees	4	54	5588	1	lee_s
leet	4	59	5790	1	leet_
lefts	8	65	1781	1	lefts
lets	4	71	4794	1	l_ets
meets	7	42	2461	1	meets
sleets	6	43	1887	1	sleets
weets	8	54	2772	1	weets
abets	7	56	2167	2	abets
alerts	6	44	1822	2	alerts
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
bleats	8	55	1861	2	bleats
bleeds	9	52	1159	2	bleeds
bleeps	10	49	910	2	bleeps
blets	7	53	2494	2	blets
bluets	8	72	1549	2	bluets
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
cleats	8	49	1931	2	cleats
cleeks	12	50	1054	2	cleeks
clefts	11	46	1016	2	clefts
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
elects	8	33	1500	2	elects
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
fleers	9	60	1579	2	fleers
flees	8	58	2875	2	flee_s
fleet	8	59	3233	2	fleet_
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
gleeds	8	47	1162	2	gleeds
gleeks	11	48	967	2	gleeks
glees	6	50	2759	2	glee_s
gleet	6	55	3234	2	gleet_
gleety	10	47	919	2	gleety
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	4734	2	keet_
kelts	9	52	2263	2	kelts
khets	12	49	1343	2	khets
lasts	5	77	3126	2	lasts
lats	4	59	6270	2	l_ats
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lears	5	59	3873	2	lears
leas	4	59	5418	2	l_eas
least	5	61	3488	2	least
leasts	6	46	1641	2	leasts
lebens	8	3	1009	2	lebens
lee	3	60	6814	2	lee__
leech	10	49	1321	2	leech
leek	8	53	3173	2	lee_k
leer	4	62	3935	2	lee_r
leery	8	59	1913	2	leery
left	7	63	4048	2	left_
lefty	11	56	1356	2	lefty
legers	7	45	1831	2	legers
leges	6	44	2729	2	leges
legits	7	13	1300	2	legits
legs	5	61	3369	2	l_egs
lehrs	8	61	1113	2	lehrs
leis	4	57	3960	2	l_eis
leks	8	54	2760	2	l_eks
lends	6	53	2625	2	lends
lenes	5	47	3852	2	lenes
lenis	5	63	2686	2	lenis
lenos	5	60	2486	2	lenos
lens	4	61	4649	2	l_ens
lent	4	63	6053	2	lent_
lento	5	72	2339	2	lento
lentos	6	53	1740	2	lentos
lepers	8	48	1732	2	lepers
lept	6	64	4088	2	lept_
lepta	7	57	1439	2	lepta
les	3	56	6307	2	l_e_s
leses	5	49	3081	2	leses
less	4	56	3510	2	l_ess
lest	4	69	5632	2	lest_
let	3	64	8147	2	l_et_
leuds	6	62	1481	2	leuds
levees	9	37	1452	2	levees
levels	9	41	1328	2	levels
levers	9	46	2132	2	levers
levis	8	58	1855	2	levis
lewis	8	53	1584	2	lewis
lexes	12	72	2526	2	lexes
lexis	12	59	1603	2	lexis
leys	7	64	3018	2	l_eys
liens	5	65	2550	2	liens
liers	5	51	3040	2	liers
lies	4	64	5419	2	lie_s
lieus	5	62	1848	2	lieus
lifts	8	57	1906	2	lifts
lilts	5	58	2280	2	lilts
lints	5	71	3719	2	lints
lists	5	66	2869	2	lists
lits	4	62	5249	2	l_its
loess	5	57	1470	2	loess
lofts	8	55	1836	2	lofts
loots	5	54	3142	2	loots
lots	4	76	5209	2	l_ots
louts	5	63	3027	2	louts
lues	4	59	4355	2	lue_s
lunets	6	69	1476	2	lunets
lunts	5	58	2690	2	lunts
lusts	5	50	2280	2	lusts
lutes	5	58	3666	2	lutes
lweis	8	45	869	2	lweis
lyes	7	55	3083	2	lye_s
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
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
pleats	8	52	1859	2	pleats
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
sleeks	10	45	1246	2	sleeks
sleeps	8	39	1332	2	sleeps
sleet	5	56	3913	2	sleet_
sleety	9	41	1265	2	sleety
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	4746	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 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.313	570897.8
2	DLD Change Limit	53800	277	1.673	32157.8
3	Display Results	277	277	0.076	3644.7
	(SQL Overall)	178691	277	2.062	86659.1