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

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

366 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
deet	5	73	5658	(None)
beet	6	64	5754	1	beet
debt	7	71	3902	1	debt
dee	4	76	6582	1	dee_
deed	6	53	4090	1	deed
deem	7	54	3289	1	deem
deep	7	60	3188	1	deep
deer	5	67	3902	1	deer
dees	5	63	5663	1	dees
deets	6	53	3024	1	deets
deft	8	55	4022	1	deft
delt	5	78	5527	1	delt
dent	5	71	5841	1	dent
diet	5	73	5753	1	diet
duet	5	64	4626	1	duet
feet	7	53	5221	1	feet
keet	8	53	4733	1	keet
leet	4	59	5790	1	leet
meet	6	53	5055	1	meet
weet	7	52	5415	1	weet
abet	6	105	4794	2	abet
adeem	8	3	1180	2	adeem
adept	8	12	1964	2	adept
beat	6	61	6830	2	beat
bee	5	62	6240	2	bee_
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
beets	7	61	3144	2	beets
beget	8	56	3255	2	beget
belt	6	57	5403	2	belt
bent	6	77	5991	2	bent
beret	7	49	4636	2	beret
beset	7	67	3913	2	beset
best	6	63	5532	2	best
bet	5	83	7667	2	_bet
blet	6	62	4767	2	blet
cee	5	59	5270	2	cee_
cees	6	59	4159	2	cees
celt	6	56	4671	2	celt
cent	6	74	5101	2	cent
cete	6	49	3478	2	cete
daft	8	55	3725	2	daft
dart	5	58	5787	2	dart
date	5	64	4332	2	date
daut	5	64	4356	2	daut
dawt	8	54	3594	2	dawt
de	3	70	4954	2	d_e_
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
dealt	6	52	3428	2	dealt
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
death	9	48	2252	2	death
deb	6	63	4269	2	d_eb
debit	8	57	2785	2	debit
debs	7	65	3024	2	debs
debts	8	64	1837	2	debts
debut	8	60	2414	2	debut
deceit	9	30	1821	2	deceit
decent	9	40	2370	2	decent
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
deeds	7	54	2376	2	deeds
deedy	10	43	1589	2	deedy
deems	8	54	2177	2	deems
deeps	8	49	2177	2	deeps
deers	6	49	3052	2	deers
def	7	65	4672	2	d_ef
defat	9	54	2669	2	defat
defeat	10	38	1716	2	defeat
defect	12	48	1617	2	defect
defer	9	46	1975	2	defer
defi	8	63	2149	2	defi
defy	11	49	2126	2	defy
deil	5	62	3162	2	deil
deist	6	46	3359	2	deist
deity	9	43	1677	2	deity
deject	16	45	1284	2	deject
deke	9	52	2876	2	deke
deked	11	57	1853	2	deked
dekes	10	52	2445	2	dekes
del	4	67	5275	2	d_el
dele	5	68	4308	2	dele
deled	7	53	2654	2	deled
deles	6	51	3925	2	deles
delete	7	36	2070	2	delete
delf	8	54	3657	2	delf
delft	9	56	2332	2	delft
deli	5	56	3129	2	deli
dell	5	69	3820	2	dell
dels	5	67	4547	2	dels
delta	6	61	1777	2	delta
delts	6	57	3179	2	delts
deme	7	65	3628	2	deme
dement	9	38	2514	2	dement
demes	8	60	3269	2	demes
demit	8	48	3230	2	demit
demo	7	74	2755	2	demo
demy	10	54	2285	2	demy
den	4	75	5434	2	d_en
dene	5	66	4341	2	dene
denes	6	56	3972	2	denes
deni	5	69	2939	2	deni
dens	5	59	4507	2	dens
dents	6	50	3180	2	dents
deny	8	60	2712	2	deny
depot	8	57	2792	2	depot
depth	11	43	1185	2	depth
derat	6	50	4408	2	derat
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
desert	7	27	2549	2	desert
desex	13	3	1198	2	desex
desk	9	56	1890	2	desk
detect	9	42	1740	2	detect
detent	7	36	2448	2	detent
deter	6	50	2804	2	deter
detest	7	41	2284	2	detest
dev	7	60	3377	2	d_ev
deva	8	57	2098	2	deva
devel	9	42	1712	2	devel
devest	10	44	1870	2	devest
devs	8	64	2403	2	devs
dew	7	71	3992	2	d_ew
dewed	10	50	2030	2	dewed
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
dex	11	69	3688	2	d_ex
dexes	13	52	2451	2	dexes
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	d_ey
deys	8	50	2747	2	deys
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diets	6	60	2664	2	diets
dint	5	67	5905	2	dint
dipt	7	73	3932	2	dipt
dirt	5	55	5038	2	dirt
dit	4	70	7133	2	d_it
dite	5	55	4755	2	dite
doat	5	69	4767	2	doat
doe	4	73	6195	2	doe_
doer	5	77	3470	2	doer
does	5	65	5447	2	does
doest	6	58	2952	2	doest
doeth	9	4	1198	2	doeth
doit	5	63	4785	2	doit
dolt	5	66	4942	2	dolt
dost	5	72	4835	2	dost
dot	4	75	7318	2	d_ot
dote	5	54	4288	2	dote
drat	5	62	4783	2	drat
dree	5	66	3832	2	dree
dreed	7	52	2284	2	dreed
drees	6	56	2852	2	drees
dreg	6	68	2165	2	dreg
drek	9	63	2109	2	drek
drest	6	55	3034	2	drest
drew	8	62	2167	2	drew
duct	7	57	3546	2	duct
due	4	52	4986	2	due_
duel	5	67	2970	2	duel
dues	5	60	4550	2	dues
duets	6	53	2388	2	duets
duit	5	62	4158	2	duit
dunt	5	57	4687	2	dunt
dust	5	71	4253	2	dust
duvet	9	3	2187	2	duvet
dweeb	11	3	774	2	dweeb
dwelt	9	43	1652	2	dwelt
dye	7	53	3484	2	dye_
dyed	9	67	2076	2	dyed
dyer	8	55	2211	2	dyer
dyes	8	53	3189	2	dyes
eat	3	69	8905	2	_eat
edit	5	49	3486	2	edit
eek	7	79	3510	2	_eek
eel	3	79	4684	2	_eel
eft	6	60	3882	2	_eft
et	2	69	6419	2	__et
feat	7	64	5822	2	feat
fee	6	68	6201	2	fee_
feeb	9	69	2454	2	feeb
feed	8	45	3890	2	feed
feel	7	52	3384	2	feel
fees	7	64	5060	2	fees
felt	7	51	4693	2	felt
fest	7	49	4944	2	fest
fet	6	64	7163	2	_fet
fete	7	57	3492	2	fete
fleet	8	59	3233	2	fleet
fret	7	58	4504	2	fret
gee	4	53	5920	2	gee_
geed	6	54	3550	2	geed
geek	9	53	2702	2	geek
gees	5	56	4788	2	gees
geest	6	48	2961	2	geest
geez	14	64	2486	2	geez
gelt	5	64	4801	2	gelt
genet	6	60	3868	2	genet
gent	5	69	5439	2	gent
gest	5	61	4913	2	gest
get	4	74	6746	2	_get
gleet	6	55	3234	2	gleet
greet	6	58	3532	2	greet
haet	7	56	5950	2	haet
heat	7	70	6142	2	heat
heed	8	64	3760	2	heed
heel	7	50	3422	2	heel
heft	10	67	3629	2	heft
hent	7	66	5638	2	hent
hest	7	59	5077	2	hest
het	6	76	7431	2	_het
jee	10	66	4864	2	jee_
jeed	12	54	2850	2	jeed
jeep	13	56	2484	2	jeep
jeer	11	54	2646	2	jeer
jees	11	59	3854	2	jees
jeez	20	56	2203	2	jeez
jest	11	67	3850	2	jest
jet	10	67	5482	2	_jet
jete	11	59	2725	2	jete
keef	11	58	2999	2	keef
keek	7	56	2496	2	keek
keel	8	57	2946	2	keel
keen	8	48	3040	2	keen
keep	10	63	2981	2	keep
keets	9	51	2348	2	keets
kelt	8	53	4319	2	kelt
kent	8	68	4696	2	kent
kept	10	62	3294	2	kept
khet	11	63	2862	2	khet
lee	3	60	6814	2	lee_
leek	8	53	3173	2	leek
leer	4	62	3935	2	leer
lees	4	54	5588	2	lees
leets	5	49	2712	2	leets
left	7	63	4048	2	left
lent	4	63	6053	2	lent
lept	6	64	4088	2	lept
lest	4	69	5632	2	lest
let	3	64	8147	2	_let
meat	6	63	5960	2	meat
meed	7	49	3470	2	meed
meek	10	56	2483	2	meek
meets	7	42	2461	2	meets
melt	6	57	5289	2	melt
met	5	60	7243	2	_met
mete	6	44	3813	2	mete
neat	4	63	5678	2	neat
nee	3	66	5778	2	nee_
need	5	49	3415	2	need
neem	6	73	2808	2	neem
neep	6	57	2831	2	neep
nest	4	55	4873	2	nest
net	3	66	7029	2	_net
nett	4	66	4323	2	nett
newt	7	69	3374	2	newt
next	11	66	3108	2	next
peat	6	59	6793	2	peat
pee	5	60	6651	2	pee_
peed	7	62	3918	2	peed
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
pelt	6	76	5108	2	pelt
pent	6	65	5907	2	pent
pert	6	67	5932	2	pert
pest	6	55	5529	2	pest
pet	5	64	7730	2	_pet
poet	6	55	5290	2	poet
ree	3	79	7407	2	ree_
reed	5	55	4962	2	reed
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
reest	5	49	3809	2	reest
reft	7	51	4127	2	reft
relet	5	47	4982	2	relet
remet	7	48	4372	2	remet
rent	4	66	6124	2	rent
reset	5	50	5186	2	reset
rest	4	64	5984	2	rest
ret	3	59	8283	2	_ret
rete	4	49	4413	2	rete
revet	8	49	3884	2	revet
rewet	8	51	3515	2	rewet
seat	4	75	7556	2	seat
sect	6	74	4362	2	sect
see	3	57	7226	2	see_
seed	5	55	4948	2	seed
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
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
set	3	66	8125	2	_set
sett	4	59	4905	2	sett
sext	11	73	3809	2	sext
sheet	8	48	3696	2	sheet
skeet	9	54	2918	2	skeet
sleet	5	56	3913	2	sleet
stet	4	59	4732	2	stet
suet	4	67	5482	2	suet
sweet	8	53	3052	2	sweet
teat	4	59	6363	2	teat
tee	3	83	6687	2	tee_
teed	5	54	3926	2	teed
teel	4	63	3580	2	teel
teem	6	61	3260	2	teem
teen	4	59	3820	2	teen
tees	4	53	5358	2	tees
teeth	8	73	1585	2	teeth
tenet	5	55	4221	2	tenet
tent	4	61	5986	2	tent
test	4	86	5162	2	test
tet	3	92	7499	2	_tet
text	11	60	3393	2	text
tret	4	66	5353	2	tret
tweet	8	48	2398	2	tweet
vee	6	57	5018	2	vee_
veep	9	53	2509	2	veep
veer	7	62	2957	2	veer
vees	7	54	3943	2	vees
vent	7	60	4905	2	vent
vert	7	72	4937	2	vert
vest	7	57	4360	2	vest
vet	6	59	5852	2	_vet
vext	14	69	2776	2	vext
wee	6	67	6081	2	wee_
weed	8	56	3751	2	weed
week	11	64	2815	2	week
weel	7	58	3408	2	weel
ween	7	58	3546	2	ween
weep	9	51	3165	2	weep
weer	7	55	3509	2	weer
wees	7	62	4912	2	wees
weest	8	50	2677	2	weest
weets	8	54	2772	2	weets
weft	10	54	3501	2	weft
welt	7	55	4786	2	welt
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	_wet
whet	10	51	3378	2	whet
yet	6	69	6069	2	_yet
yett	7	64	3449	2	yett
zee	12	61	4323	2	zee_
zees	13	63	3189	2	zees
zest	13	60	3570	2	zest

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.080	2233637.5
2	DLD Change Limit	29872	366	0.843	35435.3
3	Display Results	366	366	0.080	4575.0
	(SQL Overall)	178691	366	1.003	178156.5