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

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

361 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
geckos	13	45	743	(None)
gecko	12	45	1111	1	gecko_
geckoes	14	32	579	1	geckoes
gecks	12	51	1709	1	geck_s
beckon	14	30	938	2	beckon
beckons	15	27	914	2	beckons
becks	13	55	2201	2	beck_s
buckos	14	37	1089	2	buckos
decks	12	48	2219	2	deck_s
decos	8	55	2212	2	dec_os
dekkos	10	3	410	2	dekkos
echos	10	52	1646	2	_echos
fecks	14	54	1785	2	feck_s
geck	11	57	2199	2	geck__
gecked	14	69	1193	2	gecked
geeks	10	49	1584	2	geek_s
genros	7	42	1133	2	genros
gucks	12	39	1730	2	guck_s
hecks	14	52	2065	2	heck_s
jockos	19	52	756	2	jockos
kecks	10	54	1657	2	keck_s
necks	11	51	1933	2	neck_s
pecks	13	57	2443	2	peck_s
reckon	12	30	1054	2	reckon
reckons	13	26	965	2	reckons
recks	11	56	2513	2	reck_s
rectos	8	57	1878	2	rectos
seccos	10	3	992	2	seccos
sickos	12	51	1203	2	sickos
wackos	15	52	1099	2	wackos
anchos	11	42	1489	3	anchos
askos	9	50	1177	3	_askos
backs	13	57	2962	3	back_s
beaks	11	53	2662	3	beak_s
beanos	8	55	1651	3	beanos
becaps	12	38	1140	3	becaps
beck	12	62	2657	3	beck__
becked	15	54	1776	3	becked
becket	14	46	1988	3	becket
beckets	15	39	982	3	beckets
beclog	11	3	686	3	beclog
beclogs	12	3	707	3	beclogs
bentos	8	62	1830	3	bentos
berks	11	54	2312	3	berk_s
bocks	13	45	2657	3	bock_s
bucko	13	46	1402	3	bucko_
buckoes	15	38	1039	3	buckoes
bucks	13	48	2429	3	buck_s
bunkos	12	42	1032	3	bunkos
cacaos	10	46	1618	3	cacaos
cellos	8	45	1780	3	cellos
centos	8	59	2046	3	centos
ceros	7	47	2607	3	ce_ros
cestos	8	47	1809	3	cestos
checks	17	49	1270	3	check_s
cocks	13	52	2716	3	cock_s
cocos	9	56	2469	3	coc_os
coos	6	74	5649	3	__coos
cos	5	102	7039	3	__c_os
cuckoo	14	8	641	3	cuckoo
cuckoos	15	8	512	3	cuckoos
cyclos	13	3	807	3	cyclos
decafs	12	40	1088	3	decafs
decals	9	37	1771	3	decals
decays	12	46	1291	3	decays
deck	11	58	2775	3	deck__
decked	14	52	1762	3	decked
deckel	13	49	1104	3	deckel
deckels	14	36	736	3	deckels
decker	13	52	1599	3	decker
deckers	14	44	1383	3	deckers
deckle	13	120	1245	3	deckle
deckles	14	33	1280	3	deckles
deco	7	61	2597	3	dec_o_
decor	8	47	1757	3	dec_or
decors	9	40	1777	3	decors
decoy	11	57	1631	3	dec_oy
decoys	12	39	1128	3	decoys
dekes	10	52	2445	3	de_kes
dekko	9	3	639	3	dekko_
demos	8	60	2299	3	de_mos
desks	10	59	1307	3	desk_s
dicks	12	58	2469	3	dick_s
docks	12	60	2231	3	dock_s
drecks	13	45	920	3	dreck_s
ducks	12	48	2321	3	duck_s
eches	10	63	2216	3	_eches
echo	9	66	1595	3	_echo_
echoes	11	47	1552	3	_echoes
ecrus	7	51	1386	3	_ecrus
ecus	6	54	2146	3	_ec_us
egos	5	58	2165	3	_e_gos
eidos	6	58	1775	3	_eidos
eikon	9	3	946	3	_eikon
eikons	10	3	850	3	_eikons
ekes	8	67	2660	3	_e_kes
elks	8	58	2003	3	_elk_s
epos	6	67	2373	3	_e_pos
eros	4	52	3845	3	_e_ros
ethos	8	55	1419	3	_ethos
euros	5	49	2024	3	_euros
expos	14	4	920	3	_expos
feces	10	56	2536	3	fec_es
feck	13	49	2343	3	feck__
feckly	18	33	596	3	feckly
flecks	15	43	1080	3	fleck_s
fucks	14	44	1925	3	fuck_s
gauchos	13	4	590	3	gauchos
gawks	13	68	1163	3	gawk_s
gazoos	16	30	1022	3	gazoos
gears	6	46	2869	3	ge_ars
gecking	15	41	1136	3	gecking
geds	6	67	3081	3	ge__ds
geek	9	53	2702	3	geek__
geekdom	15	4	228	3	geekdom
geekdoms	16	4	217	3	geekdoms
geeked	12	45	1016	3	geeked
geeky	13	47	1073	3	geek_y
gees	5	56	4788	3	ge__es
geests	7	59	1216	3	geests
gelatos	8	31	1151	3	gelatos
gelcaps	12	3	520	3	gelcaps
gelds	7	51	1834	3	ge_lds
gelees	7	41	1626	3	gelees
gels	5	68	3610	3	ge__ls
gelts	6	59	2461	3	ge_lts
gemot	8	40	2423	3	ge_mot
gemots	9	37	1215	3	gemots
gems	7	53	2911	3	ge__ms
genes	6	51	3309	3	ge_nes
genets	7	57	1666	3	genets
genies	7	53	2494	3	genies
genips	9	46	994	3	genips
genius	7	45	1292	3	genius
genoa	6	43	1582	3	ge_noa
genoas	7	40	1362	3	genoas
genom	8	37	1684	3	ge_nom
genoms	9	44	1248	3	genoms
genres	7	55	1562	3	genres
genro	6	49	1403	3	genro_
gens	5	57	4007	3	ge__ns
gentes	7	53	2416	3	gentes
gentoo	7	3	1131	3	gentoo
gentoos	8	3	863	3	gentoos
gents	6	57	2961	3	ge_nts
genus	6	53	1983	3	ge_nus
geodes	8	4	1215	3	geodes
geoids	8	36	984	3	geoids
gerahs	10	3	941	3	gerahs
germs	8	51	1887	3	ge_rms
gesso	6	4	960	3	gesso_
gessoes	8	3	829	3	gessoes
gestes	7	57	2139	3	gestes
gests	6	60	2881	3	ge_sts
getas	6	54	2148	3	ge_tas
gets	5	54	4248	3	ge__ts
getups	9	34	685	3	getups
geums	8	54	1411	3	ge_ums
ghettos	11	3	447	3	ghettos
gingkos	13	40	534	3	gingkos
ginkgos	13	31	418	3	ginkgos
ginks	10	43	1956	3	gink_s
giros	6	57	2265	3	g_iros
gismos	9	5	718	3	gismos
gizmos	18	4	413	3	gizmos
gleeks	11	48	967	3	gleek_s
gobos	8	62	1938	3	g_obos
gogos	7	75	1652	3	g_ogos
gombos	11	43	1109	3	gombos
gooks	10	54	2288	3	gook_s
goos	5	76	4491	3	g__oos
gos	4	71	5513	3	g___os
gowks	13	60	1195	3	gowk_s
gregos	8	4	753	3	gregos
groks	10	57	1612	3	grok_s
guacos	9	44	1031	3	guacos
guanos	7	38	1199	3	guanos
guck	11	49	2253	3	guck__
guiros	7	38	909	3	guiros
gumbos	11	46	1087	3	gumbos
gunks	10	45	1772	3	gunk_s
gyros	9	56	1648	3	g_yros
hacks	14	49	2871	3	hack_s
heck	13	58	2649	3	heck__
heckle	15	31	1209	3	heckle
heckles	16	37	1138	3	heckles
hector	11	33	1265	3	hector
hectors	12	35	1326	3	hectors
helios	9	48	1663	3	helios
hellos	9	53	2168	3	hellos
helos	8	49	2806	3	he_los
heros	8	49	3086	3	he_ros
hicks	14	53	2217	3	hick_s
hocks	14	49	2549	3	hock_s
hucks	14	43	2217	3	huck_s
irokos	10	3	723	3	irokos
jacks	18	52	1983	3	jack_s
jellos	13	47	1428	3	jellos
jerks	16	65	1489	3	jerk_s
jocko	18	42	1045	3	jocko_
jocks	18	51	1808	3	jock_s
jucos	14	41	1171	3	juc_os
keck	9	49	2071	3	keck__
kecked	12	51	1317	3	kecked
keckle	11	35	942	3	keckle
keckles	12	31	876	3	keckles
keeks	8	47	1725	3	keek_s
kendos	11	45	1066	3	kendos
kenos	9	52	2062	3	ke_nos
kicks	10	44	2008	3	kick_s
kos	7	69	4482	3	___kos
lacks	11	61	2920	3	lack_s
leaks	9	59	2391	3	leak_s
leches	11	54	2131	3	leches
lector	8	35	1498	3	lector
lectors	9	34	1576	3	lectors
leeks	9	53	1889	3	leek_s
leks	8	54	2760	3	le_k_s
lenos	5	60	2486	3	le_nos
lentos	6	53	1740	3	lentos
lesbos	8	3	740	3	lesbos
leukon	10	3	614	3	leukon
leukons	11	3	575	3	leukons
licks	11	53	2539	3	lick_s
locks	11	51	2692	3	lock_s
locos	7	58	2260	3	loc_os
lucks	11	57	2356	3	luck_s
machos	13	52	1749	3	machos
macks	13	51	2760	3	mack_s
macros	10	40	1701	3	macros
makos	11	65	1836	3	_makos
meccas	12	3	949	3	meccas
memos	9	57	1911	3	me_mos
merks	11	47	2240	3	merk_s
metros	8	42	1780	3	metros
mezzos	16	3	505	3	mezzos
micks	13	55	2537	3	mick_s
micros	10	41	1536	3	micros
mocks	13	50	2382	3	mock_s
mucks	13	46	2264	3	muck_s
nachos	11	50	1418	3	nachos
neck	10	54	2366	3	neck__
necked	13	47	1506	3	necked
necker	12	40	1279	3	necker
neckers	13	42	1046	3	neckers
necrose	9	3	972	3	necrose
neuks	9	65	1086	3	neuk_s
nicks	11	49	2049	3	nick_s
nocks	11	51	2101	3	nock_s
packs	13	55	2893	3	pack_s
peaks	11	48	2562	3	peak_s
pecans	10	15	1583	3	pecans
pechs	12	55	1620	3	pec_hs
peck	12	57	3068	3	peck__
pecked	15	50	1910	3	pecked
pecker	14	46	1536	3	pecker
peckers	15	33	1267	3	peckers
peckish	18	22	729	3	peckish
pecky	16	55	1509	3	peck_y
pecs	8	46	3410	3	pec__s
pedros	9	3	1218	3	pedros
peeks	11	50	2111	3	peek_s
pekes	11	46	2356	3	pe_kes
pekoe	11	46	1236	3	pe_koe
pekoes	12	44	1042	3	pe_koes
pengos	9	46	1241	3	pengos
peplos	10	12	1154	3	peplos
pepos	9	66	2008	3	pe_pos
perks	11	53	2580	3	perk_s
pesos	7	72	2162	3	pe_sos
pestos	8	47	1908	3	pestos
picks	13	52	2614	3	pick_s
pinkos	12	53	1387	3	pinkos
pocks	13	50	2296	3	pock_s
pucks	13	43	2210	3	puck_s
racks	11	50	2885	3	rack_s
recaps	10	36	1573	3	recaps
recces	10	6	1491	3	recces
recess	8	3	1426	3	recess
rechose	12	13	1204	3	rechose
recits	8	36	2135	3	recits
reck	10	61	3056	3	reck__
recked	13	48	2180	3	recked
recon	7	56	2424	3	rec_on
recons	8	49	2299	3	recons
recook	12	55	1392	3	recook
recooks	13	47	1123	3	recooks
recross	9	8	983	3	recross
recs	6	57	3418	3	rec__s
recto	7	45	2080	3	recto_
rector	8	40	1975	3	rector
rectors	9	35	2052	3	rectors
rectus	8	33	1463	3	rectus
recurs	8	33	1580	3	recurs
recuts	8	38	1737	3	recuts
redos	6	51	2676	3	re_dos
reeks	9	41	2403	3	reek_s
repos	7	47	2579	3	re_pos
repros	8	42	1600	3	repros
retros	6	38	2019	3	retros
ricks	11	51	2613	3	rick_s
rocks	11	46	2641	3	rock_s
rucks	11	44	2205	3	ruck_s
ruckus	12	40	779	3	ruckus
sacks	11	42	2887	3	sack_s
secco	9	3	1242	3	secco_
secs	6	50	3389	3	sec__s
sector	8	34	1593	3	sector
sectors	9	31	1645	3	sectors
sects	7	56	2289	3	sec_ts
seeks	9	47	2464	3	seek_s
segnos	7	36	1044	3	segnos
segos	6	49	1948	3	se_gos
servos	9	38	1272	3	servos
sextos	13	40	1216	3	sextos
shackos	16	42	902	3	shackos
shakos	13	49	1219	3	shakos
sicko	11	53	1539	3	sicko_
sicks	11	51	2762	3	sick_s
snecks	12	44	1003	3	sneck_s
socko	11	52	1511	3	socko_
socks	11	49	2608	3	sock_s
specks	14	43	1270	3	speck_s
sucks	11	45	2307	3	suck_s
tacks	11	54	3013	3	tack_s
tacos	7	70	2355	3	tac_os
teaks	9	42	2290	3	teak_s
technos	12	3	618	3	technos
techs	10	69	1583	3	tec_hs
telcos	8	7	1068	3	telcos
telos	5	54	2452	3	te_los
tempos	10	38	1229	3	tempos
ticks	11	58	2329	3	tick_s
tucks	11	47	2112	3	tuck_s
uncos	7	41	1703	3	unc_os
vector	11	32	1206	3	vector
vectors	12	32	1259	3	vectors
velcros	12	4	403	3	velcros
versos	9	38	1280	3	versos
wackes	15	47	1771	3	wackes
wacko	14	55	1438	3	wacko_
wacks	14	66	2628	3	wack_s
weakon	13	35	762	3	weakon
weakons	14	28	780	3	weakons
wechts	14	4	625	3	wechts
weeks	12	50	1786	3	week_s
wekas	12	39	1179	3	we_kas
whackos	19	37	526	3	whackos
wicks	14	46	1936	3	wick_s
wrecks	15	41	888	3	wreck_s
yacks	14	44	1981	3	yack_s
yecchs	16	41	495	3	yecchs
yechs	13	61	1258	3	yec_hs
yelks	12	64	1362	3	yelk_s
yerks	12	54	1656	3	yerk_s
yeuks	12	51	1009	3	yeuk_s
yocks	14	44	1837	3	yock_s
yucks	14	47	1719	3	yuck_s
zeks	17	58	1506	3	ze_k_s
zerks	18	51	1382	3	zerk_s
zeros	14	49	1811	3	ze_ros

Search took 7 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	112716	0.420	425454.8
2	DLD Change Limit	112716	361	5.846	19280.9
3	Display Results	361	361	0.140	2578.6
	(SQL Overall)	178691	361	6.406	27894.3