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

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

366 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
geds	6	67	3081	(None)
beds	7	59	3778	1	beds
eds	4	66	3892	1	_eds
feds	8	52	3431	1	feds
gads	6	78	4338	1	gads
ged	5	70	4453	1	ged_
gees	5	56	4788	1	gees
gelds	7	51	1834	1	gelds
gels	5	68	3610	1	gels
gems	7	53	2911	1	gems
gens	5	57	4007	1	gens
gets	5	54	4248	1	gets
gids	6	59	3373	1	gids
gleds	7	54	1789	1	gleds
gods	6	54	3804	1	gods
meds	7	57	3536	1	meds
peds	7	58	3524	1	peds
reds	5	60	4286	1	reds
teds	5	49	3257	1	teds
weds	8	66	2893	1	weds
zeds	14	58	2180	1	zeds
adds	6	76	2245	2	adds
ads	4	97	5573	2	_ads
aedes	6	46	2514	2	aedes
aged	6	73	3425	2	aged_
agers	6	50	2785	2	agers
ages	5	58	4459	2	age_s
aids	5	78	4635	2	aids
ands	5	78	3361	2	ands
bads	7	70	4886	2	bads
beads	8	54	2950	2	beads
bed	6	79	5062	2	bed_
bedu	7	59	2369	2	bedu
bees	6	54	5338	2	bees
begs	7	57	3383	2	begs
bels	6	61	4249	2	bels
bends	8	56	2897	2	bends
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
bids	7	58	3843	2	bids
bods	7	62	4471	2	bods
buds	7	52	3517	2	buds
cads	7	61	4452	2	cads
cede	7	49	2876	2	cede
cedes	8	49	2732	2	cedes
cedi	7	49	1927	2	cedi
cedis	8	43	1708	2	cedis
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
cods	7	68	4810	2	cods
coeds	8	59	2016	2	coeds
creds	8	54	1877	2	creds
cuds	7	67	3047	2	cuds
dads	6	74	4277	2	dads
deads	7	57	2691	2	deads
debs	7	65	3024	2	debs
deeds	7	54	2376	2	deeds
dees	5	63	5663	2	dees
dels	5	67	4547	2	dels
dens	5	59	4507	2	dens
devs	8	64	2403	2	devs
dews	8	62	3060	2	dews
deys	8	50	2747	2	deys
duds	6	55	3014	2	duds
ed	3	86	4518	2	_ed_
edh	7	69	2156	2	_edh
edhs	8	62	1210	2	_edhs
eels	4	65	3674	2	eels
efs	6	68	2960	2	_efs
egads	7	46	1092	2	egads
egers	6	51	2037	2	egers
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
egos	5	58	2165	2	egos
elds	5	63	2485	2	elds
els	3	76	4572	2	_els
ems	5	64	3549	2	_ems
ends	5	65	2852	2	ends
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
fads	8	69	3987	2	fads
fed	7	65	4835	2	fed_
feeds	9	49	2114	2	feeds
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fems	9	64	2870	2	fems
fends	9	63	2497	2	fends
fens	7	61	3976	2	fens
feods	9	95	1685	2	feods
fes	6	65	5167	2	fe_s
fess	7	65	2916	2	fess
fets	7	53	4594	2	fets
feuds	9	59	1488	2	feuds
feus	7	58	3075	2	feus
fids	8	70	3473	2	fids
fuds	8	65	2856	2	fuds
gabs	7	67	4042	2	gabs
gad	5	75	5665	2	gad_
gadi	6	63	2972	2	gadi
gadis	7	48	2529	2	gadis
gaed	6	60	3151	2	gaed_
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gals	5	79	4650	2	gals
gams	7	66	4888	2	gams
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
gauds	7	57	1772	2	gauds
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
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	2961	2	geest
geez	14	64	2486	2	geez
gel	4	56	4243	2	ge_l
geld	6	58	2843	2	geld
gelt	5	64	4801	2	gelt
gelts	6	59	2461	2	gelts
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
geode	7	4	1259	2	geode
geodes	8	4	1215	2	geodes
geoids	8	36	984	2	geoids
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	2927	2	gibs
gid	5	70	4726	2	gid_
gied	6	46	3198	2	gied_
gies	5	56	4142	2	gies
gigs	6	66	3118	2	gigs
gilds	7	54	1752	2	gilds
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
girds	7	48	1699	2	girds
gits	5	57	4459	2	gits
glads	7	56	2061	2	glads
gled	6	56	3114	2	gled_
glede	7	55	1783	2	glede
gledes	8	49	1513	2	gledes
gleeds	8	47	1162	2	gleeds
glees	6	50	2759	2	glees
glens	6	65	1985	2	glens
gleys	9	65	1485	2	gleys
gnus	5	65	1800	2	gnus
goads	7	70	2285	2	goads
goas	5	52	3994	2	goas
gobs	7	69	3557	2	gobs
god	5	74	4979	2	god_
goers	6	55	2025	2	goers
goes	5	56	4409	2	goes
golds	7	54	2131	2	golds
goods	7	51	2448	2	goods
goos	5	76	4491	2	goos
gos	4	71	5513	2	g_os
gowds	10	58	1404	2	gowds
goys	8	63	2841	2	goys
grads	7	56	2575	2	grads
greeds	8	43	1428	2	greeds
grees	6	51	3247	2	grees
greys	9	66	1485	2	greys
grids	7	53	2139	2	grids
gude	6	54	2333	2	gude
gudes	7	45	2081	2	gudes
guess	6	42	1336	2	guess
guids	7	55	1615	2	guids
guls	5	59	3085	2	guls
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
heads	9	51	2711	2	heads
heeds	9	54	2042	2	heeds
hehs	10	67	2396	2	hehs
hems	9	55	3494	2	hems
hens	7	56	4257	2	hens
herds	9	64	2468	2	herds
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
hods	8	72	3986	2	hods
ides	5	77	3423	2	ides
ids	4	75	3546	2	_ids
jees	11	59	3854	2	jees
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
keas	8	63	3709	2	keas
kefs	11	59	2274	2	kefs
kegs	9	58	2401	2	kegs
kens	8	54	3523	2	kens
keps	10	60	2730	2	keps
keys	11	63	2216	2	keys
kids	9	60	2963	2	kids
lads	5	65	4913	2	lads
leads	6	60	2849	2	leads
leas	4	59	5418	2	leas
led	4	62	5455	2	led_
lees	4	54	5588	2	lees
legs	5	61	3369	2	legs
leis	4	57	3960	2	leis
leks	8	54	2760	2	leks
lends	6	53	2625	2	lends
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
leuds	6	62	1481	2	leuds
leys	7	64	3018	2	leys
lids	5	63	3645	2	lids
mads	7	68	4536	2	mads
meads	8	54	2532	2	meads
med	6	61	4674	2	med_
meeds	8	49	2027	2	meeds
megs	7	55	3063	2	megs
melds	8	48	2238	2	melds
mels	6	59	4153	2	mels
mems	8	59	3150	2	mems
mends	8	49	2769	2	mends
mess	6	59	3243	2	mess
mews	9	66	2933	2	mews
mids	7	65	4178	2	mids
mods	7	79	4505	2	mods
muds	7	55	3065	2	muds
nebs	6	61	2498	2	nebs
needs	6	57	1963	2	needs
negs	5	57	2736	2	negs
nerds	6	57	1925	2	nerds
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
news	7	61	2737	2	news
nods	5	58	3822	2	nods
odds	6	89	1992	2	odds
odes	5	72	4324	2	odes
ods	4	75	4621	2	_ods
oes	3	58	6619	2	oe_s
ogees	6	51	1914	2	ogees
olds	5	59	2657	2	olds
ouds	5	64	3010	2	ouds
pads	7	67	4295	2	pads
peas	6	57	5506	2	peas
pecs	8	46	3410	2	pecs
ped	6	67	5152	2	ped_
pedes	8	53	2728	2	pedes
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
pends	8	55	2719	2	pends
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
pods	7	65	4015	2	pods
puds	7	56	3051	2	puds
rads	5	60	4660	2	rads
reads	6	48	3527	2	reads
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
red	4	67	5580	2	red_
redd	6	63	2317	2	redd
redds	7	46	1783	2	redds
rede	5	50	3766	2	rede
redes	6	51	3912	2	redes
redo	5	60	2936	2	redo
redos	6	51	2676	2	redos
reeds	6	54	3090	2	reeds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
rends	6	51	2995	2	rends
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
rids	5	65	3954	2	rids
rods	5	64	4206	2	rods
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
seeds	6	43	3006	2	seeds
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sels	4	63	4598	2	sels
sends	6	55	2824	2	sends
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sews	7	58	3602	2	sews
sheds	9	61	2270	2	sheds
sleds	6	44	1885	2	sleds
sneds	6	57	1535	2	sneds
sods	5	49	4021	2	sods
suds	5	61	3529	2	suds
tads	5	71	4394	2	tads
teas	4	58	5149	2	teas
ted	4	64	4656	2	ted_
tees	4	53	5358	2	tees
tegs	5	60	3149	2	tegs
tels	4	68	4169	2	tels
tends	6	54	2558	2	tends
tens	4	56	4741	2	tens
tets	4	58	4745	2	tets
tews	7	64	3164	2	tews
tods	5	61	4184	2	tods
urds	5	59	2242	2	urds
vees	7	54	3943	2	vees
velds	9	56	1558	2	velds
vends	9	55	2089	2	vends
vets	7	68	3509	2	vets
vids	8	56	2753	2	vids
wads	8	73	4314	2	wads
webs	9	66	2212	2	webs
wed	7	58	4362	2	wed_
weeds	9	52	2221	2	weeds
wees	7	62	4912	2	wees
welds	9	47	1916	2	welds
wends	9	58	2281	2	wends
wens	7	63	3793	2	wens
wets	7	59	4029	2	wets
yeas	7	86	3842	2	yeas
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
yids	8	52	2495	2	yids
yods	8	65	3118	2	yods
zed	13	54	3117	2	zed_
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.063	2836365.1
2	DLD Change Limit	29872	366	0.906	32971.3
3	Display Results	366	366	0.076	4815.8
	(SQL Overall)	178691	366	1.045	170996.2