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

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

271 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
dell	5	69	3820	(None)
bell	6	62	3718	1	bell
cell	6	50	3172	1	cell
deal	5	63	4741	1	deal
deil	5	62	3162	1	deil
del	4	67	5275	1	de_l
dele	5	68	4308	1	dele
delf	8	54	3657	1	delf
deli	5	56	3129	1	deli
dells	6	66	3094	1	dells
delly	9	60	2387	1	delly
dels	5	67	4547	1	dels
delt	5	78	5527	1	delt
dill	5	52	3997	1	dill
doll	5	66	3249	1	doll
dull	5	64	3044	1	dull
dwell	9	51	985	1	dwell
ell	3	67	3568	1	_ell
fell	7	68	3307	1	fell
hell	7	56	3789	1	hell
jell	11	71	2587	1	jell
mell	6	49	3561	1	mell
sell	4	58	4061	1	sell
tell	4	49	3470	1	tell
well	7	58	3204	1	well
yell	7	60	2832	1	yell
all	3	61	4823	2	_all
ball	6	60	4332	2	ball
bedell	9	36	1004	2	bedell
bel	5	71	4846	2	be_l
belle	7	58	2783	2	belle
bells	7	64	3216	2	bells
belly	10	46	2549	2	belly
bels	6	61	4249	2	bels
belt	6	57	5403	2	belt
bill	6	72	3994	2	bill
boll	6	56	3475	2	boll
bull	6	56	3487	2	bull
call	6	68	3867	2	call
ceil	6	57	2506	2	ceil
cel	5	60	4055	2	ce_l
cella	7	54	2031	2	cella
celli	7	67	1769	2	celli
cello	7	49	1958	2	cello
cells	7	54	2806	2	cells
cels	6	55	3497	2	cels
celt	6	56	4671	2	celt
cull	6	59	2964	2	cull
dahl	8	70	1922	2	dahl
dal	4	75	5495	2	d_al
dale	5	56	4398	2	dale
dally	9	53	2474	2	dally
dals	5	71	4512	2	dals
de	3	70	4954	2	de__
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deals	6	54	3534	2	deals
dealt	6	52	3428	2	dealt
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
deb	6	63	4269	2	de_b
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
decal	8	55	2323	2	decal
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
dedal	7	57	1902	2	dedal
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
deet	5	73	5658	2	deet
def	7	65	4672	2	de_f
defi	8	63	2149	2	defi
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
deils	6	57	2286	2	deils
deke	9	52	2876	2	deke
delay	9	48	2063	2	delay
deled	7	53	2654	2	deled
deles	6	51	3925	2	deles
delfs	9	49	1867	2	delfs
delft	9	56	2332	2	delft
delis	6	49	2854	2	delis
delta	6	61	1777	2	delta
delts	6	57	3179	2	delts
delve	9	60	1826	2	delve
deme	7	65	3628	2	deme
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
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
desk	9	56	1890	2	desk
dev	7	60	3377	2	de_v
deva	8	57	2098	2	deva
devel	9	42	1712	2	devel
devil	9	47	1473	2	devil
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
dhal	8	67	1928	2	dhal
dial	5	59	3506	2	dial
diel	5	90	3460	2	diel
dills	6	55	3097	2	dills
dilly	9	49	2378	2	dilly
diol	5	73	2913	2	diol
dirl	5	74	3002	2	dirl
dol	4	71	5065	2	d_ol
dole	5	65	5000	2	dole
dolls	6	61	2692	2	dolls
dolly	9	61	2520	2	dolly
dols	5	69	4305	2	dols
dolt	5	66	4942	2	dolt
drill	6	47	1826	2	drill
droll	6	54	1540	2	droll
dual	5	59	2817	2	dual
duel	5	67	2970	2	duel
duelli	7	6	700	2	duelli
duello	7	5	678	2	duello
duels	6	56	1923	2	duels
dulls	6	45	2374	2	dulls
dully	9	49	2163	2	dully
duly	8	53	2303	2	duly
dwells	10	41	771	2	dwells
dwelt	9	43	1652	2	dwelt
eel	3	79	4684	2	_eel
eels	4	65	3674	2	eels
eely	7	77	2521	2	eely
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
ells	4	64	3135	2	_ells
elm	5	75	3174	2	_elm
els	3	76	4572	2	_els
fall	7	55	3531	2	fall
feal	7	139	4042	2	feal
feel	7	52	3384	2	feel
fella	8	49	1865	2	fella
fells	8	53	2738	2	fells
felly	11	49	2280	2	felly
felt	7	51	4693	2	felt
fill	7	55	4019	2	fill
full	7	52	2915	2	full
gall	5	63	3599	2	gall
gel	4	56	4243	2	ge_l
geld	6	58	2843	2	geld
gels	5	68	3610	2	gels
gelt	5	64	4801	2	gelt
gill	5	63	3618	2	gill
gull	5	48	2845	2	gull
hall	7	57	4116	2	hall
heal	7	56	4569	2	heal
heel	7	50	3422	2	heel
heil	7	63	2893	2	heil
held	8	53	3040	2	held
hello	8	65	2298	2	hello
hells	8	50	3204	2	hells
helm	9	55	3002	2	helm
helo	7	53	3285	2	helo
help	9	53	2892	2	help
herl	7	58	3455	2	herl
hill	7	64	3949	2	hill
hull	7	54	2878	2	hull
ideal	6	57	1639	2	ideal
idyll	9	43	671	2	idyll
ill	3	74	3709	2	_ill
jello	12	67	1627	2	jello
jells	12	55	2216	2	jells
jelly	15	42	1825	2	jelly
jill	11	64	3026	2	jill
keel	8	57	2946	2	keel
kelly	12	46	1702	2	kelly
kelp	10	53	2280	2	kelp
kelt	8	53	4319	2	kelt
kill	8	55	3317	2	kill
knell	9	42	1092	2	knell
kvell	12	43	669	2	kvell
lall	4	55	3131	2	lall
leal	4	60	4327	2	leal
loll	4	61	2838	2	loll
lull	4	42	2576	2	lull
mall	6	46	3936	2	mall
meal	6	56	4317	2	meal
mel	5	60	4748	2	me_l
meld	7	58	3047	2	meld
mells	7	50	3133	2	mells
mels	6	59	4153	2	mels
melt	6	57	5289	2	melt
merl	6	58	3097	2	merl
mewl	9	56	1832	2	mewl
mill	6	65	4148	2	mill
moll	6	67	3570	2	moll
mull	6	51	2880	2	mull
nelly	8	46	1881	2	nelly
nill	4	56	3430	2	nill
null	4	51	2531	2	null
pall	6	50	3934	2	pall
peal	6	86	4810	2	peal
peel	6	55	3561	2	peel
pele	6	55	3955	2	pele
pelf	9	70	3145	2	pelf
pelt	6	76	5108	2	pelt
pill	6	53	3946	2	pill
poll	6	63	3213	2	poll
pull	6	47	3166	2	pull
quell	14	43	1142	2	quell
real	4	57	5029	2	real
reel	4	52	4053	2	reel
rely	7	54	2895	2	rely
rill	4	51	4090	2	rill
roll	4	63	3165	2	roll
sall	4	45	4468	2	sall
seal	4	56	5437	2	seal
seel	4	50	4298	2	seel
sel	3	82	5332	2	se_l
self	7	51	3829	2	self
selle	5	44	2831	2	selle
sells	5	51	3443	2	sells
sels	4	63	4598	2	sels
shell	8	44	2412	2	shell
sill	4	55	4515	2	sill
skell	9	49	1583	2	skell
smell	7	49	1623	2	smell
snell	5	45	1730	2	snell
spell	7	50	2030	2	spell
swell	8	48	1598	2	swell
tall	4	72	4021	2	tall
teal	4	55	4650	2	teal
teel	4	63	3580	2	teel
tel	3	56	4790	2	te_l
tela	4	55	3297	2	tela
tele	4	50	4087	2	tele
tells	5	58	2894	2	tells
telly	8	49	2082	2	telly
tels	4	68	4169	2	tels
till	4	59	4120	2	till
toll	4	55	3526	2	toll
veal	7	69	3681	2	veal
veil	7	55	2359	2	veil
vela	7	57	2554	2	vela
veld	8	53	2320	2	veld
vill	7	52	3507	2	vill
wall	7	62	3610	2	wall
weal	7	58	3868	2	weal
weel	7	58	3408	2	weel
weld	8	47	2773	2	weld
wells	8	54	2619	2	wells
welly	11	46	2001	2	welly
welt	7	55	4786	2	welt
will	7	57	3751	2	will
yeld	8	114	2387	2	yeld
yelk	11	53	2000	2	yelk
yells	8	58	2194	2	yells
yelp	9	56	2135	2	yelp
yill	7	56	2897	2	yill
zeal	13	55	3033	2	zeal
zill	13	57	2761	2	zill

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	271	1.063	28101.6
3	Display Results	271	271	0.060	4516.7
	(SQL Overall)	178691	271	1.203	148537.8