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

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

388 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
gelati	7	38	1453	(None)
gelate	7	34	2125	1	gelate
gelatin	8	35	1473	1	gelatin
gelatis	8	33	1351	1	gelatis
gelato	7	38	1295	1	gelato
delate	7	38	2775	2	delate
elate	5	53	3588	2	_elate
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
gelatine	9	32	1330	2	gelatine
gelating	10	30	1573	2	gelating
gelatins	9	34	1409	2	gelatins
gelation	9	30	1443	2	gelation
gelatos	8	31	1151	2	gelatos
gelt	5	64	4801	2	gel_t_
gelts	6	59	2461	2	gel_ts
lati	4	64	3827	2	__lati
relate	6	40	3363	2	relate
velate	9	37	2014	2	velate
ablate	8	22	1921	3	ablate
aerate	6	48	3055	3	aerate
agemate	10	12	1058	3	agemate
alate	5	53	4032	3	_alate
atlatl	6	3	787	3	atlatl
balata	8	6	1467	3	balata
beat	6	61	6830	3	be_at_
beats	7	60	4224	3	be_ats
begat	8	66	2972	3	begat_
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
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
boleti	8	4	1340	3	boleti
calami	10	3	1342	3	calami
calathi	12	4	758	3	calathi
celli	7	67	1769	3	cel_li
celt	6	56	4671	3	cel_t_
celts	7	53	2578	3	cel_ts
centai	8	48	1478	3	centai
cerate	8	48	2946	3	cerate
ceratin	9	30	2016	3	ceratin
cesti	7	52	1742	3	ce_sti
chelate	12	29	1489	3	chelate
clavi	10	49	1292	3	_clavi
cleat	7	63	3506	3	cleat_
cleats	8	49	1931	3	cleats
coati	7	56	2464	3	_coati
culti	7	63	1725	3	cul_ti
dalasi	7	6	1062	3	dalasi
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
degami	10	27	901	3	degami
delated	9	37	2287	3	delated
delates	8	35	2628	3	delates
delating	10	31	1960	3	delating
delation	9	23	1808	3	delation
delator	8	30	1502	3	delator
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
deli	5	56	3129	3	del__i
delt	5	78	5527	3	del_t_
delta	6	61	1777	3	del_ta
deltaic	10	3	702	3	deltaic
deltas	7	44	1482	3	deltas
deltic	9	3	1250	3	del_tic
delts	6	57	3179	3	del_ts
denari	7	109	1735	3	denari
derat	6	50	4408	3	derat_
derate	7	45	3123	3	derate
derats	7	46	2506	3	derats
digerati	10	4	740	3	digerati
dilate	7	32	2069	3	dilate
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
elapid	9	3	954	3	_elapid
elastic	9	30	1339	3	_elastic
elastin	7	26	1184	3	_elastin
elated	7	47	2582	3	_elated
elater	6	47	2420	3	_elater
elates	6	50	3236	3	_elates
elating	8	34	2308	3	_elating
elation	7	36	2045	3	_elation
elative	10	3	1245	3	_elative
elemi	7	3	1250	3	_elemi
elhi	7	6	1240	3	_el_hi
elite	5	62	3018	3	_elite
eluate	6	23	1543	3	_eluate
elute	5	48	2257	3	_elute
enate	5	44	2814	3	_enate
enatic	8	3	1756	3	_enatic
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
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
gadi	6	63	2972	3	g__adi
gait	5	61	5019	3	g__ait
gala	5	56	3516	3	gala__
galabia	10	3	832	3	galabia
galactic	13	10	653	3	galactic
galago	8	3	890	3	galago
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
gallate	8	34	1712	3	gallate
gat	4	68	8051	3	g__at_
gate	5	57	4657	3	g__ate
gats	5	67	5344	3	g__ats
gear	5	59	3497	3	ge_a_r
gears	6	46	2869	3	ge_ars
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
gelatines	10	29	1053	3	gelati~~nes~~
gelations	10	25	1309	3	gelati~~ons~~
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
gematria	11	7	567	3	gematria
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_
genetic	10	12	1178	3	genetic
genets	7	57	1666	3	genets
genii	6	45	1417	3	ge_nii
gent	5	69	5439	3	ge_nt_
gentil	7	41	1512	3	ge_ntil
gents	6	57	2961	3	ge_nts
gerah	9	3	1530	3	gera_h
gerahs	10	3	941	3	gerahs
gest	5	61	4913	3	ge_st_
gestate	8	36	1407	3	gestate
geste	6	59	2069	3	ge_ste
gestic	9	3	1277	3	ge_stic
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
ghazi	18	3	744	3	g_hazi
gilt	5	63	4854	3	gil_t_
gilts	6	49	2426	3	gil_ts
glace	8	74	2015	3	g_lace
glacis	9	40	1213	3	g_lacis
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
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
glutei	7	40	974	3	g_lutei
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
gomuti	9	3	655	3	gomuti
grat	5	56	5128	3	g_rat_
grate	6	49	3288	3	g_rate
gratin	7	45	2058	3	g_ratin
gratis	7	48	1924	3	g_ratis
great	6	60	3424	3	great_
greats	7	63	1839	3	greats
groat	6	55	3197	3	groat_
groats	7	48	1665	3	groats
gulag	7	3	1082	3	gula_g
gulags	8	3	754	3	gulags
gular	6	3	1483	3	gula_r
gyrate	10	49	1252	3	gyrate
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
hegari	10	3	952	3	hegari
helot	8	53	3268	3	helot_
helots	9	52	1770	3	helots
hematic	14	18	1674	3	hematic
hematin	12	15	1602	3	hematin
hepatic	14	17	1277	3	hepatic
kelt	8	53	4319	3	kel_t_
kelts	9	52	2263	3	kel_ts
keratin	11	33	1415	3	keratin
kulaki	9	8	429	3	kulaki
lari	4	58	3915	3	__lari
lat	3	75	9340	3	__lat_
late	4	75	6048	3	__late
lath	7	66	4038	3	__lath
lathi	8	54	1720	3	__lathi
lats	4	59	6270	3	__lats
latu	4	79	3418	3	__latu
lealty	9	29	1060	3	lealty
legate	7	29	1745	3	legate
legato	7	28	1095	3	legato
loti	4	64	3184	3	__loti
malate	8	46	2455	3	malate
maloti	8	3	1321	3	maloti
meat	6	63	5960	3	me_at_
meats	7	50	3405	3	me_ats
meaty	10	70	2131	3	me_aty
melanic	11	3	1040	3	melanic
melanin	9	3	1089	3	melanin
melt	6	57	5289	3	mel_t_
melts	7	49	3010	3	mel_ts
melty	10	49	1836	3	mel_ty
metate	8	27	2053	3	metate
miladi	9	3	888	3	miladi
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
nematic	11	17	1399	3	nematic
oblasti	9	4	594	3	oblasti
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
pedate	9	31	1776	3	pedate
pelage	9	5	1536	3	pelage
pelagic	12	3	786	3	pelagic
pelite	8	43	2300	3	pelite
pelitic	11	18	1465	3	pelitic
pelota	8	6	1283	3	pelota
pelt	6	76	5108	3	pel_t_
peltate	9	20	1377	3	peltate
pelts	7	61	2881	3	pel_ts
periti	8	3	1995	3	periti
petti	7	51	1945	3	pe_tti
plait	7	56	3157	3	_plait
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
prelate	9	5	1969	3	prelate
prelatic	12	3	1128	3	prelatic
realty	9	27	1369	3	realty
reata	5	42	2539	3	re_ata
rebait	8	3	2040	3	rebait
rebate	8	44	2411	3	rebate
rebato	8	37	1468	3	rebato
recti	7	36	1962	3	re_cti
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
relating	9	27	2544	3	relating
relation	8	26	1977	3	relation
relative	11	3	1314	3	relative
relator	7	40	1636	3	relator
relax	12	48	1780	3	rela_x
relaxin	14	23	918	3	relaxin
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
rubati	8	29	969	3	rubati
salami	8	3	1310	3	salami
sati	4	55	3933	3	__sati
seat	4	75	7556	3	se_at_
seats	5	48	4434	3	se_ats
sedate	7	30	1980	3	sedate
selah	8	3	1961	3	sela_h
selahs	9	3	1321	3	selahs
sematic	11	17	1687	3	sematic
senate	6	37	2514	3	senate
seniti	6	43	1722	3	seniti
senti	5	62	2670	3	se_nti
serai	5	68	3016	3	sera_i
slat	4	69	5902	3	_slat_
slate	5	54	3828	3	_slate
slats	5	54	3690	3	_slats
slaty	8	65	2315	3	_slaty
smalti	8	41	1119	3	smalti
solate	6	45	2607	3	solate
solatia	7	3	1225	3	solatia
splat	7	61	2934	3	splat_
splats	8	48	1730	3	splats
stelai	6	39	1256	3	stela_i
strati	6	35	1890	3	strati
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
teloi	5	42	1738	3	tel_oi
tenuti	6	3	897	3	tenuti
terai	5	35	2548	3	tera_i
tuladi	7	6	572	3	tuladi
vela	7	57	2554	3	vela__
velar	8	58	1763	3	vela_r
velaria	10	3	892	3	velaria
velars	9	39	1372	3	velars
veldt	9	48	1986	3	veldt_
veldts	10	41	775	3	veldts
venatic	12	3	1152	3	venatic
volti	8	49	1596	3	vol_ti
wealth	12	37	922	3	wealth
welt	7	55	4786	3	wel_t_
welts	8	52	2519	3	wel_ts
yeti	7	58	2321	3	ye__ti
zeatin	15	4	1282	3	ze_atin

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	112716	0.140	1276364.3
2	DLD Change Limit	112716	388	4.656	24208.8
3	Display Results	388	388	0.110	3527.3
	(SQL Overall)	178691	388	4.906	36423.0