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

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

274 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
eft	6	60	3882	(None)
aft	6	68	4901	1	aft
deft	8	55	4022	1	deft
eat	3	69	8905	1	eat
ef	5	73	4536	1	ef_
eff	9	61	2862	1	eff
efs	6	68	2960	1	efs
efts	7	65	1948	1	efts
et	2	69	6419	1	e_t
fet	6	64	7163	1	fet
heft	10	67	3629	1	heft
left	7	63	4048	1	left
oft	6	77	4406	1	oft
reft	7	51	4127	1	reft
weft	10	54	3501	1	weft
act	5	95	5784	2	act
aff	9	55	3761	2	aff
ait	3	80	9390	2	ait
alt	3	64	6796	2	alt
ant	3	72	7078	2	ant
apt	5	73	5254	2	apt
art	3	86	7914	2	art
at	2	123	9340	2	_at
att	3	54	5465	2	att
bat	5	109	8895	2	bat
beat	6	61	6830	2	beat
beet	6	64	5754	2	beet
befit	10	52	2266	2	befit
belt	6	57	5403	2	belt
bent	6	77	5991	2	bent
best	6	63	5532	2	best
bet	5	83	7667	2	bet
bit	5	70	7089	2	bit
bot	5	96	8040	2	bot
but	5	59	6302	2	but
cat	5	82	8234	2	cat
celt	6	56	4671	2	celt
cent	6	74	5101	2	cent
cleft	10	62	2285	2	cleft
coft	9	79	3968	2	coft
cot	5	104	8322	2	cot
cut	5	79	5766	2	cut
daft	8	55	3725	2	daft
debt	7	71	3902	2	debt
deet	5	73	5658	2	deet
def	7	65	4672	2	def_
defat	9	54	2669	2	defat
defi	8	63	2149	2	defi
defy	11	49	2126	2	defy
delft	9	56	2332	2	delft
delt	5	78	5527	2	delt
dent	5	71	5841	2	dent
dit	4	70	7133	2	dit
dot	4	75	7318	2	dot
ear	3	68	6788	2	ear
east	4	66	5910	2	east
eath	7	57	3566	2	eath
eats	4	70	5487	2	eats
eau	3	74	5094	2	eau
ebb	7	24	1862	2	ebb
echt	9	57	2290	2	echt
ecu	5	68	2823	2	ecu
ed	3	86	4518	2	e_d
edh	7	69	2156	2	edh
edit	5	49	3486	2	edit
eds	4	66	3892	2	eds
eek	7	79	3510	2	eek
eel	3	79	4684	2	eel
effs	10	51	1403	2	effs
egg	5	69	1867	2	egg
ego	4	67	2605	2	ego
eh	5	83	3996	2	e_h
eke	7	56	3009	2	eke
el	2	67	4529	2	e_l
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
em	4	94	4515	2	e_m
eme	5	58	3718	2	eme
emit	6	54	3841	2	emit
ems	5	64	3549	2	ems
emu	5	59	2998	2	emu
en	2	80	5239	2	e_n
end	4	68	3435	2	end
eng	4	67	2678	2	eng
ens	3	72	4592	2	ens
eon	3	60	5208	2	eon
er	2	83	4514	2	e_r
era	3	57	4150	2	era
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ern	3	57	3835	2	ern
err	3	56	2653	2	err
ers	3	60	4628	2	ers
erst	4	74	3643	2	erst
es	2	90	4822	2	e_s
ess	3	60	3088	2	ess
eta	3	58	3419	2	eta
eth	6	66	3098	2	eth
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
ex	9	88	3564	2	e_x
exit	11	44	2867	2	exit
eye	6	55	3977	2	eye
fa	5	101	4845	2	_fa
fat	6	81	7808	2	fat
fe	5	79	4474	2	_fe
feat	7	64	5822	2	feat
fed	7	65	4835	2	fed
fee	6	68	6201	2	fee
feet	7	53	5221	2	feet
feh	9	61	3609	2	feh
felt	7	51	4693	2	felt
fem	8	60	4073	2	fem
fen	6	68	5135	2	fen
fer	6	66	4612	2	fer
fes	6	65	5167	2	fes
fest	7	49	4944	2	fest
feta	7	65	2890	2	feta
fete	7	57	3492	2	fete
fets	7	53	4594	2	fets
feu	6	78	4366	2	feu
few	9	54	3696	2	few
fey	9	59	4088	2	fey
fez	15	62	3682	2	fez
fit	6	63	6545	2	fit
gat	4	68	8051	2	gat
gelt	5	64	4801	2	gelt
gent	5	69	5439	2	gent
gest	5	61	4913	2	gest
get	4	74	6746	2	get
gift	8	67	3579	2	gift
git	4	62	6605	2	git
got	4	98	7044	2	got
gut	4	67	5385	2	gut
haft	10	59	4184	2	haft
hat	6	72	8996	2	hat
heat	7	70	6142	2	heat
hefts	11	62	1815	2	hefts
hefty	14	61	1213	2	hefty
hent	7	66	5638	2	hent
hest	7	59	5077	2	hest
het	6	76	7431	2	het
hit	6	65	6919	2	hit
hot	6	77	7605	2	hot
hut	6	64	5729	2	hut
if	5	72	3994	2	if_
iff	9	67	3038	2	iff
ifs	6	71	2424	2	ifs
it	2	84	5568	2	_it
jefe	14	65	1688	2	jefe
jest	11	67	3850	2	jest
jet	10	67	5482	2	jet
jot	10	82	5902	2	jot
jut	10	59	4401	2	jut
kat	7	74	6829	2	kat
keet	8	53	4733	2	keet
kef	10	56	3966	2	kef_
kefs	11	59	2274	2	kefs
kelt	8	53	4319	2	kelt
kent	8	68	4696	2	kent
kept	10	62	3294	2	kept
kit	7	85	5987	2	kit
lat	3	75	9340	2	lat
leet	4	59	5790	2	leet
lefts	8	65	1781	2	lefts
lefty	11	56	1356	2	lefty
lent	4	63	6053	2	lent
lept	6	64	4088	2	lept
lest	4	69	5632	2	lest
let	3	64	8147	2	let
lift	7	69	4272	2	lift
lit	3	93	7731	2	lit
loft	7	65	3914	2	loft
lot	3	81	7926	2	lot
mat	5	80	8393	2	mat
meat	6	63	5960	2	meat
meet	6	53	5055	2	meet
melt	6	57	5289	2	melt
met	5	60	7243	2	met
mot	5	72	7942	2	mot
mut	5	83	5718	2	mut
neat	4	63	5678	2	neat
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
nit	3	70	6594	2	nit
not	3	94	7466	2	not
nut	3	66	5196	2	nut
oat	3	98	8826	2	oat
of	5	82	4777	2	of_
off	9	63	3163	2	off
oot	3	112	7469	2	oot
opt	5	75	4554	2	opt
ort	3	94	6523	2	ort
out	3	80	7215	2	out
pat	5	80	8946	2	pat
peat	6	59	6793	2	peat
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
pfft	12	3	1188	2	pfft
pht	8	60	3052	2	pht
pit	5	64	7192	2	pit
pot	5	80	7843	2	pot
pst	5	79	3251	2	pst
put	5	57	5907	2	put
qat	12	52	5333	2	qat
raft	7	62	4591	2	raft
rat	3	78	9274	2	rat
ref	6	60	5329	2	ref_
refit	8	42	3006	2	refit
refs	7	57	3224	2	refs
rent	4	66	6124	2	rent
rest	4	64	5984	2	rest
ret	3	59	8283	2	ret
rift	7	56	4233	2	rift
rot	3	72	8295	2	rot
rut	3	55	6052	2	rut
sat	3	62	8848	2	sat
seat	4	75	7556	2	seat
sect	6	74	4362	2	sect
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
sift	7	107	4066	2	sift
sit	3	58	7775	2	sit
soft	7	69	4282	2	soft
sot	3	103	8429	2	sot
tat	3	76	9029	2	tat
teat	4	59	6363	2	teat
teff	10	60	2376	2	teff
tent	4	61	5986	2	tent
test	4	86	5162	2	test
tet	3	92	7498	2	tet
text	11	60	3393	2	text
theft	11	41	1813	2	theft
tit	3	67	7104	2	tit
toft	7	74	4165	2	toft
tot	3	88	8477	2	tot
tuft	7	69	2951	2	tuft
tut	3	67	5809	2	tut
ut	2	86	4703	2	_ut
vat	6	78	6345	2	vat
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
waft	10	61	3900	2	waft
wat	6	73	7892	2	wat
weet	7	52	5415	2	weet
wefts	11	67	1549	2	wefts
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
wit	6	65	6377	2	wit
wot	6	104	6748	2	wot
yet	6	69	6069	2	yet
yett	7	64	3449	2	yett
zest	13	60	3570	2	zest
zit	12	60	4999	2	zit

Search took 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	274	0.423	33295.5
3	Display Results	274	274	0.046	5956.5
	(SQL Overall)	178691	274	0.532	335885.3