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

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

302 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
diet	5	73	5753	(None)
deet	5	73	5658	1	deet
die	4	67	5965	1	die_
died	6	61	3785	1	died
diel	5	90	3460	1	diel
dies	5	56	5352	1	dies
diets	6	60	2664	1	diets
dint	5	67	5905	1	dint
dipt	7	73	3932	1	dipt
dirt	5	55	5038	1	dirt
dit	4	70	7133	1	di_t
dite	5	55	4755	1	dite
duet	5	64	4626	1	duet
abet	6	105	4794	2	abet
adieu	6	4	1742	2	adieu
adit	5	64	4365	2	adi_t
airt	4	57	5778	2	airt
ait	3	80	9390	2	ai_t
beet	6	64	5754	2	beet
bet	5	83	7667	2	_bet
bidet	8	49	3562	2	bidet
bier	6	55	3182	2	bier
bint	6	73	5503	2	bint
bit	5	70	7089	2	bi_t
bite	6	65	4699	2	bite
bitt	6	55	4580	2	bitt
blet	6	62	4767	2	blet
cist	6	72	4496	2	cist
cite	6	56	4034	2	cite
civet	10	58	2873	2	civet
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_
deb	6	63	4269	2	d_eb
debt	7	71	3902	2	debt
dee	4	76	6582	2	d_ee
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deets	6	53	3024	2	deets
def	7	65	4672	2	d_ef
deft	8	55	4022	2	deft
deil	5	62	3162	2	deil
deist	6	46	3359	2	deist
deity	9	43	1677	2	deity
del	4	67	5275	2	d_el
delt	5	78	5527	2	delt
den	4	75	5434	2	d_en
dent	5	71	5841	2	dent
dev	7	60	3377	2	d_ev
dew	7	71	3992	2	d_ew
dex	11	69	3688	2	d_ex
dey	7	72	4337	2	d_ey
dial	5	59	3506	2	dial
dib	6	57	4693	2	di_b
dibs	7	62	3367	2	dibs
dice	7	58	4189	2	dice
diced	9	58	2468	2	diced
dicer	8	54	2642	2	dicer
dices	8	64	3424	2	dices
dicey	11	48	1933	2	dicey
dick	11	64	3238	2	dick
dicot	8	54	2909	2	dicot
dicta	8	49	1563	2	dicta
dicty	11	51	1629	2	dicty
did	5	68	5051	2	di_d
dido	6	65	2819	2	dido
didst	7	46	1961	2	didst
didy	9	91	2150	2	didy
diene	6	57	2013	2	diene
dieted	8	31	1549	2	dieted
dieter	7	35	1677	2	dieter
dif	7	68	4689	2	di_f
diff	11	62	2883	2	diff
difs	8	60	2732	2	difs
dig	5	75	4447	2	di_g
digest	8	40	1962	2	digest
dight	10	40	2700	2	dight
digit	7	38	2527	2	digit
digs	6	60	3605	2	digs
dike	9	59	3576	2	dike
diked	11	50	2468	2	diked
diker	10	55	2455	2	diker
dikes	10	58	3133	2	dikes
dikey	13	51	1642	2	dikey
dill	5	52	3997	2	dill
dim	6	81	4649	2	di_m
dime	7	62	3764	2	dime
dimer	8	56	2560	2	dimer
dimes	8	58	3304	2	dimes
dims	7	54	3502	2	dims
din	4	64	5946	2	di_n
dine	5	55	5533	2	dine
dined	7	64	3199	2	dined
diner	6	56	3290	2	diner
dines	6	64	4915	2	dines
ding	6	69	4095	2	ding
dink	9	71	3780	2	dink
dino	5	60	3675	2	dino
dins	5	66	5204	2	dins
dints	6	74	3131	2	dints
diol	5	73	2913	2	diol
dip	6	78	4898	2	di_p
dipnet	9	13	1747	2	dipnet
dips	7	55	3691	2	dips
dire	5	66	4414	2	dire
direct	9	38	1733	2	direct
direr	6	49	2707	2	direr
direst	7	50	2424	2	direst
dirk	9	63	2683	2	dirk
dirl	5	74	3002	2	dirl
dirts	6	68	2446	2	dirts
dirty	9	56	1780	2	dirty
dis	4	64	5989	2	di_s
disc	7	61	2323	2	disc
dish	8	63	2833	2	dish
disk	9	66	2583	2	disk
diss	5	64	3448	2	diss
dita	5	60	3252	2	dita
dites	6	63	3915	2	dites
dits	5	64	5052	2	dits
ditto	6	53	1560	2	ditto
ditty	9	50	1929	2	ditty
ditz	14	69	2951	2	ditz
diva	8	59	2088	2	diva
dive	8	56	3477	2	dive
dived	10	63	2137	2	dived
diver	9	48	2780	2	diver
divert	10	39	2281	2	divert
dives	9	58	3240	2	dives
divest	10	68	2007	2	divest
divot	9	57	2307	2	divot
dixit	13	44	2059	2	dixit
dizen	15	52	1493	2	dizen
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
dreg	6	68	2165	2	dreg
drek	9	63	2108	2	drek
drest	6	55	3034	2	drest
drew	8	62	2167	2	drew
dried	7	53	2138	2	dried
drier	6	44	2396	2	drier
dries	6	47	3367	2	dries
driest	7	47	2275	2	driest
drift	9	57	2284	2	drift
dript	8	69	2387	2	dript
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
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
edict	8	47	2228	2	edict
edit	5	49	3486	2	edi_t
et	2	69	6419	2	__et
feet	7	53	5221	2	feet
fet	6	64	7163	2	_fet
fiat	7	66	4664	2	fiat
fie	6	71	5244	2	fie_
fief	10	73	3135	2	fief
filet	8	55	4016	2	filet
fist	7	62	4842	2	fist
fit	6	63	6545	2	fi_t
fixt	14	107	2971	2	fixt
fret	7	58	4504	2	fret
get	4	74	6746	2	_get
gie	4	71	4954	2	gie_
gied	6	46	3198	2	gied
gien	5	63	3002	2	gien
gies	5	56	4142	2	gies
gift	8	67	3579	2	gift
gilt	5	63	4854	2	gilt
girt	5	66	4642	2	girt
gist	5	60	4676	2	gist
git	4	62	6605	2	gi_t
gite	5	54	3861	2	gite
haet	7	56	5950	2	haet
het	6	76	7431	2	_het
hie	6	76	5270	2	hie_
hied	8	54	3404	2	hied
hies	7	48	4283	2	hies
hilt	7	58	5071	2	hilt
hint	7	74	5574	2	hint
hist	7	65	5154	2	hist
hit	6	65	6919	2	hi_t
idea	5	91	2277	2	idea
idem	7	61	2106	2	idem
ides	5	77	3423	2	ides
idiot	6	7	1885	2	idiot
it	2	84	5568	2	_i_t
jet	10	67	5482	2	_jet
jilt	11	58	3942	2	jilt
keet	8	53	4733	2	keet
khet	11	63	2862	2	khet
kief	11	71	2839	2	kief
kier	8	65	2680	2	kier
kilt	8	61	4441	2	kilt
kist	8	65	4079	2	kist
kit	7	85	5987	2	ki_t
kite	8	53	3823	2	kite
leet	4	59	5790	2	leet
let	3	64	8147	2	_let
lie	3	82	6452	2	lie_
lied	5	58	3809	2	lied
lief	7	60	3698	2	lief
lien	4	53	3980	2	lien
lier	4	59	4246	2	lier
lies	4	64	5419	2	lies
lieu	4	65	3436	2	lieu
lift	7	69	4272	2	lift
lilt	4	63	4994	2	lilt
lint	4	162	6623	2	lint
list	4	70	5534	2	list
lit	3	93	7731	2	li_t
lite	4	70	5454	2	lite
meet	6	53	5055	2	meet
met	5	60	7243	2	_met
mien	6	50	2835	2	mien
milt	6	54	5580	2	milt
mint	6	67	5804	2	mint
mist	6	61	5452	2	mist
mite	6	62	4940	2	mite
mitt	6	61	4548	2	mitt
mixt	13	68	3191	2	mixt
net	3	66	7029	2	_net
nit	3	70	6594	2	ni_t
nite	4	59	4358	2	nite
odist	6	4	2191	2	odist
pet	5	64	7730	2	_pet
pie	5	54	5740	2	pie_
pied	7	50	3536	2	pied
pier	6	60	3529	2	pier
pies	6	69	4960	2	pies
pieta	7	54	2175	2	pieta
piety	10	58	1730	2	piety
pint	6	69	6317	2	pint
pipet	9	55	3332	2	pipet
pit	5	64	7192	2	pi_t
poet	6	55	5290	2	poet
quiet	14	45	3073	2	quiet
ret	3	59	8283	2	_ret
riel	4	64	3238	2	riel
rift	7	56	4233	2	rift
riot	4	59	4721	2	riot
rite	4	58	4945	2	rite
rivet	8	56	3636	2	rivet
set	3	66	8125	2	_set
sift	7	107	4066	2	sift
silt	4	65	5819	2	silt
sit	3	58	7775	2	si_t
site	4	70	5241	2	site
stet	4	59	4732	2	stet
suet	4	67	5482	2	suet
tet	3	92	7498	2	_tet
tie	3	65	5753	2	tie_
tied	5	55	3521	2	tied
tier	4	49	3614	2	tier
ties	4	52	4831	2	ties
tilt	4	62	5242	2	tilt
tint	4	67	5886	2	tint
tit	3	67	7104	2	ti_t
tret	4	66	5353	2	tret
vet	6	59	5852	2	_vet
vie	6	54	4763	2	vie_
vied	8	63	2863	2	vied
vier	7	54	2815	2	vier
vies	7	52	3862	2	vies
view	10	59	1767	2	view
weet	7	52	5415	2	weet
wet	6	59	6662	2	_wet
whet	10	51	3378	2	whet
wilt	7	62	4629	2	wilt
wist	7	80	4929	2	wist
wit	6	65	6377	2	wi_t
wite	7	54	4327	2	wite
yet	6	69	6069	2	_yet
zibet	16	4	1973	2	zibet
zit	12	60	4999	2	zi_t

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.076	2351197.4
2	DLD Change Limit	29872	302	0.986	30296.1
3	Display Results	302	302	0.060	5033.3
	(SQL Overall)	178691	302	1.122	159261.1