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

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

296 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
legato	7	28	1095	(None)
legate	7	29	1745	1	legate
legator	8	30	1113	1	legator
legatos	8	27	1118	1	legatos
begat	8	66	2972	2	begat_
fugato	10	3	622	2	fugato
gelato	7	38	1295	2	gelato
legacy	12	5	665	2	legacy
legal	6	57	1594	2	lega_l
legals	7	34	1273	2	legals
legated	9	25	1398	2	legated
legatee	8	28	1463	2	legatee
legates	8	29	1767	2	legates
legation	9	24	1293	2	legation
legators	9	28	1102	2	legators
legit	6	13	2350	2	legit_
legits	7	13	1300	2	legits
lento	5	72	2339	2	le_nto
levator	10	29	896	2	levator
ligate	7	25	1924	2	ligate
megaton	10	26	984	2	megaton
negate	7	29	1557	2	negate
negaton	8	29	914	2	negaton
negator	8	30	1067	2	negator
rebato	8	37	1468	2	rebato
ablegate	11	4	725	3	ablegate
aerate	6	48	3055	3	aerate
aerator	7	3	1484	3	aerator
agate	6	65	2514	3	_agate
alegar	7	3	928	3	alega_r
alegars	8	3	893	3	alegars
beano	7	54	2155	3	be_ano
beat	6	61	6830	3	be_at_
beats	7	60	4224	3	be_ats
begall	9	26	1072	3	begall
began	8	63	1957	3	bega_n
begaze	18	3	833	3	begaze
beget	8	56	3255	3	beget_
begets	9	62	1552	3	begets
begot	8	46	2595	3	begot_
bemata	10	4	1169	3	bemata
bento	7	59	2295	3	be_nto
berate	8	47	2902	3	berate
bleat	7	57	3700	3	ble_at_
bleats	8	55	1861	3	ble_ats
cento	7	66	2517	3	ce_nto
cerate	8	48	2946	3	cerate
cleat	7	63	3506	3	cle_at_
cleats	8	49	1931	3	cle_ats
cogito	9	3	920	3	cogito
dato	5	61	2994	3	__dato
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
degage	9	27	1138	3	degage
degame	10	27	1318	3	degame
degami	10	27	900	3	degami
degas	7	51	1916	3	dega_s
delate	7	38	2775	3	delate
delator	8	30	1502	3	delator
delegate	10	4	1046	3	delegate
delegator	11	4	624	3	delegator
derat	6	50	4408	3	derat_
derate	7	45	3123	3	derate
derats	7	46	2506	3	derats
eat	3	69	8905	3	_e_at_
eath	7	57	3566	3	_e_ath
eats	4	70	5487	3	_e_ats
egad	6	42	1541	3	_ega_d
egads	7	46	1092	3	_egads
egal	5	51	1943	3	_ega_l
ego	4	67	2605	3	_eg__o
elate	5	53	3588	3	_elate
elegant	8	3	1150	3	elegant
elegit	7	12	1289	3	elegit_
elegits	8	14	934	3	elegits
elevate	10	11	1037	3	elevate
elevator	11	4	671	3	elevator
eluate	6	23	1543	3	eluate
enate	5	44	2814	3	_enate
ergate	7	3	1514	3	ergate
feat	7	64	5822	3	fe_at_
feats	8	64	3275	3	fe_ats
fugatos	11	3	548	3	fugatos
gat	4	68	8051	3	__gat_
gate	5	57	4657	3	__gate
gator	6	44	1603	3	__gator
gats	5	67	5344	3	__gats
gelate	7	34	2125	3	gelate
gelati	7	38	1453	3	gelati
gelatos	8	31	1151	3	gelatos
gigaton	9	4	634	3	gigaton
heat	7	70	6142	3	he_at_
heath	11	57	2428	3	he_ath
heats	8	58	3840	3	he_ats
hegari	10	3	951	3	hegari
hereto	9	3	1369	3	hereto
ingate	7	30	1823	3	ingate
jato	11	58	2268	3	__jato
jugate	14	37	946	3	jugate
keto	8	62	2345	3	ke__to
klepto	12	4	445	3	kle_pto
lagan	6	65	2034	3	laga_n
lagans	7	57	1778	3	lagans
lanate	6	4	2126	3	lanate
lat	3	75	9340	3	l__at_
late	4	75	6048	3	l__ate
lath	7	66	4038	3	l__ath
lati	4	64	3827	3	l__ati
lats	4	59	6270	3	l__ats
latu	4	79	3418	3	l__atu
lavabo	11	3	527	3	lavabo
lea	3	76	6018	3	le_a__
leach	10	54	2252	3	le_ach
lead	5	60	3885	3	le_a_d
leads	6	60	2849	3	le_ads
leady	9	56	1860	3	le_ady
leaf	7	64	4103	3	le_a_f
leafs	8	57	2118	3	le_afs
leafy	11	63	1621	3	le_afy
league	7	5	874	3	league
leak	8	62	3371	3	le_a_k
leaks	9	59	2391	3	le_aks
leaky	12	52	1772	3	le_aky
leal	4	60	4327	3	le_a_l
lealty	9	29	1060	3	lealty
lean	4	63	4524	3	le_a_n
leans	5	55	3625	3	le_ans
leant	5	67	3778	3	le_ant
leap	6	60	3268	3	le_a_p
leaps	7	55	2293	3	le_aps
leapt	7	50	2747	3	le_apt
lear	4	70	4595	3	le_a_r
learn	5	53	2266	3	le_arn
lears	5	59	3873	3	le_ars
leary	8	59	2738	3	le_ary
leas	4	59	5418	3	le_a_s
lease	5	52	3026	3	le_ase
leash	8	55	1921	3	le_ash
least	5	61	3488	3	le_ast
leasts	6	46	1641	3	leasts
leave	8	47	2372	3	le_ave
leavy	11	57	1577	3	le_avy
lector	8	35	1498	3	le_ctor
leet	4	59	5790	3	le_et_
leets	5	49	2712	3	le_ets
left	7	63	4048	3	le_ft_
lefts	8	65	1781	3	le_fts
lefty	11	56	1356	3	le_fty
leg	4	64	4611	3	leg___
legality	12	3	762	3	legality
legally	11	3	813	3	legally
legatees	9	25	842	3	legatees
legatine	9	13	1140	3	legatine
legating	10	23	1311	3	legating
legations	10	27	1192	3	legations
legend	8	3	769	3	legend
leger	6	57	2150	3	leg_er
legers	7	45	1831	3	legers
leges	6	44	2728	3	leg_es
legged	9	57	1308	3	legged
leggin	8	26	859	3	leggin
leggy	10	52	1024	3	leg_gy
legion	7	57	1298	3	legion
legist	7	13	1525	3	legist
legists	8	9	959	3	legists
legman	9	4	965	3	legman
legmen	9	3	934	3	legmen
legong	8	3	696	3	legong
legroom	10	7	609	3	legroom
legs	5	61	3369	3	leg__s
legume	9	3	691	3	legume
leman	7	56	2260	3	lema_n
lemans	8	53	1639	3	lemans
lemmata	11	4	467	3	lemmata
length	10	4	610	3	length
lenite	6	7	1998	3	lenite
lenity	9	6	1271	3	lenity
leno	4	73	3139	3	le__no
lent	4	63	6053	3	le_nt_
lentos	6	53	1740	3	le_ntos
lept	6	64	4088	3	le_pt_
lepta	7	57	1439	3	le_pta
lepton	8	25	1079	3	le_pton
lesbo	7	3	925	3	le_sbo
lest	4	69	5632	3	le_st_
let	3	64	8147	3	le__t_
lets	4	71	4794	3	le__ts
leva	7	70	2071	3	leva__
levant	9	3	1449	3	levant
levants	10	3	772	3	levants
levators	11	24	928	3	levators
levigate	12	4	662	3	levigate
levity	12	7	790	3	levity
levo	7	68	2006	3	le__vo
ligan	6	79	2028	3	liga_n
ligand	8	50	1129	3	ligand
ligans	7	68	1773	3	ligans
ligase	7	25	991	3	ligase
ligated	9	24	1413	3	ligated
ligates	8	23	1837	3	ligates
ligation	9	23	1309	3	ligation
light	9	44	2960	3	light_
lights	10	45	1991	3	lights
llano	5	9	1060	3	l_lano
loath	8	49	1860	3	l_oath
lobate	8	29	1524	3	lobate
locate	8	39	1984	3	locate
locator	9	31	1042	3	locator
logan	6	81	2328	3	loga_n
logans	7	63	1906	3	logans
loggats	9	28	645	3	loggats
logo	5	79	3176	3	log__o
lotto	5	52	1757	3	l_otto
lovat	8	3	2104	3	lovat_
lovats	9	3	907	3	lovats
lunate	6	3	1604	3	lunate
luxate	13	3	808	3	luxate
lyrate	9	41	1210	3	lyrate
lysate	9	38	810	3	lysate
meat	6	63	5960	3	me_at_
meats	7	50	3405	3	me_ats
meaty	10	70	2131	3	me_aty
mega	7	76	2087	3	mega__
megapod	13	4	488	3	megapod
megara	9	3	1009	3	megara
megaron	10	24	829	3	megaron
megass	9	21	944	3	megass
megatons	11	27	969	3	megatons
metate	8	27	2053	3	metate
neat	4	63	5678	3	ne_at_
neath	8	60	2028	3	ne_ath
neats	5	59	3190	3	ne_ats
negated	9	34	1323	3	negated
negater	8	37	1195	3	negater
negates	8	32	1583	3	negates
negation	9	29	1302	3	negation
negatons	9	29	927	3	negatons
negators	9	24	1115	3	negators
negatron	9	33	599	3	negatron
obligato	11	19	498	3	obligato
oleate	6	3	1888	3	ole_ate
oregano	8	4	625	3	oregano
peat	6	59	6793	3	pe_at_
peats	7	61	4019	3	pe_ats
peaty	10	57	2569	3	pe_aty
pedalo	9	38	1114	3	pedalo
pedate	9	31	1776	3	pedate
pesto	7	57	2372	3	pe_sto
petto	7	60	2104	3	pe_tto
pleat	7	47	3447	3	ple_at_
pleats	8	52	1859	3	ple_ats
potato	8	5	1343	3	potato
rabato	8	34	1326	3	rabato
rato	4	54	3697	3	__rato
reata	5	42	2539	3	re_ata
rebate	8	44	2410	3	rebate
rebatos	9	29	1309	3	rebatos
recto	7	45	2080	3	re_cto
redate	7	41	2468	3	redate
regain	7	45	1776	3	regain
regal	6	50	2379	3	rega_l
regale	7	48	2145	3	regale
regard	8	52	1577	3	regard
regatta	8	3	596	3	regatta
regave	10	47	1338	3	regave
regmata	10	3	619	3	regmata
regrate	8	26	1865	3	regrate
relate	6	40	3363	3	relate
relator	7	40	1636	3	relator
relegate	9	3	1124	3	relegate
remate	8	44	2868	3	remate
resat	5	51	3968	3	resat_
righto	10	41	1109	3	righto
rubato	8	31	967	3	rubato
rugate	7	58	1381	3	rugate
seat	4	75	7556	3	se_at_
seats	5	48	4434	3	se_ats
sedate	7	30	1980	3	sedate
segno	6	48	1474	3	seg_no
sego	5	65	2518	3	seg__o
senate	6	37	2514	3	senate
senator	7	3	1306	3	senator
sexto	12	44	1545	3	se_xto
sleazo	15	25	752	3	sle_azo
teat	4	59	6363	3	te_at_
teats	5	56	3681	3	te_ats
tenuto	6	4	874	3	tenuto
togate	7	45	1568	3	togate
tomato	8	3	1345	3	tomato
vegan	9	51	1415	3	vega_n
vegans	10	39	1085	3	vegans
vegete	10	3	948	3	vegete
velate	9	37	2014	3	velate
veto	7	66	2299	3	ve__to

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.123	1452772.4
2	DLD Change Limit	112716	296	6.580	17130.1
3	Display Results	296	296	0.076	3894.7
	(SQL Overall)	178691	296	6.779	26359.5