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

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

281 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
deals	6	54	3534	(None)
dals	5	71	4512	1	d_als
deads	7	57	2691	1	deads
deal	5	63	4741	1	deal_
dealt	6	52	3428	1	dealt
deans	6	61	3139	1	deans
dears	6	57	3688	1	dears
decals	9	37	1771	1	decals
deils	6	57	2286	1	deils
dells	6	66	3094	1	dells
dels	5	67	4547	1	de_ls
dhals	9	54	1544	1	dhals
dials	6	49	2534	1	dials
duals	6	56	2008	1	duals
heals	8	57	3345	1	heals
ideals	7	50	1250	1	ideals
meals	7	59	3337	1	meals
peals	7	52	3549	1	peals
reals	5	50	3865	1	reals
seals	5	48	3969	1	seals
teals	5	62	3413	1	teals
veals	8	49	2619	1	veals
weals	8	54	2874	1	weals
zeals	14	53	2085	1	zeals
aals	4	99	4114	2	_aals
als	3	66	6302	2	__als
baals	7	61	2270	2	baals
bals	6	63	5404	2	_bals
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
bears	7	57	3904	2	bears
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
bells	7	64	3216	2	bells
bels	6	61	4249	2	be_ls
ceils	7	50	1940	2	ceils
cells	7	54	2806	2	cells
cels	6	55	3497	2	ce_ls
coals	7	61	2960	2	coals
dabs	7	71	3940	2	d_abs
dads	6	74	4277	2	d_ads
dags	6	66	4259	2	d_ags
dahls	9	50	1228	2	dahls
dahs	8	82	3181	2	d_ahs
dais	5	70	4070	2	d_ais
daks	9	71	3060	2	d_aks
dal	4	75	5495	2	d_al_
dale	5	56	4398	2	d_ale
dales	6	64	3974	2	d_ales
dams	7	74	4437	2	d_ams
dans	5	67	4814	2	d_ans
daps	7	72	3916	2	d_aps
daws	8	66	3824	2	d_aws
days	8	76	3713	2	d_ays
dead	6	54	3424	2	dea_d
deadly	11	38	1147	2	deadly
deaf	8	58	3840	2	dea_f
deafly	13	38	912	2	deafly
deair	6	58	1719	2	deair
deairs	7	40	1378	2	deairs
dealer	7	41	2214	2	dealer
dealers	8	41	1861	2	dealers
dean	5	60	3948	2	dea_n
dear	5	53	4360	2	dea_r
dearly	10	46	1532	2	dearly
deary	9	58	2684	2	deary
deash	9	56	1724	2	deash
death	9	48	2252	2	death
deaths	10	59	1444	2	deaths
deave	9	50	2233	2	deave
deaves	10	53	1953	2	deaves
debags	10	42	1106	2	debags
debars	9	42	1804	2	debars
debs	7	65	3024	2	de_bs
debts	8	64	1837	2	debts
decafs	12	40	1088	2	decafs
decal	8	55	2323	2	decal_
decays	12	46	1291	2	decays
decks	12	48	2219	2	decks
decos	8	55	2212	2	decos
dedal	7	57	1902	2	dedal_
dedans	8	59	1507	2	dedans
deeds	7	54	2376	2	deeds
deems	8	54	2177	2	deems
deeps	8	49	2177	2	deeps
deers	6	49	3052	2	deers
dees	5	63	5663	2	de_es
deets	6	53	3024	2	deets
defats	10	51	1455	2	defats
defis	9	67	1750	2	defis
degas	7	51	1916	2	degas
deil	5	62	3162	2	deil_
dekes	10	52	2445	2	dekes
del	4	67	5275	2	de_l_
delay	9	48	2063	2	delay
delays	10	40	1405	2	delays
dele	5	68	4308	2	de_le
deles	6	51	3925	2	deles
delf	8	54	3657	2	de_lf
delfs	9	49	1867	2	delfs
deli	5	56	3129	2	de_li
delis	6	49	2854	2	delis
dell	5	69	3820	2	de_ll
delly	9	60	2387	2	delly
delt	5	78	5527	2	de_lt
delts	6	57	3179	2	delts
demes	8	60	3269	2	demes
demos	8	60	2299	2	demos
denars	7	46	2143	2	denars
denes	6	56	3972	2	denes
denials	8	41	1413	2	denials
dens	5	59	4507	2	de_ns
dentals	8	39	1539	2	dentals
dents	6	50	3180	2	dents
derails	8	42	1639	2	derails
derats	7	46	2506	2	derats
derays	10	55	1425	2	derays
derms	8	50	2289	2	derms
desalt	7	5	1831	2	desalt
desalts	8	3	957	2	desalts
desks	10	59	1307	2	desks
details	8	42	1404	2	details
devas	9	62	1888	2	devas
devels	10	43	1390	2	devels
devils	10	44	1281	2	devils
devs	8	64	2403	2	de_vs
dewans	10	52	1514	2	dewans
dewars	10	51	1707	2	dewars
dews	8	62	3060	2	de_ws
dexes	13	52	2451	2	dexes
deys	8	50	2747	2	de_ys
dhaks	13	47	970	2	dhaks
dhal	8	67	1928	2	dhal_
dial	5	59	3506	2	dial_
dills	6	55	3097	2	dills
diols	6	55	2101	2	diols
dirls	6	47	2050	2	dirls
doats	6	52	2488	2	doats
dolls	6	61	2692	2	dolls
dols	5	69	4305	2	d_ols
drabs	8	51	1967	2	drabs
drags	7	55	2111	2	drags
drails	7	47	1695	2	drails
drams	8	60	2583	2	drams
drats	6	66	2837	2	drats
drawls	10	55	1139	2	drawls
draws	9	51	1937	2	draws
drays	9	58	1977	2	drays
dreads	8	41	1502	2	dreads
dreams	9	45	1398	2	dreams
drears	7	46	1425	2	drears
duads	7	65	1534	2	duads
dual	5	59	2817	2	dual_
duels	6	56	1923	2	duels
dulls	6	45	2374	2	dulls
dwells	10	41	771	2	dwells
dyads	10	54	997	2	dyads
earls	5	61	2751	2	_earls
ears	4	63	5659	2	_ears
eats	4	70	5487	2	_eats
eels	4	65	3674	2	_eels
ells	4	64	3135	2	_ells
els	3	76	4572	2	_e_ls
feal	7	139	4042	2	feal_
fears	8	48	2939	2	fears
feats	8	64	3275	2	feats
feels	8	52	2304	2	feels
fells	8	53	2738	2	fells
ferals	9	42	1664	2	ferals
foals	8	57	2169	2	foals
gals	5	79	4650	2	_gals
gears	6	46	2869	2	gears
gels	5	68	3610	2	ge_ls
goals	6	55	2129	2	goals
heads	9	51	2711	2	heads
heal	7	56	4569	2	heal_
heaps	10	52	2322	2	heaps
hears	8	67	3737	2	hears
heats	8	58	3840	2	heats
heels	8	56	2553	2	heels
heils	8	52	2219	2	heils
hells	8	50	3204	2	hells
herls	8	52	2643	2	herls
ideal	6	57	1639	2	ideal_
ideas	6	59	1901	2	idea_s
jeans	12	60	2211	2	jeans
jells	12	55	2216	2	jells
keas	8	63	3709	2	kea_s
keels	9	46	2241	2	keels
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leal	4	60	4327	2	leal_
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lears	5	59	3873	2	lears
leas	4	59	5418	2	lea_s
legals	7	34	1273	2	legals
meads	8	54	2532	2	meads
meal	6	56	4317	2	meal_
mealy	10	44	2218	2	mealy
means	7	58	3122	2	means
meats	7	50	3405	2	meats
medals	9	42	1804	2	medals
mells	7	50	3133	2	mells
mels	6	59	4153	2	me_ls
merls	7	74	2390	2	merls
metals	8	45	2088	2	metals
mewls	10	58	1323	2	mewls
neaps	7	56	1832	2	neaps
nears	5	55	2942	2	nears
neats	5	59	3190	2	neats
opals	7	57	1835	2	opals
orals	5	58	2648	2	orals
ordeals	8	7	799	2	ordeals
ovals	8	54	1339	2	ovals
pals	6	69	5135	2	_pals
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peal	6	86	4810	2	peal_
peans	7	54	3764	2	peans
pearls	8	47	1539	2	pearls
pears	7	51	3861	2	pears
peas	6	57	5506	2	pea_s
peats	7	61	4019	2	peats
pedals	9	43	1603	2	pedals
peels	7	52	2642	2	peels
petals	8	47	1981	2	petals
reads	6	48	3527	2	reads
real	4	57	5029	2	real_
reales	6	49	3412	2	reales
realm	7	56	2162	2	realm
realms	8	49	1349	2	realms
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rears	5	47	3965	2	rears
reels	5	53	3326	2	reels
rials	5	50	2667	2	rials
sals	4	68	5167	2	_sals
seal	4	56	5437	2	seal_
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
seels	5	56	3282	2	seels
sells	5	51	3443	2	sells
sels	4	63	4598	2	se_ls
sepals	8	52	1737	2	sepals
sheals	9	44	2064	2	sheals
sials	5	42	2724	2	sials
steals	6	40	2006	2	steals
taels	5	68	2207	2	taels
teaks	9	42	2290	2	teaks
teal	4	55	4650	2	teal_
teams	7	57	2651	2	teams
tears	5	54	3646	2	tears
teas	4	58	5149	2	tea_s
teats	5	56	3681	2	teats
teels	5	57	2637	2	teels
tells	5	58	2894	2	tells
tels	4	68	4169	2	te_ls
tepals	8	54	1504	2	tepals
veal	7	69	3681	2	veal_
vealy	11	58	1777	2	vealy
veils	8	49	1880	2	veils
vials	8	58	2238	2	vials
weal	7	58	3868	2	weal_
weald	9	56	1502	2	weald
wealds	10	45	910	2	wealds
weans	8	53	2674	2	weans
wears	8	60	3030	2	wears
wells	8	54	2619	2	wells
wheals	12	45	1252	2	wheals
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
yells	8	58	2194	2	yells
zeal	13	55	3033	2	zeal_

Search took 5 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	53800	0.190	940478.9
2	DLD Change Limit	53800	281	3.796	14172.8
3	Display Results	281	281	0.203	1384.2
	(SQL Overall)	178691	281	4.189	42657.2