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

Here are the results of your fuzzy-string dictionary search for “delt” 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
delt	5	78	5527	(None)
belt	6	57	5403	1	belt
celt	6	56	4671	1	celt
dealt	6	52	3428	1	dealt
debt	7	71	3902	1	debt
deet	5	73	5658	1	deet
deft	8	55	4022	1	deft
del	4	67	5275	1	del_
dele	5	68	4308	1	dele
delf	8	54	3657	1	delf
delft	9	56	2332	1	delft
deli	5	56	3129	1	deli
dell	5	69	3820	1	dell
dels	5	67	4547	1	dels
delta	6	61	1777	1	delta
delts	6	57	3179	1	delts
dent	5	71	5841	1	dent
dolt	5	66	4942	1	dolt
dwelt	9	43	1652	1	dwelt
felt	7	51	4693	1	felt
gelt	5	64	4801	1	gelt
kelt	8	53	4319	1	kelt
melt	6	57	5289	1	melt
pelt	6	76	5108	1	pelt
welt	7	55	4786	1	welt
adept	8	12	1964	2	adept
adult	6	35	2065	2	adult
alt	3	64	6796	2	_alt
beat	6	61	6830	2	beat
beet	6	64	5754	2	beet
bel	5	71	4846	2	bel_
bell	6	62	3718	2	bell
bels	6	61	4249	2	bels
belts	7	59	3116	2	belts
bent	6	77	5991	2	bent
best	6	63	5532	2	best
bet	5	83	7667	2	be_t
blet	6	62	4767	2	blet
bolt	6	62	5417	2	bolt
cel	5	60	4055	2	cel_
cell	6	50	3172	2	cell
cels	6	55	3497	2	cels
celts	7	53	2578	2	celts
cent	6	74	5101	2	cent
colt	6	71	5824	2	colt
cult	6	65	4115	2	cult
daft	8	55	3725	2	daft
dal	4	75	5495	2	dal_
dale	5	56	4398	2	dale
dals	5	71	4512	2	dals
dart	5	58	5787	2	dart
daut	5	64	4356	2	daut
dawt	8	54	3594	2	dawt
de	3	70	4954	2	de__
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
deals	6	54	3534	2	deals
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
death	9	48	2252	2	death
deb	6	63	4269	2	de_b
debit	8	57	2785	2	debit
debs	7	65	3024	2	debs
debts	8	64	1837	2	debts
debut	8	60	2414	2	debut
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
dee	4	76	6582	2	de_e
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	de_f
defat	9	54	2669	2	defat
defi	8	63	2149	2	defi
defy	11	49	2126	2	defy
deil	5	62	3162	2	deil
deils	6	57	2286	2	deils
deist	6	46	3359	2	deist
deity	9	43	1677	2	deity
deke	9	52	2876	2	deke
delate	7	38	2775	2	delate
delay	9	48	2063	2	delay
deled	7	53	2654	2	deled
deles	6	51	3925	2	deles
delete	7	36	2070	2	delete
delfs	9	49	1867	2	delfs
delfts	10	43	967	2	delfts
delict	9	43	2033	2	delict
delis	6	49	2854	2	delis
delist	7	46	2505	2	delist
dells	6	66	3094	2	dells
delly	9	60	2387	2	delly
deltas	7	44	1482	2	deltas
deltic	9	3	1250	2	deltic
delve	9	60	1826	2	delve
deme	7	65	3628	2	deme
demit	8	48	3230	2	demit
demo	7	74	2755	2	demo
demy	10	54	2285	2	demy
den	4	75	5434	2	de_n
dene	5	66	4341	2	dene
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
desalt	7	5	1831	2	desalt
desk	9	56	1890	2	desk
dev	7	60	3377	2	de_v
deva	8	57	2098	2	deva
devs	8	64	2403	2	devs
dew	7	71	3992	2	de_w
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
dex	11	69	3688	2	de_x
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	de_y
deys	8	50	2747	2	deys
diel	5	90	3460	2	diel_
diet	5	73	5753	2	diet
dill	5	52	3997	2	dill
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
doat	5	69	4767	2	doat
doest	6	58	2952	2	doest
doit	5	63	4785	2	doit
dol	4	71	5065	2	dol_
dole	5	65	5000	2	dole
doll	5	66	3249	2	doll
dols	5	69	4305	2	dols
dolts	6	56	2631	2	dolts
dost	5	72	4835	2	dost
dot	4	75	7318	2	d_ot
drat	5	62	4783	2	drat
drest	6	55	3034	2	drest
duct	7	57	3546	2	duct
duel	5	67	2970	2	duel_
duels	6	56	1923	2	duels
duet	5	64	4626	2	duet
duit	5	62	4158	2	duit
dull	5	64	3044	2	dull
duly	8	53	2303	2	duly
dunt	5	57	4687	2	dunt
dust	5	71	4253	2	dust
dwell	9	51	985	2	dwell
eat	3	69	8905	2	_eat
edit	5	49	3486	2	edit
eel	3	79	4684	2	eel_
eels	4	65	3674	2	eels
eely	7	77	2521	2	eely
eft	6	60	3882	2	_eft
el	2	67	4529	2	_el_
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
et	2	69	6419	2	_e_t
feat	7	64	5822	2	feat
feet	7	53	5221	2	feet
fell	7	68	3307	2	fell
felts	8	53	2454	2	felts
fest	7	49	4944	2	fest
fet	6	64	7163	2	fe_t
gel	4	56	4243	2	gel_
geld	6	58	2843	2	geld
gels	5	68	3610	2	gels
gelts	6	59	2461	2	gelts
gent	5	69	5439	2	gent
gest	5	61	4913	2	gest
get	4	74	6746	2	ge_t
gilt	5	63	4854	2	gilt
halt	7	60	5630	2	halt
heat	7	70	6142	2	heat
heft	10	67	3629	2	heft
held	8	53	3040	2	held
hell	7	56	3789	2	hell
helm	9	55	3002	2	helm
helo	7	53	3285	2	helo
helot	8	53	3268	2	helot
help	9	53	2892	2	help
hent	7	66	5638	2	hent
hest	7	59	5077	2	hest
het	6	76	7431	2	he_t
hilt	7	58	5071	2	hilt
holt	7	78	5258	2	holt
jell	11	71	2587	2	jell
jest	11	67	3850	2	jest
jet	10	67	5482	2	je_t
jilt	11	58	3942	2	jilt
jolt	11	66	3912	2	jolt
keet	8	53	4733	2	keet
kelp	10	53	2280	2	kelp
kelts	9	52	2263	2	kelts
kent	8	68	4696	2	kent
kept	10	62	3294	2	kept
kilt	8	61	4441	2	kilt
knelt	9	46	1768	2	knelt
leet	4	59	5790	2	leet
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	le_t
lilt	4	63	4994	2	lilt
malt	6	62	5481	2	malt
meat	6	63	5960	2	meat
meet	6	53	5055	2	meet
mel	5	60	4748	2	mel_
meld	7	58	3047	2	meld
mell	6	49	3561	2	mell
mels	6	59	4153	2	mels
melts	7	49	3010	2	melts
melty	10	49	1836	2	melty
met	5	60	7243	2	me_t
milt	6	54	5581	2	milt
molt	6	63	5616	2	molt
neat	4	63	5678	2	neat
nest	4	55	4873	2	nest
net	3	66	7029	2	ne_t
nett	4	66	4323	2	nett
newt	7	69	3374	2	newt
next	11	66	3108	2	next
peat	6	59	6793	2	peat
pele	6	55	3955	2	pele
pelf	9	70	3145	2	pelf
pelts	7	61	2881	2	pelts
pent	6	65	5907	2	pent
pert	6	67	5932	2	pert
pest	6	55	5529	2	pest
pet	5	64	7730	2	pe_t
reft	7	51	4127	2	reft
relet	5	47	4982	2	relet
relit	5	53	4068	2	relit
rely	7	54	2895	2	rely
rent	4	66	6124	2	rent
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
salt	4	57	5852	2	salt
seat	4	75	7556	2	seat
sect	6	74	4362	2	sect
sel	3	82	5332	2	sel_
self	7	51	3829	2	self
sell	4	58	4061	2	sell
sels	4	63	4598	2	sels
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
set	3	66	8125	2	se_t
sett	4	59	4905	2	sett
sext	11	73	3809	2	sext
silt	4	65	5819	2	silt
smelt	7	47	2678	2	smelt
spelt	7	54	3019	2	spelt
teat	4	59	6363	2	teat
tel	3	56	4790	2	tel_
tela	4	55	3297	2	tela
tele	4	50	4087	2	tele
tell	4	49	3470	2	tell
tels	4	68	4169	2	tels
tent	4	61	5986	2	tent
test	4	86	5162	2	test
tet	3	92	7499	2	te_t
text	11	60	3393	2	text
tilt	4	62	5242	2	tilt
vela	7	57	2554	2	vela
veld	8	53	2320	2	veld
veldt	9	48	1986	2	veldt
vent	7	60	4905	2	vent
vert	7	72	4937	2	vert
vest	7	57	4360	2	vest
vet	6	59	5852	2	ve_t
vext	14	69	2776	2	vext
volt	7	64	3953	2	volt
weet	7	52	5415	2	weet
weft	10	54	3501	2	weft
weld	8	47	2773	2	weld
well	7	58	3204	2	well
welts	8	52	2519	2	welts
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	we_t
wilt	7	62	4629	2	wilt
yeld	8	114	2387	2	yeld
yelk	11	53	2000	2	yelk
yell	7	60	2832	2	yell
yelp	9	56	2135	2	yelp
yet	6	69	6069	2	ye_t
yett	7	64	3449	2	yett
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.280	638182.1
2	DLD Change Limit	29872	302	0.860	34734.9
3	Display Results	302	302	0.063	4793.7
	(SQL Overall)	178691	302	1.203	148537.8