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

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

260 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
diel	5	90	3460	(None)
deil	5	62	3162	1	deil
del	4	67	5275	1	d_el
dial	5	59	3506	1	dial
die	4	67	5965	1	die_
died	6	61	3785	1	died
dies	5	56	5352	1	dies
diet	5	73	5753	1	diet
dill	5	52	3997	1	dill
diol	5	73	2913	1	diol
dirl	5	74	3002	1	dirl
duel	5	67	2970	1	duel
riel	4	64	3238	1	riel
adieu	6	4	1742	2	adieu
ail	3	71	7104	2	ai_l
ariel	5	52	2897	2	ariel
axel	11	52	2207	2	axel
bel	5	71	4846	2	_bel
bield	8	46	1465	2	bield
bier	6	55	3182	2	bier
bile	6	61	4717	2	bile
bill	6	72	3993	2	bill
birl	6	58	3046	2	birl
ceil	6	57	2506	2	ceil
cel	5	60	4055	2	_cel
chiel	10	49	1897	2	chiel
dahl	8	70	1922	2	dahl
dal	4	75	5495	2	d_al
dale	5	56	4398	2	dale
de	3	70	4954	2	d_e_
deal	5	63	4741	2	deal
deb	6	63	4269	2	d_eb
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
deet	5	73	5658	2	deet
def	7	65	4672	2	d_ef
deils	6	57	2286	2	deils
dele	5	68	4308	2	d_ele
delf	8	54	3657	2	d_elf
deli	5	56	3129	2	d_eli
dell	5	69	3820	2	dell
dels	5	67	4547	2	d_els
delt	5	78	5527	2	d_elt
den	4	75	5434	2	d_en
dev	7	60	3377	2	d_ev
devel	9	42	1712	2	devel
dew	7	71	3992	2	d_ew
dex	11	69	3688	2	d_ex
dey	7	72	4337	2	d_ey
dhal	8	67	1928	2	dhal
dials	6	49	2534	2	dials
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
did	5	68	5051	2	di_d
dido	6	65	2819	2	dido
didy	9	91	2150	2	didy
diene	6	57	2013	2	diene
diesel	7	44	1040	2	diesel
diets	6	60	2664	2	diets
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
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
dills	6	55	3097	2	dills
dilly	9	49	2378	2	dilly
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
dimly	11	49	1348	2	dimly
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
dint	5	67	5905	2	dint
diols	6	55	2101	2	diols
dip	6	78	4898	2	di_p
dips	7	55	3691	2	dips
dipt	7	73	3932	2	dipt
dire	5	66	4414	2	dire
direly	10	3	1155	2	direly
direr	6	49	2707	2	direr
dirk	9	63	2683	2	dirk
dirls	6	47	2050	2	dirls
dirt	5	55	5038	2	dirt
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
dispel	9	3	1032	2	dispel
diss	5	64	3448	2	diss
dit	4	70	7133	2	di_t
dita	5	60	3252	2	dita
dite	5	55	4755	2	dite
dites	6	63	3915	2	dites
dits	5	64	5052	2	dits
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
dives	9	58	3240	2	dives
dizen	15	52	1493	2	dizen
doe	4	73	6195	2	doe_
doer	5	77	3470	2	doer
does	5	65	5447	2	does
dol	4	71	5065	2	d_ol
dole	5	65	5000	2	dole
doll	5	66	3249	2	doll
dowel	9	56	1819	2	dowel
dree	5	66	3832	2	dree
dreg	6	68	2165	2	dreg
drek	9	63	2108	2	drek
drew	8	62	2167	2	drew
dried	7	53	2138	2	dried
drier	6	44	2396	2	drier
dries	6	47	3367	2	dries
drill	6	47	1826	2	drill
drivel	10	51	1038	2	drivel
dual	5	59	2817	2	dual
due	4	52	4986	2	due_
duels	6	56	1923	2	duels
dues	5	60	4550	2	dues
duet	5	64	4626	2	duet
dull	5	64	3044	2	dull
dwell	9	51	985	2	dwell
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
dynel	9	56	985	2	dynel
edile	6	48	1949	2	edile
eel	3	79	4684	2	_eel
el	2	67	4529	2	__el
feel	7	52	3384	2	feel
fie	6	71	5244	2	fie_
fief	10	73	3135	2	fief
field	9	50	1532	2	field
fil	6	54	4714	2	fi_l
file	7	54	4664	2	file
fill	7	55	4019	2	fill
fuel	7	68	2473	2	fuel
gel	4	56	4243	2	_gel
gie	4	71	4954	2	gie_
gied	6	46	3198	2	gied
gien	5	63	3002	2	gien
gies	5	56	4142	2	gies
gill	5	63	3618	2	gill
gimel	8	3	1335	2	gimel
girl	5	62	2655	2	girl
heel	7	50	3422	2	heel
heil	7	63	2893	2	heil
hie	6	76	5270	2	hie_
hied	8	54	3404	2	hied
hies	7	48	4283	2	hies
hill	7	64	3949	2	hill
idea	5	91	2277	2	idea
ideal	6	57	1639	2	ideal
idem	7	61	2106	2	idem
ides	5	77	3423	2	ides
idle	5	54	2376	2	idle
idol	5	68	1863	2	idol
idyl	8	59	1230	2	idyl
ill	3	74	3709	2	_ill
jill	11	64	3026	2	jill
keel	8	57	2946	2	keel
kief	11	71	2839	2	kief
kier	8	65	2680	2	kier
kill	8	55	3317	2	kill
koel	8	45	1994	2	koel
libel	7	41	1610	2	libel
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
mel	5	60	4748	2	_mel
mien	6	50	2835	2	mien
mil	5	57	5210	2	mi_l
mile	6	63	5256	2	mile
mill	6	65	4147	2	mill
nil	3	61	4419	2	ni_l
nill	4	56	3430	2	nill
noel	4	52	2655	2	noel
oil	3	74	5205	2	oi_l
oriel	5	49	2042	2	oriel
peel	6	55	3561	2	peel
pial	6	56	3670	2	pial
pie	5	54	5740	2	pie_
pied	7	50	3536	2	pied
pier	6	60	3529	2	pier
pies	6	69	4960	2	pies
pile	6	56	4969	2	pile
pill	6	53	3946	2	pill
pixel	14	39	1190	2	pixel
reel	4	52	4053	2	reel
rial	4	59	3809	2	rial
riels	5	51	2133	2	riels
rile	4	56	5053	2	rile
rill	4	51	4090	2	rill
seel	4	50	4298	2	seel
sel	3	82	5332	2	_sel
shiel	8	110	2377	2	shiel
sial	4	59	3883	2	sial
sill	4	55	4515	2	sill
spiel	7	46	2391	2	spiel
tael	4	60	3071	2	tael
teel	4	63	3580	2	teel
tel	3	56	4790	2	_tel
tie	3	65	5753	2	tie_
tied	5	55	3521	2	tied
tier	4	49	3614	2	tier
ties	4	52	4831	2	ties
til	3	63	5026	2	ti_l
tile	4	54	5144	2	tile
till	4	59	4120	2	till
tirl	4	50	2992	2	tirl
veil	7	55	2359	2	veil
vial	7	67	3109	2	vial
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
vile	7	61	3980	2	vile
vill	7	52	3507	2	vill
viol	7	65	2359	2	viol
virl	7	62	2447	2	virl
weel	7	58	3408	2	weel
wield	9	52	1391	2	wield
wile	7	59	4437	2	wile
will	7	57	3751	2	will
yield	9	51	969	2	yield
yill	7	56	2897	2	yill
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.076	2351197.4
2	DLD Change Limit	29872	260	0.876	34100.5
3	Display Results	260	260	0.063	4127.0
	(SQL Overall)	178691	260	1.015	176050.2