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

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

494 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
gecko	12	45	1111	(None)
geck	11	57	2199	1	geck_
geckos	13	45	743	1	geckos
gecks	12	51	1709	1	gecks
beck	12	62	2657	2	beck_
beckon	14	30	938	2	beckon
becks	13	55	2201	2	becks
bucko	13	46	1402	2	bucko
deck	11	58	2775	2	deck_
decks	12	48	2219	2	decks
deco	7	61	2597	2	dec_o
dekko	9	3	639	2	dekko
echo	9	66	1595	2	_echo
feck	13	49	2343	2	feck_
fecks	14	54	1785	2	fecks
gecked	14	69	1193	2	gecked
geckoes	14	32	579	2	geckoes
geek	9	53	2702	2	geek_
geeks	10	49	1584	2	geeks
geeky	13	47	1073	2	geeky
genro	6	49	1403	2	genro
gesso	6	4	960	2	gesso
guck	11	49	2253	2	guck_
gucks	12	39	1730	2	gucks
heck	13	58	2649	2	heck_
hecks	14	52	2065	2	hecks
jocko	18	42	1045	2	jocko
keck	9	49	2071	2	keck_
kecks	10	54	1657	2	kecks
neck	10	54	2366	2	neck_
necks	11	51	1933	2	necks
peck	12	57	3068	2	peck_
pecks	13	57	2443	2	pecks
pecky	16	55	1509	2	pecky
reck	10	61	3056	2	reck_
reckon	12	30	1054	2	reckon
recks	11	56	2513	2	recks
recto	7	45	2080	2	recto
secco	9	3	1242	2	secco
sicko	11	53	1539	2	sicko
socko	11	52	1511	2	socko
wacko	14	55	1438	2	wacko
aecia	7	38	1928	3	aecia
aero	4	54	3534	3	ae_ro
ancho	10	45	1530	3	ancho
arco	6	83	3154	3	arc_o
back	12	55	3576	3	back_
backs	13	57	2962	3	backs
beak	10	65	3438	3	beak_
beaks	11	53	2662	3	beaks
beaky	14	61	1802	3	beaky
beano	7	54	2155	3	beano
becap	11	43	1505	3	becap
becked	15	54	1776	3	becked
becket	14	46	1988	3	becket
beckons	15	27	914	3	beckons
beclog	11	3	686	3	beclog
bento	7	59	2295	3	bento
berk	10	59	2984	3	berk_
berks	11	54	2312	3	berks
bock	12	60	3251	3	bock_
bocks	13	45	2657	3	bocks
buck	12	51	2990	3	buck_
buckos	14	37	1089	3	buckos
bucks	13	48	2429	3	bucks
bunko	11	55	1451	3	bunko
cacao	9	54	2000	3	cacao
ceca	8	48	2078	3	cec_a
cecal	9	46	1911	3	cecal
cecum	11	6	1184	3	cecum
cello	7	49	1958	3	cello
cento	7	66	2517	3	cento
cero	6	63	2945	3	ce_ro
check	16	47	1471	3	check_
checks	17	49	1270	3	checks
cock	12	63	3290	3	cock_
cocks	13	52	2716	3	cocks
cocky	16	42	1593	3	cocky
coco	8	73	3060	3	coc_o
coo	5	95	6636	3	__coo
cuckoo	14	8	641	3	cuckoo
cyclo	12	3	770	3	cyclo
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
deke	9	52	2876	3	de_ke
dekkos	10	3	410	3	dekkos
demo	7	74	2755	3	de_mo
desk	9	56	1890	3	desk_
desks	10	59	1307	3	desks
dick	11	64	3238	3	dick_
dicks	12	58	2469	3	dicks
dicky	15	48	1624	3	dicky
dock	11	62	2874	3	dock_
docks	12	60	2231	3	docks
dreck	12	48	1280	3	dreck_
drecks	13	45	920	3	drecks
drecky	16	48	633	3	drecky
duck	11	59	2917	3	duck_
ducks	12	48	2321	3	ducks
ducky	15	42	1611	3	ducky
eche	9	75	2028	3	_eche
echos	10	52	1646	3	_echos
echt	9	57	2290	3	_echt
ecru	6	58	1953	3	_ecru
ecu	5	68	2823	3	_ec_u
ecus	6	54	2146	3	_ecus
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
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
fecal	10	51	1921	3	fecal
feces	10	56	2536	3	feces
feckly	18	33	596	3	feckly
fico	9	58	2459	3	fic_o
fleck	14	82	1359	3	fleck_
flecks	15	43	1080	3	flecks
flecky	18	38	765	3	flecky
fuck	13	49	2463	3	fuck_
fucks	14	44	1925	3	fucks
gadjo	14	3	691	3	gadjo
gaucho	12	5	622	3	gaucho
gawk	12	67	1669	3	gawk_
gawks	13	68	1163	3	gawks
gawky	16	56	999	3	gawky
gazoo	15	31	1287	3	gazoo
gear	5	59	3497	3	ge_ar
gears	6	46	2869	3	gears
gecking	15	41	1136	3	gecking
ged	5	70	4453	3	ge__d
geds	6	67	3081	3	ge_ds
gee	4	53	5920	3	ge__e
geed	6	54	3550	3	ge_ed
geekdom	15	4	228	3	geekdom
geeked	12	45	1016	3	geeked
gees	5	56	4788	3	ge_es
geese	6	43	1600	3	geese
geest	6	48	2962	3	geest
geez	14	64	2486	3	ge_ez
gel	4	56	4243	3	ge__l
gelato	7	38	1296	3	gelato
gelcap	11	3	621	3	gelcap
geld	6	58	2843	3	ge_ld
gelds	7	51	1834	3	gelds
gelee	6	36	2698	3	gelee
gelid	7	49	1698	3	gelid
gels	5	68	3610	3	ge_ls
gelt	5	64	4801	3	ge_lt
gelts	6	59	2461	3	gelts
gem	6	68	4022	3	ge__m
gemma	10	63	1177	3	gemma
gemmy	13	52	1105	3	gemmy
gemot	8	40	2423	3	gemot
gems	7	53	2911	3	ge_ms
gen	4	59	5051	3	ge__n
gene	5	62	3722	3	ge_ne
genes	6	51	3309	3	genes
genet	6	60	3868	3	genet
genic	8	51	1939	3	genic
genie	6	61	2492	3	genie
genii	6	45	1417	3	genii
genip	8	44	1520	3	genip
genoa	6	43	1582	3	genoa
genom	8	37	1684	3	genom
genre	6	60	1680	3	genre
genros	7	42	1133	3	genros
gens	5	57	4007	3	ge_ns
gent	5	69	5439	3	ge_nt
gentoo	7	3	1131	3	gentoo
gents	6	57	2961	3	gents
genu	5	59	2907	3	ge_nu
genua	6	46	1415	3	genua
genus	6	53	1983	3	genus
geode	7	4	1259	3	geode
geoid	7	42	1576	3	geoid
gerah	9	3	1530	3	gerah
germ	7	54	2896	3	ge_rm
germs	8	51	1887	3	germs
germy	11	51	1366	3	germy
gest	5	61	4913	3	ge_st
geste	6	59	2069	3	geste
gests	6	60	2881	3	gests
get	4	74	6746	3	ge__t
geta	5	66	2744	3	ge_ta
getas	6	54	2148	3	getas
gets	5	54	4248	3	ge_ts
getup	8	34	1026	3	getup
geum	7	54	2455	3	ge_um
geums	8	54	1411	3	geums
gey	7	57	3830	3	ge__y
gherao	10	3	675	3	gherao
ghetto	10	3	607	3	ghetto
gingko	12	37	603	3	gingko
gink	9	71	2952	3	gink_
ginkgo	12	33	494	3	ginkgo
ginks	10	43	1956	3	ginks
ginzo	15	3	961	3	ginzo
giro	5	58	2863	3	g_iro
gismo	8	4	886	3	gismo
gizmo	17	5	601	3	gizmo
gleek	10	53	1510	3	gleek_
gleeks	11	48	967	3	gleeks
go	3	87	4874	3	g___o
gobo	7	61	2690	3	g_obo
gogo	6	97	2283	3	g_ogo
gombo	10	58	1404	3	gombo
gonzo	15	3	1024	3	gonzo
goo	4	77	5477	3	g__oo
gook	9	64	2960	3	gook_
gooks	10	54	2288	3	gooks
gooky	13	58	1803	3	gooky
gowk	12	55	1647	3	gowk_
gowks	13	60	1195	3	gowks
greek	10	59	1594	3	greek_
grego	7	3	1052	3	grego
grok	9	58	1968	3	grok_
groks	10	57	1612	3	groks
guaco	8	50	1216	3	guaco
guano	6	92	1398	3	guano
guiro	6	37	1209	3	guiro
gumbo	10	44	1358	3	gumbo
gunk	9	54	2357	3	gunk_
gunks	10	45	1772	3	gunks
gunky	13	55	1411	3	gunky
gusto	6	54	1464	3	gusto
gyro	8	52	1788	3	g_yro
hack	13	51	3454	3	hack_
hacks	14	49	2871	3	hacks
heckle	15	31	1209	3	heckle
hector	11	33	1265	3	hector
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
hick	13	55	3030	3	hick_
hicks	14	53	2217	3	hicks
hock	13	60	3130	3	hock_
hocks	14	49	2549	3	hocks
huck	13	59	2763	3	huck_
hucks	14	43	2217	3	hucks
ick	9	73	2932	3	_ick_
icky	13	63	1575	3	_icky
iroko	9	3	966	3	iroko
jack	17	52	2486	3	jack_
jacks	18	52	1983	3	jacks
jacky	21	54	1234	3	jacky
jello	12	67	1627	3	jello
jerk	15	49	2013	3	jerk_
jerks	16	65	1489	3	jerks
jerky	19	67	1242	3	jerky
jock	17	65	2264	3	jock_
jockos	19	52	756	3	jockos
jocks	18	51	1808	3	jocks
juco	13	47	1620	3	juc_o
kecked	12	51	1317	3	kecked
keckle	11	35	942	3	keckle
keek	7	56	2497	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
kick	9	60	2607	3	kick_
kicks	10	44	2008	3	kicks
kicky	13	50	1233	3	kicky
lack	10	58	3768	3	lack_
lacks	11	61	2920	3	lacks
leak	8	62	3371	3	leak_
leaks	9	59	2391	3	leaks
leaky	12	52	1772	3	leaky
lech	9	68	2544	3	lec_h
lector	8	35	1499	3	lector
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
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
lick	10	69	3507	3	lick_
licks	11	53	2539	3	licks
lock	10	61	3436	3	lock_
locks	11	51	2692	3	locks
loco	6	70	3074	3	loc_o
luck	10	53	2982	3	luck_
lucks	11	57	2356	3	lucks
lucky	14	55	1501	3	lucky
macho	12	61	2015	3	macho
mack	12	57	3365	3	mack_
macks	13	51	2760	3	macks
macro	9	47	1817	3	macro
mako	10	56	2236	3	_mako
mecca	11	3	993	3	mecca
meek	10	56	2483	3	meek_
memo	8	59	2479	3	me_mo
meno	6	60	3136	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
mick	12	63	3343	3	mick_
micks	13	55	2537	3	micks
micro	9	47	1599	3	micro
mock	12	64	2944	3	mock_
mocks	13	50	2382	3	mocks
mucho	12	50	1344	3	mucho
muck	12	57	2785	3	muck_
mucks	13	46	2264	3	mucks
mucky	16	50	1525	3	mucky
mucro	9	45	1372	3	mucro
nacho	10	54	1438	3	nacho
necked	13	47	1506	3	necked
necker	12	40	1279	3	necker
neuk	8	74	1660	3	neuk_
neuks	9	65	1086	3	neuks
nick	10	66	2760	3	nick_
nicks	11	49	2049	3	nicks
nock	10	61	2718	3	nock_
nocks	11	51	2101	3	nocks
pack	12	55	3544	3	pack_
packs	13	55	2893	3	packs
peak	10	65	3520	3	peak_
peaks	11	48	2562	3	peaks
peaky	14	57	1815	3	peaky
pec	7	67	4441	3	pec__
pecan	9	19	1903	3	pecan
pech	11	61	2545	3	pec_h
pechs	12	55	1620	3	pechs
pecked	15	50	1910	3	pecked
pecker	14	46	1536	3	pecker
pecs	8	46	3410	3	pec_s
pedro	8	3	1315	3	pedro
peek	10	60	3143	3	peek_
peeks	11	50	2111	3	peeks
peke	10	59	2620	3	pe_ke
pekoe	11	46	1236	3	pe_koe
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
pick	12	59	3381	3	pick_
picks	13	52	2614	3	picks
picky	16	54	1694	3	picky
pinko	11	56	1825	3	pinko
pock	12	61	2929	3	pock_
pocks	13	50	2296	3	pocks
pocky	16	53	1460	3	pocky
poco	8	68	2615	3	poc_o
puck	12	49	2794	3	puck_
pucka	13	34	1280	3	pucka
pucks	13	43	2210	3	pucks
rack	10	62	3488	3	rack_
racks	11	50	2885	3	racks
rec	5	56	4546	3	rec__
recap	9	57	1802	3	recap
recce	9	5	1456	3	recce
recit	7	52	3510	3	recit
recked	13	48	2180	3	recked
reckons	13	26	965	3	reckons
recon	7	56	2424	3	recon
recook	12	55	1392	3	recook
recs	6	57	3418	3	rec_s
recta	7	42	2026	3	recta
recti	7	36	1962	3	recti
rector	8	40	1975	3	rector
rectos	8	57	1878	3	rectos
recur	7	41	1684	3	recur
recut	7	47	2924	3	recut
redo	5	60	2936	3	re_do
reecho	11	31	865	3	reecho
reek	8	52	3252	3	reek_
reeks	9	41	2403	3	reeks
reeky	12	54	1626	3	reeky
repo	6	60	2754	3	re_po
repro	7	53	1591	3	repro
retro	5	50	2095	3	retro
rick	10	73	3465	3	rick_
ricks	11	51	2613	3	ricks
rock	10	57	3518	3	rock_
rocks	11	46	2641	3	rocks
rocky	14	45	1385	3	rocky
ruck	10	47	2833	3	ruck_
rucks	11	44	2205	3	rucks
sack	10	53	3731	3	sack_
sacks	11	42	2887	3	sacks
sec	5	59	4532	3	sec__
seccos	10	3	992	3	seccos
secs	6	50	3389	3	sec_s
sect	6	74	4362	3	sec_t
sector	8	34	1593	3	sector
sects	7	56	2289	3	sects
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
shacko	15	38	1011	3	shacko
shako	12	55	1609	3	shako
sick	10	64	3557	3	sick_
sickos	12	51	1203	3	sickos
sicks	11	51	2762	3	sicks
sneck	11	47	1366	3	sneck_
snecks	12	44	1003	3	snecks
sock	10	52	3321	3	sock_
socks	11	49	2608	3	socks
speck	13	51	1565	3	speck_
specks	14	43	1270	3	specks
suck	10	61	3173	3	suck_
sucks	11	45	2307	3	sucks
sucky	14	44	1550	3	sucky
tack	10	65	3629	3	tack_
tacks	11	54	3013	3	tacks
tacky	14	56	1744	3	tacky
taco	6	70	3135	3	tac_o
teak	8	59	3084	3	teak_
teaks	9	42	2290	3	teaks
tech	9	59	2544	3	tec_h
techno	11	3	595	3	techno
techs	10	69	1583	3	techs
techy	13	56	1201	3	techy
tecta	7	42	1552	3	tecta
telco	7	5	1187	3	telco
tempo	9	52	1497	3	tempo
tick	10	62	3122	3	tick_
ticks	11	58	2329	3	ticks
tuck	10	46	2657	3	tuck_
tucks	11	47	2112	3	tucks
unco	6	60	2140	3	unc_o
vector	11	32	1206	3	vector
velcro	11	4	413	3	velcro
verso	8	53	1463	3	verso
veto	7	66	2299	3	ve_to
wack	13	53	3091	3	wack_
wacke	14	59	1862	3	wacke
wackos	15	52	1099	3	wackos
wacks	14	66	2628	3	wacks
wacky	17	47	1493	3	wacky
weak	11	71	2630	3	weak_
weakon	13	35	762	3	weakon
wecht	13	4	1544	3	wecht
week	11	64	2815	3	week_
weeks	12	50	1786	3	weeks
weka	11	70	1387	3	we_ka
whacko	18	47	703	3	whacko
wick	13	57	2630	3	wick_
wicks	14	46	1936	3	wicks
wreck	14	46	1104	3	wreck_
wrecks	15	41	888	3	wrecks
yack	13	54	2597	3	yack_
yacks	14	44	1981	3	yacks
yecch	15	55	809	3	yecch
yech	12	72	2053	3	yec_h
yechs	13	61	1258	3	yechs
yechy	16	51	908	3	yechy
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
yock	13	59	2461	3	yock_
yocks	14	44	1837	3	yocks
yuck	13	64	2353	3	yuck_
yucks	14	47	1719	3	yucks
yucky	17	54	1169	3	yucky
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	2247	3	ze_ro

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	83667	0.326	548131.9
2	DLD Change Limit	83667	494	4.033	20745.6
3	Display Results	494	494	0.123	4016.3
	(SQL Overall)	178691	494	4.482	39868.6