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

Here are the results of your fuzzy-string dictionary search for “dekko” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

405 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
dekko	9	3	639	(None)
dekkos	10	3	410	1	dekkos
deck	11	58	2775	2	deck_
decks	12	48	2219	2	decks
deco	7	61	2597	2	de_co
deke	9	52	2876	2	de_ke
deked	11	57	1853	2	deked
dekes	10	52	2445	2	dekes
demo	7	74	2755	2	de_mo
desk	9	56	1890	2	desk_
desks	10	59	1307	2	desks
gecko	12	45	1111	2	gecko
aero	4	54	3534	3	ae_ro
beak	10	65	3438	3	beak_
beaks	11	53	2662	3	beaks
beaky	14	61	1802	3	beaky
beano	7	54	2155	3	beano
beck	12	62	2657	3	beck_
beckon	14	30	938	3	beckon
becks	13	55	2201	3	becks
beknot	12	3	976	3	beknot
bento	7	59	2295	3	bento
berk	10	59	2984	3	berk_
berks	11	54	2312	3	berks
bucko	13	46	1402	3	bucko
bunko	11	55	1451	3	bunko
cello	7	49	1958	3	cello
cento	7	66	2517	3	cento
cero	6	63	2945	3	ce_ro
dado	6	71	2633	3	d_ado
dago	6	57	2508	3	d_ago
daikon	11	21	724	3	daikon
dak	8	63	4069	3	d_ak_
daks	9	71	3060	3	d_aks
danio	6	3	1978	3	danio
dank	9	58	2823	3	dank_
dark	9	51	3321	3	dark_
darks	10	67	2787	3	darks
darky	13	60	1883	3	darky
dato	5	61	2994	3	d_ato
datto	6	54	1642	3	datto
dawk	12	61	1728	3	dawk_
dawks	13	52	1349	3	dawks
de	3	70	4954	3	de___
deacon	9	5	1042	3	deacon
dead	6	54	3424	3	de_ad
deads	7	57	2691	3	deads
deaf	8	58	3840	3	de_af
deair	6	58	1719	3	deair
deal	5	63	4741	3	de_al
deals	6	54	3534	3	deals
dealt	6	52	3428	3	dealt
dean	5	60	3948	3	de_an
deans	6	61	3139	3	deans
dear	5	53	4360	3	de_ar
dears	6	57	3688	3	dears
deary	9	58	2684	3	deary
deash	9	56	1724	3	deash
death	9	48	2252	3	death
deave	9	50	2233	3	deave
deb	6	63	4269	3	de__b
debag	9	42	1230	3	debag
debar	8	55	1786	3	debar
debit	8	57	2785	3	debit
debs	7	65	3024	3	de_bs
debt	7	71	3902	3	de_bt
debtor	9	3	833	3	debtor
debts	8	64	1837	3	debts
debug	9	42	1006	3	debug
debut	8	60	2414	3	debut
debye	11	3	890	3	debye
decaf	11	49	1944	3	decaf
decal	8	55	2323	3	decal
decay	11	47	1848	3	decay
decked	14	52	1762	3	decked
deckel	13	49	1104	3	deckel
decker	13	52	1599	3	decker
deckle	13	120	1245	3	deckle
decor	8	47	1757	3	decor
decos	8	55	2212	3	decos
decoy	11	57	1631	3	decoy
decry	11	55	1435	3	decry
dedal	7	57	1902	3	dedal
dee	4	76	6582	3	de__e
deed	6	53	4090	3	de_ed
deeds	7	54	2376	3	deeds
deedy	10	43	1589	3	deedy
deem	7	54	3289	3	de_em
deems	8	54	2177	3	deems
deep	7	60	3188	3	de_ep
deeps	8	49	2177	3	deeps
deer	5	67	3902	3	de_er
deers	6	49	3052	3	deers
dees	5	63	5663	3	de_es
deet	5	73	5658	3	de_et
deets	6	53	3024	3	deets
def	7	65	4672	3	de__f
defat	9	54	2669	3	defat
defer	9	46	1975	3	defer
defi	8	63	2149	3	de_fi
defis	9	67	1750	3	defis
defog	10	4	852	3	defog
deft	8	55	4022	3	de_ft
defy	11	49	2126	3	de_fy
degas	7	51	1916	3	degas
degum	9	47	1190	3	degum
deice	8	43	2003	3	deice
deify	12	41	1276	3	deify
deign	7	43	1280	3	deign
deil	5	62	3162	3	de_il
deils	6	57	2286	3	deils
deism	8	41	1603	3	deism
deist	6	46	3359	3	deist
deity	9	43	1677	3	deity
dekare	11	28	1156	3	dekare
deking	12	56	1455	3	deking
del	4	67	5275	3	de__l
delay	9	48	2063	3	delay
dele	5	68	4308	3	de_le
deled	7	53	2654	3	deled
deles	6	51	3925	3	deles
delf	8	54	3657	3	de_lf
delfs	9	49	1867	3	delfs
delft	9	56	2332	3	delft
deli	5	56	3129	3	de_li
delis	6	49	2854	3	delis
dell	5	69	3820	3	de_ll
dells	6	66	3094	3	dells
delly	9	60	2387	3	delly
dels	5	67	4547	3	de_ls
delt	5	78	5527	3	de_lt
delta	6	61	1777	3	delta
delts	6	57	3179	3	delts
delve	9	60	1826	3	delve
deme	7	65	3628	3	de_me
demes	8	60	3269	3	demes
demic	10	51	1919	3	demic
demit	8	48	3230	3	demit
demob	10	49	1350	3	demob
demon	8	65	2031	3	demon
demos	8	60	2299	3	demos
demur	8	3	1116	3	demur
demy	10	54	2285	3	de_my
den	4	75	5434	3	de__n
denar	6	52	2329	3	denar
dene	5	66	4341	3	de_ne
denes	6	56	3972	3	denes
deni	5	69	2939	3	de_ni
denim	8	55	1884	3	denim
dens	5	59	4507	3	de_ns
dense	6	59	2350	3	dense
dent	5	71	5841	3	de_nt
dents	6	50	3180	3	dents
deny	8	60	2712	3	de_ny
deoxy	16	4	888	3	deoxy
deploy	12	3	758	3	deploy
depot	8	57	2792	3	depot
depth	11	43	1185	3	depth
derat	6	50	4408	3	derat
deray	9	50	2418	3	deray
derby	11	47	1534	3	derby
dere	5	68	4590	3	de_re
derm	7	60	3189	3	de_rm
derma	8	49	1851	3	derma
derms	8	50	2289	3	derms
derry	9	47	2137	3	derry
desex	13	3	1198	3	desex
desktop	14	4	241	3	desktop
despot	9	34	1329	3	despot
deter	6	50	2804	3	deter
detox	13	3	1095	3	detox
deuce	8	45	1749	3	deuce
dev	7	60	3377	3	de__v
deva	8	57	2098	3	de_va
devas	9	62	1888	3	devas
devel	9	42	1712	3	devel
devil	9	47	1473	3	devil
devon	9	51	1368	3	devon
devs	8	64	2403	3	de_vs
dew	7	71	3992	3	de__w
dewan	9	57	1804	3	dewan
dewar	9	58	1773	3	dewar
dewax	16	55	1085	3	dewax
dewed	10	50	2030	3	dewed
dewool	10	4	740	3	dewool
dews	8	62	3060	3	de_ws
dewy	11	54	1902	3	de_wy
dex	11	69	3688	3	de__x
dexes	13	52	2451	3	dexes
dexie	13	47	1689	3	dexie
dextro	14	3	612	3	dextro
dexy	15	61	1855	3	de_xy
dey	7	72	4337	3	de__y
deys	8	50	2747	3	de_ys
dhak	12	55	1203	3	dhak_
dhaks	13	47	970	3	dhaks
diazo	15	3	1003	3	diazo
dick	11	64	3238	3	dick_
dicks	12	58	2469	3	dicks
dicky	15	48	1624	3	dicky
dido	6	65	2819	3	d_ido
dike	9	59	3576	3	d_ike
diked	11	50	2468	3	diked
diker	10	55	2455	3	diker
dikes	10	58	3133	3	dikes
dikey	13	51	1642	3	dikey
dildo	7	19	1177	3	dildo
dingo	7	47	2079	3	dingo
dink	9	71	3780	3	dink_
dinks	10	59	2795	3	dinks
dinky	13	58	1937	3	dinky
dino	5	60	3675	3	d_ino
dipso	8	51	1155	3	dipso
dirk	9	63	2683	3	dirk_
dirks	10	56	1952	3	dirks
disco	8	56	1607	3	disco
disk	9	66	2583	3	disk_
disks	10	54	1747	3	disks
ditto	6	53	1560	3	ditto
do	3	101	5525	3	d___o
dobro	8	44	1221	3	dobro
dock	11	62	2874	3	dock_
docks	12	60	2231	3	docks
dodo	6	60	2491	3	d_odo
doggo	8	44	1070	3	doggo
dojo	12	60	1614	3	d_ojo
dork	9	65	3146	3	dork_
dorks	10	57	2444	3	dorks
dorky	13	55	1874	3	dorky
drake	10	49	1830	3	drake
dreck	12	48	1280	3	dreck_
drecks	13	45	920	3	drecks
drecky	16	48	633	3	drecky
drek	9	63	2108	3	drek_
dreks	10	57	1474	3	dreks
duck	11	59	2917	3	duck_
ducks	12	48	2321	3	ducks
ducky	15	42	1611	3	ducky
duello	7	5	678	3	duello
duke	9	56	2810	3	d_uke
duked	11	52	1846	3	duked
dukes	10	50	2347	3	dukes
dumbo	10	56	1406	3	dumbo
dumka	12	43	883	3	dumka
dumky	15	45	1134	3	dumky
dunk	9	62	2857	3	dunk_
dunks	10	56	2119	3	dunks
duo	4	85	3614	3	d__uo
duomo	8	3	975	3	duomo
duro	5	62	2802	3	d_uro
dusk	9	57	2415	3	dusk_
dusks	10	53	1725	3	dusks
dusky	13	52	1304	3	dusky
dyke	12	64	1818	3	d_yke
dyked	14	53	1095	3	dyked
dykes	13	52	1557	3	dykes
dykey	16	60	867	3	dykey
echo	9	66	1595	3	_echo
eddo	6	34	1180	3	_eddo
eek	7	79	3510	3	_eek_
ego	4	67	2605	3	_e_go
eikon	9	3	946	3	_eikon
eke	7	56	3009	3	_e_ke
eked	9	67	1802	3	_eked
ekes	8	67	2660	3	_ekes
elk	7	67	2612	3	_elk_
elks	8	58	2003	3	_elks
ergo	5	64	2015	3	_ergo
euro	4	53	2527	3	_euro
expo	13	4	918	3	_expo
feck	13	49	2343	3	feck_
fecks	14	54	1785	3	fecks
geck	11	57	2199	3	geck_
geckos	13	45	743	3	geckos
gecks	12	51	1709	3	gecks
geek	9	53	2702	3	geek_
geeks	10	49	1584	3	geeks
geeky	13	47	1073	3	geeky
genro	6	49	1403	3	genro
gesso	6	4	960	3	gesso
heck	13	58	2649	3	heck_
hecks	14	52	2065	3	hecks
helio	8	53	2119	3	helio
hello	8	65	2298	3	hello
helo	7	53	3285	3	he_lo
hero	7	46	3578	3	he_ro
hokku	11	3	548	3	hokku
iroko	9	3	966	3	iroko
jello	12	67	1627	3	jello
jerk	15	49	2013	3	jerk_
jerks	16	65	1489	3	jerks
jerky	19	67	1242	3	jerky
jocko	18	42	1045	3	jocko
keck	9	49	2071	3	keck_
kecks	10	54	1657	3	kecks
keek	7	56	2496	3	keek_
keeks	8	47	1725	3	keeks
kendo	10	51	1322	3	kendo
keno	8	79	2643	3	ke_no
keto	8	62	2345	3	ke_to
leak	8	62	3371	3	leak_
leaks	9	59	2391	3	leaks
leaky	12	52	1772	3	leaky
leek	8	53	3173	3	leek_
leeks	9	53	1889	3	leeks
lek	7	56	4030	3	le_k_
leke	8	55	2740	3	le_ke
lekked	10	39	563	3	lekked
leks	8	54	2760	3	le_ks
leku	8	65	1991	3	le_ku
leno	4	73	3139	3	le_no
lento	5	72	2339	3	lento
lesbo	7	3	925	3	lesbo
leukon	10	3	614	3	leukon
levo	7	68	2006	3	le_vo
mako	10	56	2235	3	_mako
meek	10	56	2483	3	meek_
memo	8	59	2479	3	me_mo
meno	6	60	3135	3	me_no
merk	10	60	2794	3	merk_
merks	11	47	2240	3	merks
metro	7	47	1880	3	metro
mezzo	15	3	743	3	mezzo
neck	10	54	2366	3	neck_
necks	11	51	1933	3	necks
nekton	10	3	658	3	nekton
neuk	8	74	1660	3	neuk_
neuks	9	65	1086	3	neuks
peak	10	65	3520	3	peak_
peaks	11	48	2562	3	peaks
peaky	14	57	1815	3	peaky
peck	12	57	3068	3	peck_
pecks	13	57	2443	3	pecks
pecky	16	55	1509	3	pecky
pedro	8	3	1315	3	pedro
peek	10	60	3143	3	peek_
peeks	11	50	2111	3	peeks
pekan	11	16	1397	3	pekan
peke	10	59	2620	3	pe_ke
pekes	11	46	2356	3	pekes
pekin	11	15	1442	3	pekin
pekoe	11	46	1236	3	pekoe
pengo	8	43	1759	3	pengo
pepo	8	76	2215	3	pe_po
perk	10	62	3284	3	perk_
perks	11	53	2580	3	perks
perky	14	53	1948	3	perky
pesky	14	59	1156	3	pesky
peso	6	69	2582	3	pe_so
pesto	7	57	2372	3	pesto
petto	7	60	2104	3	petto
pinko	11	56	1825	3	pinko
pukka	10	45	713	3	pukka
reck	10	61	3056	3	reck_
reckon	12	30	1054	3	reckon
recks	11	56	2513	3	recks
recto	7	45	2080	3	recto
redo	5	60	2936	3	re_do
reek	8	52	3252	3	reek_
reeks	9	41	2403	3	reeks
reeky	12	54	1626	3	reeky
rekey	12	40	1473	3	rekey
reknot	10	3	1173	3	reknot
repo	6	60	2754	3	re_po
repro	7	53	1591	3	repro
retro	5	50	2095	3	retro
secco	9	3	1242	3	secco
seek	8	59	3548	3	seek_
seeks	9	47	2464	3	seeks
segno	6	48	1474	3	segno
sego	5	65	2518	3	se_go
servo	8	45	1668	3	servo
sexto	12	44	1545	3	sexto
shako	12	55	1608	3	shako
sicko	11	53	1539	3	sicko
socko	11	52	1511	3	socko
sukkot	9	3	663	3	sukkot
teak	8	59	3084	3	teak_
teaks	9	42	2290	3	teaks
tekkie	9	3	420	3	tekkie
telco	7	5	1187	3	telco
tempo	9	52	1497	3	tempo
tikka	8	3	557	3	tikka
verso	8	53	1463	3	verso
veto	7	66	2299	3	ve_to
wacko	14	55	1438	3	wacko
weak	11	71	2630	3	weak_
weakon	13	35	762	3	weakon
week	11	64	2815	3	week_
weeks	12	50	1786	3	weeks
weka	11	70	1387	3	we_ka
wekas	12	39	1179	3	wekas
yelk	11	53	2000	3	yelk_
yelks	12	64	1362	3	yelks
yerk	11	62	2208	3	yerk_
yerks	12	54	1656	3	yerks
yeuk	11	60	1547	3	yeuk_
yeuks	12	51	1009	3	yeuks
yeuky	15	54	703	3	yeuky
yukky	14	42	521	3	yukky
zek	16	73	2316	3	ze_k_
zeks	17	58	1506	3	ze_ks
zerk	17	53	1925	3	zerk_
zerks	18	51	1382	3	zerks
zero	13	48	2246	3	ze_ro

Search took 6 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	83667	0.110	1624463.6
2	DLD Change Limit	83667	405	5.326	15709.2
3	Display Results	405	405	0.110	3681.8
	(SQL Overall)	178691	405	5.546	32219.8