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

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

420 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
gels	5	68	3610	(None)
bels	6	61	4249	1	bels
cels	6	55	3497	1	cels
dels	5	67	4547	1	dels
eels	4	65	3674	1	eels
els	3	76	4572	1	_els
gals	5	79	4650	1	gals
geds	6	67	3082	1	geds
gees	5	56	4788	1	gees
gel	4	56	4243	1	gel_
geld	6	58	2843	1	geld
gelds	7	51	1834	1	gelds
gelt	5	64	4801	1	gelt
gelts	6	59	2461	1	gelts
gems	7	53	2911	1	gems
gens	5	57	4007	1	gens
gets	5	54	4248	1	gets
guls	5	59	3085	1	guls
mels	6	59	4153	1	mels
sels	4	63	4598	1	sels
tels	4	68	4169	1	tels
aals	4	99	4114	2	aals
agers	6	50	2785	2	agers
ages	5	58	4459	2	age_s
ails	4	56	5472	2	ails
ales	4	70	6710	2	ales
alls	4	67	4092	2	alls
als	3	66	6302	2	_als
angels	7	44	1617	2	angels
awls	7	59	2609	2	awls
axels	12	63	1363	2	axels
bagels	9	57	1231	2	bagels
bals	6	63	5404	2	bals
beds	7	59	3779	2	beds
bees	6	54	5338	2	bees
begs	7	57	3383	2	begs
bel	5	71	4846	2	bel_
bell	6	62	3718	2	bell
bells	7	64	3216	2	bells
belt	6	57	5403	2	belt
belts	7	59	3116	2	belts
bens	6	59	4570	2	bens
bes	5	65	5743	2	be_s
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
cees	6	59	4159	2	cees
ceils	7	50	1940	2	ceils
cel	5	60	4055	2	cel_
cell	6	50	3172	2	cell
cells	7	54	2806	2	cells
celt	6	56	4671	2	celt
celts	7	53	2578	2	celts
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
cols	6	65	5308	2	cols
dals	5	71	4512	2	dals
deals	6	54	3534	2	deals
debs	7	65	3024	2	debs
dees	5	63	5663	2	dees
deils	6	57	2286	2	deils
del	4	67	5275	2	del_
dele	5	68	4308	2	dele
deles	6	51	3925	2	deles
delf	8	54	3657	2	delf
delfs	9	49	1867	2	delfs
deli	5	56	3129	2	deli
delis	6	49	2854	2	delis
dell	5	69	3820	2	dell
dells	6	66	3094	2	dells
delt	5	78	5527	2	delt
delts	6	57	3179	2	delts
dens	5	59	4507	2	dens
devs	8	64	2403	2	devs
dews	8	62	3060	2	dews
deys	8	50	2747	2	deys
dols	5	69	4305	2	dols
duels	6	56	1923	2	duels
eds	4	66	3893	2	_eds
eel	3	79	4684	2	eel_
eely	7	77	2521	2	eely
efs	6	68	2960	2	_efs
egers	6	51	2037	2	egers
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
egos	5	58	2165	2	egos
el	2	67	4529	2	_el_
eld	4	67	3380	2	_eld
elds	5	63	2486	2	_elds
elf	6	61	3852	2	_elf
elk	7	67	2612	2	_elk
elks	8	58	2003	2	_elks
ell	3	67	3568	2	_ell
ells	4	64	3135	2	ells
elm	5	75	3174	2	_elm
elms	6	73	2270	2	_elms
else	4	59	2308	2	_else
ems	5	64	3549	2	_ems
ens	3	72	4592	2	_ens
ers	3	60	4628	2	_ers
es	2	90	4822	2	_e_s
ess	3	60	3088	2	_ess
feds	8	52	3432	2	feds
feels	8	52	2304	2	feels
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fell	7	68	3307	2	fell
fells	8	53	2738	2	fells
felt	7	51	4693	2	felt
felts	8	53	2454	2	felts
fems	9	64	2870	2	fems
fens	7	61	3976	2	fens
fes	6	65	5167	2	fe_s
fess	7	65	2916	2	fess
fets	7	53	4594	2	fets
feus	7	58	3075	2	feus
fils	7	58	3870	2	fils
fuels	8	71	1735	2	fuels
gabs	7	67	4042	2	gabs
gads	6	78	4339	2	gads
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gal	4	60	5551	2	gal_
gala	5	56	3516	2	gala
galas	6	57	3164	2	galas
gale	5	63	4732	2	gale
gales	6	54	4248	2	gales
gall	5	63	3599	2	gall
galls	6	47	2932	2	galls
gams	7	66	4888	2	gams
gaols	6	67	1757	2	gaols
gaps	7	60	4297	2	gaps
gars	5	57	5074	2	gars
gas	4	88	7025	2	g_as
gats	5	67	5344	2	gats
gavels	10	59	1109	2	gavels
gays	8	73	3802	2	gays
gear	5	59	3497	2	gear
gears	6	46	2869	2	gears
geck	11	57	2199	2	geck
gecks	12	51	1709	2	gecks
ged	5	70	4454	2	ge_d
gee	4	53	5920	2	ge_e
geed	6	54	3550	2	geed
geek	9	53	2702	2	geek
geeks	10	49	1584	2	geeks
geese	6	43	1600	2	geese
geest	6	48	2962	2	geest
geez	14	64	2486	2	geez
gelee	6	36	2698	2	gelee
gelees	7	41	1626	2	gelees
gelid	7	49	1698	2	gelid
gem	6	68	4022	2	ge_m
gen	4	59	5051	2	ge_n
gene	5	62	3722	2	gene
genes	6	51	3309	2	genes
gent	5	69	5439	2	gent
gents	6	57	2961	2	gents
genu	5	59	2907	2	genu
genus	6	53	1983	2	genus
germ	7	54	2896	2	germ
germs	8	51	1887	2	germs
gesso	6	4	960	2	gesso
gest	5	61	4913	2	gest
gests	6	60	2881	2	gests
get	4	74	6746	2	ge_t
geta	5	66	2744	2	geta
getas	6	54	2148	2	getas
geum	7	54	2455	2	geum
geums	8	54	1411	2	geums
gey	7	57	3830	2	ge_y
ghees	9	52	1555	2	ghees
ghis	8	50	2016	2	ghis
gibs	7	55	2928	2	gibs
gids	6	59	3375	2	gids
gies	5	56	4143	2	gies
gigs	6	66	3119	2	gigs
gild	6	55	2652	2	gild
gilds	7	54	1753	2	gilds
gill	5	63	3619	2	gill
gills	6	47	2819	2	gills
gilt	5	63	4855	2	gilt
gilts	6	49	2426	2	gilts
gimels	9	3	889	2	gimels
gins	5	55	4396	2	gins
gips	7	56	3293	2	gips
girls	6	45	1839	2	girls
gits	5	57	4460	2	gits
gled	6	56	3114	2	gled
gleds	7	54	1789	2	gleds
glee	5	52	3906	2	glee
glees	6	50	2759	2	glees
gleg	6	62	1980	2	gleg
glen	5	60	2720	2	glen
glens	6	65	1985	2	glens
gley	8	57	2465	2	gley
gleys	9	65	1485	2	gleys
gnus	5	65	1800	2	gnus
goals	6	55	2129	2	goals
goas	5	52	3994	2	goas
gobs	7	69	3557	2	gobs
gods	6	54	3805	2	gods
goers	6	55	2025	2	goers
goes	5	56	4409	2	goes
gold	6	54	3016	2	gold
golds	7	54	2131	2	golds
golf	8	57	3118	2	golf
golfs	9	56	1610	2	golfs
goos	5	76	4491	2	goos
gos	4	71	5513	2	g_os
goys	8	63	2841	2	goys
grees	6	51	3247	2	grees
greys	9	66	1485	2	greys
gruels	7	39	1015	2	gruels
guess	6	42	1336	2	guess
gul	4	58	3279	2	gul_
gules	6	48	3104	2	gules
gulf	8	49	2942	2	gulf
gulfs	9	49	1530	2	gulfs
gull	5	48	2845	2	gull
gulls	6	52	2298	2	gulls
gulp	7	55	2136	2	gulp
gulps	8	47	1507	2	gulps
gums	7	50	3094	2	gums
guns	5	55	3348	2	guns
guts	5	66	3725	2	guts
guvs	8	58	1681	2	guvs
guys	8	50	1964	2	guys
gyms	10	75	1459	2	gyms
gyps	10	51	1502	2	gyps
heals	8	57	3346	2	heals
heels	8	56	2553	2	heels
hehs	10	67	2396	2	hehs
heils	8	52	2219	2	heils
held	8	53	3040	2	held
hell	7	56	3789	2	hell
hells	8	50	3204	2	hells
helm	9	55	3002	2	helm
helms	10	56	1946	2	helms
helo	7	53	3285	2	helo
helos	8	49	2806	2	helos
help	9	53	2892	2	help
helps	10	52	1934	2	helps
hems	9	55	3494	2	hems
hens	7	56	4257	2	hens
herls	8	52	2643	2	herls
hers	7	58	4487	2	hers
hes	6	66	5420	2	he_s
hets	7	55	4720	2	hets
hews	10	56	3157	2	hews
hols	7	69	4629	2	hols
ills	4	70	3042	2	ills
jees	11	59	3854	2	jees
jell	11	71	2587	2	jell
jells	12	55	2216	2	jells
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
keas	8	63	3710	2	keas
keels	9	46	2241	2	keels
kefs	11	59	2275	2	kefs
kegs	9	58	2403	2	kegs
kelp	10	53	2281	2	kelp
kelps	11	51	1642	2	kelps
kelt	8	53	4320	2	kelt
kelts	9	52	2263	2	kelts
kens	8	54	3524	2	kens
keps	10	60	2731	2	keps
keys	11	63	2217	2	keys
koels	9	46	1390	2	koels
kugels	11	4	607	2	kugels
leas	4	59	5418	2	leas
lees	4	54	5588	2	lees
legs	5	61	3369	2	legs
leis	4	57	3960	2	leis
leks	8	54	2760	2	leks
lens	4	61	4649	2	lens
les	3	56	6307	2	le_s
less	4	56	3510	2	less
lets	4	71	4794	2	lets
leys	7	64	3018	2	leys
meals	7	59	3338	2	meals
meds	7	57	3537	2	meds
megs	7	55	3063	2	megs
mel	5	60	4748	2	mel_
meld	7	58	3047	2	meld
melds	8	48	2238	2	melds
mell	6	49	3561	2	mell
mells	7	50	3133	2	mells
melt	6	57	5289	2	melt
melts	7	49	3010	2	melts
mems	8	59	3150	2	mems
merls	7	74	2390	2	merls
mess	6	59	3243	2	mess
mewls	10	58	1323	2	mewls
mews	9	66	2933	2	mews
mils	6	60	4534	2	mils
mols	6	59	4857	2	mols
nebs	6	61	2498	2	nebs
negs	5	57	2736	2	negs
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
news	7	61	2737	2	news
nils	4	61	3246	2	nils
noels	5	64	1870	2	noels
oes	3	58	6619	2	oe_s
ogees	6	51	1914	2	ogees
ogles	6	52	2318	2	ogles
oils	4	63	3798	2	oils
oles	4	64	5347	2	oles
owls	7	60	2293	2	owls
pals	6	69	5135	2	pals
peals	7	52	3549	2	peals
peas	6	57	5506	2	peas
pecs	8	46	3410	2	pecs
peds	7	58	3525	2	peds
peels	7	52	2642	2	peels
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
pele	6	55	3955	2	pele
peles	7	57	3808	2	peles
pelf	9	70	3145	2	pelf
pelfs	10	50	1629	2	pelfs
pelt	6	76	5108	2	pelt
pelts	7	61	2881	2	pelts
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
pes	5	72	5978	2	pe_s
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
pols	6	60	4456	2	pols
puls	6	54	3756	2	puls
reals	5	50	3865	2	reals
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4287	2	reds
reels	5	53	3326	2	reels
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
rely	7	54	2895	2	rely
rems	6	62	3772	2	rems
reps	6	59	3795	2	reps
res	3	55	6504	2	re_s
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
riels	5	51	2133	2	riels
sals	4	68	5167	2	sals
seals	5	48	3970	2	seals
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
seels	5	56	3282	2	seels
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sel	3	82	5332	2	sel_
self	7	51	3829	2	self
selfs	8	52	2024	2	selfs
sell	4	58	4061	2	sell
sells	5	51	3443	2	sells
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sews	7	58	3602	2	sews
sols	4	54	4816	2	sols
taels	5	68	2207	2	taels
teals	5	62	3413	2	teals
teas	4	58	5149	2	teas
teds	5	49	3258	2	teds
teels	5	57	2637	2	teels
tees	4	53	5358	2	tees
tegs	5	60	3149	2	tegs
tel	3	56	4790	2	tel_
tela	4	55	3297	2	tela
tele	4	50	4087	2	tele
teles	5	45	3600	2	teles
tell	4	49	3470	2	tell
tells	5	58	2894	2	tells
telos	5	54	2452	2	telos
tens	4	56	4741	2	tens
tets	4	58	4746	2	tets
tews	7	64	3164	2	tews
tils	4	57	3962	2	tils
veals	8	49	2619	2	veals
vees	7	54	3943	2	vees
veils	8	49	1880	2	veils
vela	7	57	2554	2	vela
veld	8	53	2320	2	veld
velds	9	56	1558	2	velds
vets	7	68	3509	2	vets
weals	8	54	2874	2	weals
webs	9	66	2212	2	webs
weds	8	66	2894	2	weds
wees	7	62	4912	2	wees
weld	8	47	2773	2	weld
welds	9	47	1916	2	welds
well	7	58	3204	2	well
wells	8	54	2619	2	wells
welsh	11	31	1036	2	welsh
welt	7	55	4786	2	welt
welts	8	52	2519	2	welts
wens	7	63	3793	2	wens
wets	7	59	4029	2	wets
yeas	7	86	3842	2	yeas
yeld	8	114	2387	2	yeld
yelk	11	53	2000	2	yelk
yelks	12	64	1362	2	yelks
yell	7	60	2832	2	yell
yells	8	58	2194	2	yells
yelp	9	56	2135	2	yelp
yelps	10	57	1299	2	yelps
yens	7	58	3226	2	yens
yeps	9	59	2440	2	yeps
yes	6	62	5061	2	ye_s
yews	10	53	2396	2	yews
zeals	14	53	2085	2	zeals
zeds	14	58	2181	2	zeds
zees	13	63	3189	2	zees
zeks	17	58	1506	2	zeks
zeps	15	60	1934	2	zeps

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.263	679433.5
2	DLD Change Limit	29872	420	0.906	32971.3
3	Display Results	420	420	0.110	3818.2
	(SQL Overall)	178691	420	1.279	139711.5