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

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

399 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
legion	7	57	1298	(None)
legions	8	46	1178	1	legions
lesion	6	47	1506	1	lesion
logion	7	60	1372	1	logion
region	7	46	1490	1	region
begin	8	51	1735	2	begi_n
flexion	17	3	507	2	flexion
lagoon	7	4	1048	2	lagoon
lection	9	26	1486	2	lection
legation	9	24	1293	2	legation
leggin	8	26	859	2	leggin
leghorn	11	4	622	2	leghorn
legist	7	13	1525	2	legist
legit	6	13	2350	2	legi_t
legits	7	13	1300	2	legits
legman	9	4	965	2	legman
legmen	9	3	934	2	legmen
legong	8	3	696	2	leg_ong
lemon	7	56	1818	2	le_mon
lepton	8	25	1080	2	lepton
lesions	7	38	1387	2	lesions
lesson	6	44	1204	2	lesson
leukon	10	3	614	2	leukon
levin	8	48	1641	2	levi_n
lexicon	16	4	390	2	lexicon
lion	4	63	3445	2	l__ion
login	6	60	2500	2	logi_n
logions	8	62	1129	2	logions
logon	6	159	2231	2	log_on
lotion	6	57	1652	2	lotion
regions	8	36	1347	2	regions
action	8	47	1968	3	action
aegis	6	3	1678	3	aegi_s
aeon	4	56	3461	3	ae__on
agin	5	61	3271	3	_agi_n
agio	5	78	2845	3	_agio_
agios	6	59	1986	3	_agios
agon	5	65	3188	3	_ag_on
alation	7	29	2055	3	alation
alencon	9	4	573	3	alencon
aleuron	7	5	738	3	aleuron
alevin	9	25	1151	3	alevi_n
alexin	13	23	1148	3	alexi_n
algin	6	57	1876	3	algi_n
amnion	8	48	1205	3	amnion
anion	5	50	2881	3	_anion
argon	6	55	2059	3	arg_on
avion	8	42	1834	3	_avion
axion	12	113	1691	3	_axion
basion	8	43	1585	3	basion
beacon	10	5	1137	3	beacon
beckon	14	30	938	3	beckon
began	8	63	1957	3	beg_an
begins	9	44	1530	3	begins
begird	10	3	682	3	begird
begirt	9	4	1268	3	begirt
begone	9	5	1213	3	beg_one
begot	8	46	2595	3	beg_ot
begroan	10	3	610	3	begroan
begun	8	51	1344	3	beg_un
belon	7	39	2411	3	be_lon
benign	9	3	831	3	benign
benison	9	3	712	3	benison
beton	7	60	2206	3	be_ton
bunion	8	31	1131	3	bunion
camion	10	39	1719	3	camion
cation	8	39	2550	3	cation
cession	9	3	981	3	cession
cion	6	133	3092	3	__cion
clarion	9	3	1166	3	clarion
cogon	8	91	2090	3	cog_on
deacon	9	5	1042	3	deacon
deign	7	43	1280	3	de_ign
deletion	9	20	1197	3	deletion
demon	8	65	2031	3	de_mon
design	8	40	893	3	design
devon	9	51	1368	3	de_von
durion	7	5	1096	3	durion
ebon	6	68	2110	3	_e_bon
egis	5	65	2065	3	_egi_s
ego	4	67	2605	3	_eg_o_
egos	5	58	2165	3	_eg_os
eikon	9	3	946	3	_eikon
elain	5	53	2470	3	elai_n
elation	7	36	2045	3	elation
election	10	20	1535	3	election
elegiac	10	4	545	3	elegiac
elegies	8	13	1290	3	elegies
elegise	8	13	939	3	elegise
elegist	8	13	1197	3	elegist
elegit	7	12	1289	3	elegi_t
elegits	8	14	934	3	elegits
elegize	17	12	738	3	elegize
elevon	9	7	795	3	elevon
elfin	8	43	1246	3	elfi_n
elision	7	23	1110	3	elision
eloign	7	45	698	3	eloign
eloin	5	59	2320	3	eloi_n
elusion	7	23	1095	3	elusion
elution	7	29	1382	3	elution
eon	3	60	5208	3	_e__on
epigon	9	3	796	3	_epigon
ethion	9	3	881	3	ethion
exon	11	71	1680	3	_e_xon
fagin	9	2	1657	3	fagi_n
fanion	9	45	1432	3	fanion
feign	9	42	1071	3	fe_ign
felon	8	46	1929	3	fe_lon
fermion	12	3	676	3	fermion
flagon	10	3	798	3	flag_on
flection	13	23	956	3	flection
fleuron	10	5	557	3	fleuron
flexions	18	4	441	3	flexions
fluxion	17	3	504	3	fluxion
fugio	9	3	1092	3	fugio_
fugios	10	3	758	3	fugios
fusion	9	3	977	3	fusion
gabion	9	32	1103	3	gabion
gien	5	63	3003	3	__gien
gin	4	60	5576	3	__gi_n
gipon	8	42	1241	3	__gipon
girn	5	60	2687	3	__girn
giron	6	61	1899	3	__giron
gonion	7	36	1283	3	gonion
goon	5	72	3617	3	__goon
hagdon	11	8	828	3	hagdon
hegemon	13	4	517	3	hegemon
hegira	10	3	652	3	hegira
helicon	12	3	764	3	helicon
helio	8	53	2119	3	helio_
helios	9	48	1663	3	helios
hellion	10	3	1114	3	hellion
hemin	10	36	2093	3	hemi_n
hereon	9	39	1436	3	hereon
heriot	9	4	2234	3	heriot
heroin	9	44	2059	3	heroin
heron	8	50	2550	3	he_ron
inion	5	46	2018	3	_inion
ion	3	60	5103	3	___ion
jeon	11	68	2144	3	je__on
jeton	12	48	1540	3	je_ton
jetton	13	3	803	3	jetton
kation	10	43	1568	3	kation
kelson	10	3	815	3	kelson
ladino	7	36	1512	3	ladino
ladron	7	34	1332	3	ladron
lagan	6	65	2034	3	lag_an
lagoons	8	3	925	3	lagoons
lain	4	61	4628	3	l_ai_n
lampion	11	27	830	3	lampion
lapin	7	52	2292	3	lapi_n
lardon	7	44	1506	3	lardon
latino	6	41	2047	3	latino
layin	8	47	2033	3	layi_n
leaden	7	45	1522	3	leaden
lean	4	63	4524	3	le__an
learn	5	53	2266	3	le_arn
leaven	9	50	1307	3	leaven
leben	7	3	1485	3	le_ben
lectin	8	25	1501	3	lectin
lections	10	24	1384	3	lections
lector	8	35	1499	3	lector
ledgier	9	45	850	3	ledgier
leg	4	64	4611	3	leg___
legacy	12	5	665	3	legacy
legal	6	57	1594	3	leg_al
legals	7	34	1273	3	legals
legate	7	29	1745	3	legate
legations	10	27	1192	3	legations
legato	7	28	1095	3	legato
legator	8	30	1113	3	legator
legatos	8	27	1119	3	legatos
legend	8	3	769	3	legend
leger	6	57	2151	3	leg_er
legers	7	45	1831	3	legers
leges	6	44	2729	3	leg_es
legged	9	57	1309	3	legged
leggier	9	36	823	3	leggier
legging	10	39	1264	3	legging
leggins	9	25	947	3	leggins
leggy	10	52	1024	3	leg_gy
leghorns	12	4	490	3	leghorns
legible	10	3	583	3	legible
legibly	13	4	462	3	legibly
legionary	13	4	365	3	legion~~ary~~
legists	8	9	959	3	legists
leglike	12	13	684	3	leglike
legongs	9	3	454	3	leg_ongs
legroom	10	7	609	3	legroom
legs	5	61	3369	3	leg__s
legume	9	3	691	3	legume
legumin	10	4	507	3	legumin
legwork	15	4	566	3	legwork
lei	3	68	4638	3	le_i__
leis	4	57	3960	3	le_i_s
leman	7	56	2260	3	le_man
lemons	8	44	1505	3	le_mons
lemony	11	41	955	3	le_mony
lenient	7	3	1384	3	lenient
lenis	5	63	2686	3	leni_s
lenite	6	7	1998	3	lenite
lenition	8	3	1008	3	lenition
lenity	9	6	1271	3	lenity
leno	4	73	3139	3	le_no_
lenos	5	60	2486	3	le_nos
lenten	6	3	1288	3	lenten
lento	5	72	2339	3	lento_
lentos	6	53	1740	3	lentos
leone	5	50	1882	3	le__one
leptin	8	25	1233	3	leptin
leptons	9	19	1043	3	leptons
lesbian	9	4	446	3	lesbian
lesbo	7	3	925	3	lesbo_
lesbos	8	3	740	3	lesbos
lesioned	9	3	690	3	lesioned
lessen	6	42	1243	3	lessen
lessons	7	38	1102	3	lessons
lessor	6	40	1060	3	lessor
letdown	11	4	426	3	letdown
leucin	8	3	911	3	leucin
leukons	11	3	575	3	leukons
levied	10	41	1143	3	levied
levier	9	40	1387	3	levier
levies	9	39	1986	3	levies
levins	9	45	1465	3	levins
levis	8	58	1855	3	levi_s
levity	12	7	790	3	levity
levo	7	68	2006	3	le_vo_
lewis	8	53	1584	3	lewi_s
lewisson	11	4	202	3	lewisson
lexica	15	3	610	3	lexica
lexicons	17	4	389	3	lexicons
lexis	12	59	1603	3	lexi_s
liaison	7	4	447	3	liaison
lien	4	53	3981	3	l__ien
ligan	6	79	2028	3	lig_an
ligation	9	23	1309	3	ligation
lignan	7	55	1032	3	lignan
lignin	7	49	1119	3	lignin
ligroin	8	4	804	3	ligroin
limn	6	65	2770	3	l__imn
lin	3	79	6738	3	l__i_n
linin	5	80	2552	3	lini_n
linn	4	60	3460	3	l__inn
lino	4	63	4338	3	l__ino
lions	5	59	2321	3	l__ions
lipin	7	55	1889	3	lipi_n
logan	6	81	2328	3	log_an
logia	6	81	1660	3	logi_a
logic	8	82	1783	3	logi_c
logics	9	57	1112	3	logics
logier	7	50	1573	3	logier
logily	10	3	983	3	logily
logins	7	78	2064	3	logins
logo	5	79	3176	3	log_o_
logoi	6	97	1594	3	log_oi
logons	7	98	1817	3	log_ons
logos	6	72	2533	3	log_os
loin	4	68	3872	3	l_oi_n
loon	4	73	4479	3	l__oon
lorgnon	8	4	442	3	lorgnon
lotions	7	46	1476	3	lotions
luging	8	39	1529	3	luging
lupin	7	52	1584	3	lupi_n
lyricon	12	4	371	3	lyricon
lysin	8	45	1278	3	lysi_n
magian	9	3	1283	3	magian
median	9	41	1754	3	median
megaron	10	24	830	3	megaron
megaton	10	26	985	3	megaton
megilp	11	3	583	3	megilp
melon	7	39	2208	3	me_lon
melton	8	3	1155	3	melton
mention	9	3	1437	3	mention
merino	8	3	1509	3	merino
merlon	8	30	1235	3	merlon
mesian	8	43	1550	3	mesian
meson	7	41	1831	3	me_son
mignon	9	3	795	3	mignon
minion	8	34	1624	3	minion
morion	8	62	1773	3	morion
motion	8	52	1755	3	motion
nasion	6	39	1408	3	nasion
nation	6	43	2280	3	nation
negation	9	29	1302	3	negation
negaton	8	29	914	3	negaton
negroni	8	4	684	3	negroni
nekton	10	3	658	3	nekton
nelson	6	3	842	3	nelson
neocon	8	3	671	3	neocon
neon	4	70	2642	3	ne__on
neuron	6	3	1037	3	neuron
newton	9	3	698	3	newton
notion	6	45	1658	3	notion
olefin	9	3	758	3	olefi_n
olein	5	3	1600	3	ole_i_n
onion	5	43	2097	3	_onion
option	8	36	1271	3	option
pegbox	18	4	401	3	pegbox
pein	6	58	3494	3	pe_i_n
pekin	11	15	1442	3	peki_n
pelon	7	44	2321	3	pe_lon
pennon	8	3	1064	3	pennon
pension	9	4	1220	3	pension
peon	6	56	3524	3	pe__on
pepino	10	3	1033	3	pepino
pereion	9	3	1205	3	pereion
pereon	8	35	1745	3	pereon
perigon	10	3	985	3	perigon
period	9	3	1498	3	period
perron	8	32	1662	3	perron
person	8	35	1787	3	person
pigeon	9	4	941	3	pigeon
pinion	8	38	1589	3	pinion
pion	6	72	3530	3	__pion
pleon	7	42	1638	3	ple__on
pleuron	9	7	634	3	pleuron
plosion	9	3	911	3	plosion
potion	8	45	1957	3	potion
prion	7	51	1999	3	_prion
ration	6	42	2601	3	ration
reagin	7	49	1553	3	reagi_n
reason	6	26	1633	3	reason
reckon	12	30	1054	3	reckon
recoin	8	43	2029	3	recoin
recon	7	56	2424	3	re_con
redon	6	54	2488	3	re_don
regain	7	45	1776	3	regain
regild	8	14	977	3	regild
regilt	7	12	1749	3	regilt
regime	9	53	1394	3	regime
regimen	10	44	1157	3	regimen
regina	7	53	1714	3	regina
regional	9	43	878	3	regional
regius	7	3	1192	3	regius
regive	10	48	1432	3	regive
regiven	11	47	832	3	regiven
reglow	10	33	940	3	reglow
regrow	10	30	988	3	regrow
regrown	11	23	736	3	regrown
reign	6	50	1519	3	re_ign
rein	4	60	4089	3	re_i_n
rejoin	13	40	1224	3	rejoin
religion	9	9	674	3	religion
renin	5	48	3003	3	reni_n
repin	7	53	2470	3	repi_n
resign	7	42	1258	3	resign
resin	5	41	3105	3	resi_n
reunion	7	3	767	3	reunion
rewin	8	56	2396	3	rewi_n
rewon	8	69	2058	3	re_won
ronion	6	33	1564	3	ronion
scion	7	22	1499	3	_scion
season	6	27	1490	3	season
section	9	25	1566	3	section
segno	6	48	1474	3	segno_
segnos	7	36	1044	3	segnos
sego	5	65	2518	3	seg_o_
segos	6	49	1948	3	seg_os
senior	6	32	1405	3	senior
serin	5	54	3444	3	seri_n
sermon	8	4	1355	3	sermon
session	7	3	976	3	session
seton	5	52	2354	3	se_ton
sexton	13	36	1079	3	sexton
solion	6	6	1638	3	solion
talion	6	3	1771	3	talion
teflon	9	3	745	3	teflon
tegmen	9	8	840	3	tegmen
telson	6	3	1029	3	telson
tendon	7	3	1203	3	tendon
tenon	5	33	2051	3	te_non
tension	7	3	1180	3	tension
ternion	7	3	949	3	ternion
teston	6	3	1330	3	teston
tiglon	7	3	792	3	tiglon
tigon	6	39	1444	3	tig_on
trigon	7	45	1310	3	trigon
turion	6	3	1316	3	turion
union	5	45	1979	3	_union
vegan	9	51	1415	3	veg_an
vegie	9	46	1451	3	vegi_e
vegies	10	43	1427	3	vegies
vein	7	56	2575	3	ve_i_n
venin	8	51	1866	3	veni_n
venison	10	3	645	3	venison
version	10	3	1092	3	version
virion	9	3	1068	3	virion
vision	9	3	1131	3	vision
waggon	11	3	639	3	waggon
wagon	9	43	1295	3	wag_on
wanion	9	32	1306	3	wanion
weakon	13	35	762	3	weakon
weapon	11	28	811	3	weapon
weason	9	32	1082	3	weason
wigeon	10	3	722	3	wigeon
xenon	12	26	1245	3	xe_non
yogin	9	83	1774	3	yogi_n
zein	13	56	2060	3	ze_i_n

Search took 8 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	399	7.456	15117.5
3	Display Results	399	399	0.140	2850.0
	(SQL Overall)	178691	399	7.969	22423.3