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

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

384 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
gelato	7	38	1295	(None)
gelate	7	34	2125	1	gelate
gelati	7	38	1453	1	gelati
gelatos	8	31	1151	1	gelatos
delate	7	38	2775	2	delate
delator	8	30	1502	2	delator
elate	5	53	3588	2	_elate
galago	8	3	890	2	galago
gelada	8	3	762	2	gelada
gelant	7	28	2167	2	gelant
gelants	8	26	1144	2	gelants
gelated	9	36	1563	2	gelated
gelates	8	32	1958	2	gelates
gelatin	8	35	1473	2	gelatin
gelation	9	30	1443	2	gelation
gelatis	8	33	1351	2	gelatis
gelt	5	64	4801	2	gel_t_
gelts	6	59	2461	2	gel_ts
legato	7	28	1095	2	legato
rebato	8	37	1468	2	rebato
relate	6	40	3363	2	relate
relator	7	40	1636	2	relator
velate	9	37	2014	2	velate
ablate	8	22	1921	3	ablate
ablator	9	3	984	3	ablator
aerate	6	48	3055	3	aerate
aerator	7	3	1484	3	aerator
agemate	10	12	1058	3	agemate
agitato	8	5	657	3	agitato
alamo	7	4	1814	3	_alamo
alate	5	53	4032	3	_alate
alto	4	78	3126	3	_al_to
atlatl	6	3	787	3	atlatl
balata	8	6	1467	3	balata
beano	7	54	2155	3	be_ano
beat	6	61	6830	3	be_at_
beats	7	60	4224	3	be_ats
begat	8	66	2972	3	begat_
belabor	11	3	629	3	belabor
belady	12	48	993	3	belady
belated	10	35	2001	3	belated
belaud	9	3	913	3	belaud
belay	10	50	2152	3	bela_y
belays	11	43	1385	3	belays
belt	6	57	5403	3	bel_t_
belts	7	59	3116	3	bel_ts
bemata	10	4	1169	3	bemata
bento	7	59	2295	3	be_nto
berate	8	47	2902	3	berate
blat	6	65	5095	3	_blat_
blate	7	59	3378	3	_blate
blats	7	51	3250	3	_blats
bleat	7	57	3700	3	bleat_
bleats	8	55	1861	3	bleats
celadon	10	3	691	3	celadon
cello	7	49	1958	3	cel_lo
celt	6	56	4671	3	cel_t_
celts	7	53	2578	3	cel_ts
cento	7	66	2517	3	ce_nto
cerate	8	48	2946	3	cerate
chelate	12	29	1489	3	chelate
chelator	13	4	791	3	chelator
claro	7	50	1869	3	_claro
cleat	7	63	3506	3	cleat_
cleats	8	49	1931	3	cleats
dato	5	61	2994	3	__dato
dealate	8	36	1784	3	dealate
dealt	6	52	3428	3	dealt_
death	9	48	2252	3	de_ath
debate	9	44	1919	3	debate
defat	9	54	2669	3	defat_
defats	10	51	1455	3	defats
deflate	11	36	1394	3	deflate
deflator	12	32	834	3	deflator
delated	9	37	2287	3	delated
delates	8	35	2628	3	delates
delation	9	23	1808	3	delation
delators	9	23	1482	3	delators
delay	9	48	2063	3	dela_y
delays	10	40	1405	3	delays
delete	7	36	2070	3	delete
delft	9	56	2332	3	delft_
delfts	10	43	967	3	delfts
delt	5	78	5527	3	del_t_
delta	6	61	1777	3	del_ta
deltas	7	44	1482	3	deltas
delts	6	57	3179	3	del_ts
derat	6	50	4408	3	derat_
derate	7	45	3123	3	derate
derats	7	46	2506	3	derats
dilate	7	32	2069	3	dilate
dilator	8	27	1278	3	dilator
eat	3	69	8905	3	_e_at_
eath	7	57	3566	3	_e_ath
eats	4	70	5487	3	_e_ats
eclat	7	5	2360	3	eclat_
eclats	8	3	1303	3	eclats
elain	5	53	2470	3	_elain
elan	4	67	3424	3	_ela_n
eland	6	58	2039	3	_eland
elans	5	55	2775	3	_elans
elated	7	47	2582	3	_elated
elater	6	47	2420	3	_elater
elates	6	50	3236	3	_elates
elation	7	36	2045	3	_elation
elite	5	62	3018	3	_elite
eluate	6	23	1543	3	_eluate
elute	5	48	2257	3	_elute
enate	5	44	2815	3	_enate
fealty	12	29	1022	3	fealty
feat	7	64	5822	3	fe_at_
feats	8	64	3275	3	fe_ats
fellate	10	3	1343	3	fellate
fellatio	11	4	568	3	fellatio
fellator	11	7	671	3	fellator
felt	7	51	4693	3	fel_t_
felts	8	53	2454	3	fel_ts
flat	7	71	4782	3	_flat_
flats	8	64	2974	3	_flats
folate	9	33	2039	3	folate
fugato	10	3	622	3	fugato
gala	5	56	3516	3	gala__
galagos	9	3	814	3	galagos
galah	9	59	1763	3	gala_h
galahs	10	55	1267	3	galahs
galas	6	57	3164	3	gala_s
galatea	8	3	995	3	galatea
galax	13	53	1446	3	gala_x
galaxy	17	47	631	3	galaxy
galeate	8	39	1678	3	galeate
galiot	7	23	2259	3	galiot
gallate	8	34	1712	3	gallate
galoot	7	27	1916	3	galoot
gat	4	68	8051	3	g__at_
gate	5	57	4657	3	g__ate
gator	6	44	1603	3	g__ator
gats	5	67	5344	3	g__ats
gazabo	18	3	483	3	gazabo
gear	5	59	3497	3	ge_a_r
gears	6	46	2869	3	ge_ars
gecko	12	45	1111	3	ge_cko
geest	6	48	2961	3	geest_
geests	7	59	1216	3	geests
gel	4	56	4243	3	gel___
gelable	10	17	1073	3	gelable
geladas	9	3	631	3	geladas
gelatine	9	32	1330	3	gelatine
gelating	10	30	1573	3	gelating
gelatins	9	34	1409	3	gelatins
gelations	10	25	1309	3	gelations
gelcap	11	3	621	3	gelcap
gelcaps	12	3	520	3	gelcaps
geld	6	58	2843	3	gel__d
gelded	9	45	1211	3	gelded
gelder	8	46	1371	3	gelder
gelds	7	51	1834	3	gel_ds
gelee	6	36	2698	3	gel_ee
gelees	7	41	1626	3	gelees
gelid	7	49	1698	3	gel_id
gellant	8	32	1405	3	gellant
gellants	9	30	828	3	gellants
gelled	8	47	1889	3	gelled
gels	5	68	3610	3	gel__s
gemmate	12	41	838	3	gemmate
gemot	8	40	2423	3	gemot_
gemote	9	46	1302	3	gemote
gemots	9	37	1215	3	gemots
genet	6	60	3868	3	genet_
genets	7	57	1666	3	genets
genitor	8	3	727	3	genitor
genro	6	49	1403	3	ge_nro
gent	5	69	5439	3	ge_nt_
gentoo	7	3	1131	3	gentoo
gents	6	57	2961	3	ge_nts
gerah	9	3	1530	3	gera_h
gerahs	10	3	941	3	gerahs
gesso	6	4	960	3	ge_sso
gest	5	61	4913	3	ge_st_
gestapo	10	4	449	3	gestapo
gestate	8	36	1407	3	gestate
geste	6	59	2069	3	ge_ste
gests	6	60	2881	3	ge_sts
get	4	74	6746	3	ge__t_
geta	5	66	2744	3	ge__ta
getas	6	54	2148	3	geta_s
gets	5	54	4248	3	ge__ts
ghat	8	64	3528	3	g_hat_
ghats	9	58	1861	3	g_hats
gherao	10	3	675	3	ghera_o
ghetto	10	3	607	3	ghetto
gigaton	9	4	634	3	gigaton
gilt	5	63	4854	3	gil_t_
gilts	6	49	2426	3	gil_ts
gitano	7	3	804	3	gitano
glace	8	74	2015	3	g_lace
glad	6	56	2401	3	g_la_d
glade	7	51	2196	3	g_lade
glads	7	56	2061	3	g_lads
glady	10	54	1394	3	g_lady
glair	6	53	1355	3	g_lair
glam	7	65	2934	3	g_la_m
glamor	9	5	818	3	g_lamor
glams	8	58	2293	3	g_lams
gland	7	52	1771	3	g_land
glans	6	51	2583	3	g_lans
glare	6	52	2295	3	g_lare
glary	9	60	1854	3	g_lary
glass	6	55	1813	3	g_lass
glaze	15	54	1816	3	g_laze
glazy	18	74	1098	3	g_lazy
gleam	8	69	1673	3	glea_m
gleams	9	48	1225	3	gleams
gleamy	12	39	811	3	gleamy
glean	6	58	1820	3	glea_n
gleans	7	50	1474	3	gleans
gleet	6	55	3234	3	gleet_
gleets	7	53	1505	3	gleets
gleety	10	47	919	3	gleety
glitz	15	49	1637	3	g_litz
gloat	6	54	2768	3	gloat_
gloats	7	45	1542	3	gloats
glut	5	63	3129	3	g_lut_
glute	6	60	2090	3	g_lute
gluts	6	61	2013	3	g_luts
gnat	5	60	3443	3	g_nat_
gnats	6	52	1771	3	g_nats
goat	5	62	5083	3	g_oat_
goats	6	55	2730	3	g_oats
goliath	11	4	593	3	goliath
grat	5	56	5128	3	g_rat_
grate	6	49	3288	3	g_rate
great	6	60	3424	3	great_
greats	7	63	1839	3	greats
groat	6	55	3197	3	groat_
groats	7	48	1665	3	groats
grotto	7	34	981	3	grotto
guaco	8	50	1216	3	g_uaco
guano	6	92	1398	3	g_uano
gulag	7	3	1082	3	gula_g
gulags	8	3	754	3	gulags
gular	6	3	1483	3	gula_r
gusto	6	54	1464	3	g_usto
gyrate	10	49	1252	3	gyrate
gyrator	11	3	571	3	gyrator
health	12	47	1214	3	health
heat	7	70	6142	3	he_at_
heath	11	57	2428	3	he_ath
heats	8	58	3840	3	he_ats
helio	8	53	2119	3	hel_io
hello	8	65	2298	3	hel_lo
helo	7	53	3285	3	hel__o
helot	8	53	3268	3	helot_
helots	9	52	1770	3	helots
hereto	9	3	1369	3	hereto
jato	11	58	2268	3	__jato
jello	12	67	1627	3	jel_lo
kelt	8	53	4319	3	kel_t_
kelts	9	52	2263	3	kel_ts
keto	8	62	2345	3	ke__to
klepto	12	4	445	3	klepto
lat	3	75	9340	3	__lat_
late	4	75	6048	3	__late
lath	7	66	4038	3	__lath
lati	4	64	3827	3	__lati
lats	4	59	6270	3	__lats
latu	4	79	3418	3	__latu
lealty	9	29	1060	3	lealty
legate	7	29	1745	3	legate
legator	8	30	1113	3	legator
legatos	8	27	1118	3	legatos
lento	5	72	2339	3	le_nto
levator	10	29	896	3	levator
llano	5	9	1060	3	_llano
malate	8	46	2455	3	malate
meat	6	63	5960	3	me_at_
meats	7	50	3405	3	me_ats
meaty	10	70	2131	3	me_aty
megaton	10	26	985	3	megaton
melt	6	57	5289	3	mel_t_
melton	8	3	1155	3	mel_ton
melts	7	49	3010	3	mel_ts
melty	10	49	1836	3	mel_ty
metate	8	27	2053	3	metate
molto	7	56	1960	3	mol_to
mulatto	9	4	473	3	mulatto
neat	4	63	5678	3	ne_at_
neath	8	60	2028	3	ne_ath
neats	5	59	3190	3	ne_ats
negate	7	29	1557	3	negate
negaton	8	29	914	3	negaton
negator	8	30	1067	3	negator
oblate	8	22	1474	3	oblate
oleate	6	3	1888	3	oleate
palate	8	42	2678	3	palate
peat	6	59	6793	3	pe_at_
peats	7	61	4019	3	pe_ats
peaty	10	57	2569	3	pe_aty
pedalo	9	38	1115	3	pedalo
pedate	9	31	1776	3	pedate
pelage	9	5	1536	3	pelage
pelite	8	43	2300	3	pelite
pelota	8	6	1283	3	pelota
peloton	9	3	874	3	peloton
pelt	6	76	5108	3	pel_t_
peltate	9	20	1377	3	peltate
pelts	7	61	2881	3	pel_ts
pesto	7	57	2372	3	pe_sto
petto	7	60	2104	3	pe_tto
plat	6	60	4887	3	_plat_
plate	7	46	3511	3	_plate
plats	7	55	3137	3	_plats
platy	10	50	2166	3	_platy
pleat	7	47	3447	3	pleat_
pleats	8	52	1859	3	pleats
potato	8	5	1343	3	potato
prelate	9	5	1969	3	prelate
rabato	8	34	1326	3	rabato
rato	4	54	3697	3	__rato
realtor	7	36	1135	3	realtor
realty	9	27	1369	3	realty
reata	5	42	2539	3	re_ata
rebate	8	44	2411	3	rebate
rebatos	9	29	1311	3	rebatos
recto	7	45	2080	3	re_cto
redate	7	41	2468	3	redate
reflate	10	35	1626	3	reflate
regelate	9	3	1208	3	regelate
relace	8	31	2215	3	relace
relaid	7	55	1844	3	relaid
reland	7	59	2043	3	reland
related	8	33	2757	3	related
relater	7	37	2314	3	relater
relates	7	37	3143	3	relates
relation	8	26	1977	3	relation
relators	8	33	1612	3	relators
relax	12	48	1780	3	rela_x
relay	8	44	2467	3	rela_y
relays	9	43	1675	3	relays
relet	5	47	4982	3	relet_
relets	6	40	2567	3	relets
relit	5	53	4068	3	relit_
remate	8	44	2868	3	remate
replate	9	34	2005	3	replate
resat	5	51	3968	3	resat_
reslate	7	35	2059	3	reslate
rialto	6	3	860	3	rialto
rubato	8	31	968	3	rubato
seat	4	75	7556	3	se_at_
seats	5	48	4434	3	se_ats
sedate	7	30	1981	3	sedate
selah	8	3	1961	3	sela_h
selahs	9	3	1321	3	selahs
senate	6	37	2517	3	senate
senator	7	3	1307	3	senator
sexto	12	44	1545	3	se_xto
slat	4	69	5902	3	_slat_
slate	5	54	3828	3	_slate
slats	5	54	3690	3	_slats
slaty	8	65	2315	3	_slaty
sleazo	15	25	752	3	sleazo
smalto	8	44	1028	3	smalto
solano	6	53	1418	3	solano
solate	6	45	2607	3	solate
splat	7	61	2934	3	splat_
splats	8	48	1730	3	splats
teat	4	59	6363	3	te_at_
teats	5	56	3681	3	te_ats
tela	4	55	3297	3	tela__
telae	5	43	2329	3	tela_e
telamon	9	3	652	3	telamon
telco	7	5	1187	3	tel_co
tenuto	6	4	874	3	tenuto
tomato	8	3	1345	3	tomato
vela	7	57	2554	3	vela__
velar	8	58	1763	3	vela_r
velars	9	39	1372	3	velars
velcro	11	4	413	3	velcro
veldt	9	48	1986	3	veldt_
veldts	10	41	775	3	veldts
veto	7	66	2299	3	ve__to
wealth	12	37	922	3	wealth
welt	7	55	4786	3	wel_t_
welts	8	52	2519	3	wel_ts
zealot	15	3	1347	3	zealot

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	112716	0.373	479064.3
2	DLD Change Limit	112716	384	4.940	22817.0
3	Display Results	384	384	0.123	3122.0
	(SQL Overall)	178691	384	5.436	32871.8