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

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

291 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
lection	9	26	1486	(None)
election	10	20	1535	1	election
flection	13	23	956	1	flection
lectin	8	25	1501	1	lecti_n
lections	10	24	1384	1	lections
section	9	25	1566	1	section
action	8	47	1968	2	_action
auction	9	34	1293	2	auction
bilection	13	15	680	2	bilection
bolection	13	11	767	2	bolection
diction	10	23	1305	2	diction
ejection	17	25	1004	2	ejection
elation	7	36	2045	2	elation
elections	11	24	1497	2	elections
electron	10	26	1141	2	electron
elution	7	29	1382	2	elution
erection	10	21	1551	2	erection
evection	13	19	1083	2	evection
faction	12	26	1333	2	faction
fiction	12	20	1073	2	fiction
flections	14	23	921	2	flections
lectern	9	3	703	2	lectern
lectins	9	25	1500	2	lectins
lector	8	35	1498	2	lect_or
legation	9	24	1293	2	legation
legion	7	57	1298	2	le_gion
lenition	8	3	1008	2	lenition
leptin	8	25	1233	2	lepti_n
lepton	8	25	1080	2	lept_on
lesion	6	47	1506	2	le_sion
location	10	21	1391	2	location
locution	10	22	766	2	locution
lotion	6	57	1652	2	l_otion
mention	9	3	1437	2	mention
paction	11	27	1396	2	paction
pectin	10	26	1553	2	pecti_n
plectron	12	22	802	2	plectron
reaction	10	6	1260	2	reaction
ruction	9	36	1161	2	ruction
sections	10	27	1470	2	sections
selection	11	3	1127	2	selection
suction	9	37	1304	2	suction
taction	9	32	1302	2	taction
unction	9	3	1066	2	unction
abjection	20	4	532	3	abjection
acetin	8	3	1469	3	aceti_n
actin	7	49	2255	3	_acti_n
actinon	9	45	946	3	_actinon
actions	9	42	1851	3	_actions
advection	15	4	555	3	advection
aeration	8	3	1993	3	aeration
affection	17	4	589	3	affection
alation	7	29	2055	3	alation
amotion	9	7	1047	3	amotion
auctions	10	40	1214	3	auctions
bastion	9	3	1247	3	bastion
beckon	14	30	938	3	bec_kon
benthon	12	3	769	3	benthon
beton	7	60	2206	3	be_t_on
bijection	20	13	479	3	bijection
bilections	14	13	650	3	bilections
bisection	13	13	698	3	bisection
bolections	14	13	729	3	bolections
caption	11	35	1369	3	caption
cation	8	39	2550	3	_cation
caution	9	30	1352	3	caution
cession	9	3	981	3	cession
cion	6	133	3091	3	__c_ion
coaction	12	3	1077	3	coaction
coition	9	3	1431	3	coition
collection	14	4	820	3	~~col~~lection
creation	10	28	1651	3	creation
decagon	11	3	586	3	decagon
deception	14	4	832	3	deception
decision	11	4	852	3	decision
decoction	14	4	752	3	decoction
decurion	11	4	662	3	decurion
deduction	13	7	708	3	deduction
defection	15	16	1064	3	defection
deflection	16	14	773	3	~~def~~lection
dejection	19	17	866	3	dejection
delation	9	23	1808	3	delation
deletion	9	20	1197	3	deletion
demotion	11	6	907	3	demotion
dentin	7	39	1957	3	denti_n
depiction	14	3	727	3	depiction
detection	12	13	1041	3	detection
devotion	12	5	676	3	devotion
dictions	11	18	1267	3	dictions
direction	12	8	978	3	direction
edition	8	3	1085	3	edition
eduction	11	6	905	3	eduction
egestion	9	4	686	3	egestion
ejections	18	24	996	3	ejections
elations	8	37	1912	3	elations
electing	11	21	1378	3	electing
elective	13	3	1100	3	elective
elector	9	33	1325	3	elect_or
electro	9	28	1003	3	electro_
electrons	11	24	1175	3	electrons
electros	10	28	1174	3	electros
elevation	12	3	923	3	elevation
elision	7	23	1110	3	elision
elocution	11	4	567	3	elocution
elusion	7	23	1095	3	elusion
elutions	8	25	1305	3	elutions
elytron	10	4	546	3	elytron
emotion	9	7	1130	3	emotion
enation	7	34	1923	3	enation
erections	11	25	1521	3	erections
ethion	9	3	881	3	_ethion
evections	14	25	1069	3	evections
eviction	13	22	868	3	eviction
exaction	17	3	895	3	exaction
exciton	16	4	608	3	exciton
execution	18	4	630	3	execution
exertion	15	3	1008	3	exertion
exsection	18	4	749	3	exsection
factions	13	30	1306	3	factions
fenthion	14	4	461	3	fenthion
fermion	12	3	676	3	fermion
festoon	10	3	767	3	festoon
fetation	11	6	1314	3	fetation
fictions	13	24	1074	3	fictions
flexion	17	3	507	3	fle_xion
fraction	13	5	948	3	fraction
friction	13	4	791	3	friction
function	13	3	784	3	function
gelation	9	30	1443	3	gelation
gentian	8	3	1010	3	gentian
hectic	13	23	1152	3	hecti_c
hector	11	33	1265	3	hect_or
hellion	10	3	1113	3	hellion
ideation	9	3	1049	3	ideation
illation	8	3	1194	3	illation
inaction	10	3	962	3	inaction
infection	14	4	1047	3	infection
inflection	15	4	763	3	~~inf~~lection
injection	18	3	865	3	injection
jeton	12	48	1540	3	je_t_on
jettison	15	4	250	3	jettison
jetton	13	3	803	3	je_tton
junction	17	3	620	3	junction
kation	10	43	1568	3	_kation
lactation	11	3	1081	3	lactation
lactean	9	5	647	3	lactean
lactic	10	7	1349	3	lacti_c
lactone	9	3	1139	3	lact_one
lampion	11	27	830	3	lampion
latino	6	41	2047	3	l_atino
lattin	6	43	1622	3	latti_n
lavation	11	3	997	3	lavation
laxation	15	3	842	3	laxation
leching	13	46	1365	3	leching
lecithin	13	4	431	3	lecithin
lecterns	10	3	594	3	lecterns
lectionary	15	5	482	3	lection~~ary~~
lectors	9	34	1576	3	lectors
lecture	9	14	951	3	lecture
lefties	10	3	1207	3	lefties
leftish	13	19	725	3	leftish
leftism	12	22	609	3	leftism
leftist	10	27	935	3	leftist
legations	10	27	1192	3	legations
leggin	8	26	859	3	leggi_n
legions	8	46	1178	3	le_gions
lemon	7	56	1818	3	le__mon
lenitions	9	3	947	3	lenitions
lenten	6	3	1288	3	lent_en
lentic	8	35	1574	3	lenti_c
lentigo	8	4	606	3	lentigo
lentil	6	43	1539	3	lenti_l
lentils	7	39	1297	3	lentils
lentisk	11	3	606	3	lentisk
lento	5	72	2339	3	lent_o_
lentoid	8	3	1068	3	lentoid
lentos	6	53	1740	3	lent_os
leptins	9	24	1269	3	leptins
leptons	9	19	1043	3	lept_ons
lesbian	9	4	446	3	lesbian
lesions	7	38	1387	3	le_sions
lesson	6	44	1204	3	le_sson
letdown	11	4	426	3	le_tdown
letting	8	32	1853	3	letting
leucin	8	3	911	3	leuci_n
leukon	10	3	614	3	le_ukon
levin	8	48	1641	3	le_vi_n
lexicon	16	4	390	3	lexicon
libation	10	24	1136	3	libation
lictor	8	36	1085	3	lict_or
ligation	9	23	1309	3	ligation
lineation	9	3	1076	3	lineation
lion	4	63	3444	3	l___ion
lobation	10	21	1055	3	lobation
locations	11	25	1274	3	locations
locutions	11	20	706	3	locutions
logion	7	60	1372	3	l_ogion
lotions	7	46	1476	3	l_otions
lunation	8	3	1192	3	lunation
luxation	15	3	823	3	luxation
melton	8	3	1155	3	melt_on
mentions	10	3	1289	3	mentions
mestino	9	4	1164	3	mestino
motion	8	52	1755	3	_motion
nation	6	43	2280	3	_nation
negation	9	29	1302	3	negation
nekton	10	3	658	3	nekt_on
neutron	7	3	776	3	neutron
newton	9	3	698	3	newt_on
notion	6	45	1658	3	_notion
objection	20	4	509	3	objection
olfaction	14	6	423	3	olfaction
option	8	36	1271	3	_option
oration	7	16	1771	3	oration
ovation	10	15	1002	3	ovation
pactions	12	26	1350	3	pactions
pecten	10	27	1110	3	pect_en
pectic	12	29	1387	3	pecti_c
pectins	11	23	1523	3	pectins
pectize	20	25	991	3	pectize
pension	9	4	1220	3	pension
pereion	9	3	1205	3	pereion
petition	10	7	1175	3	petition
placation	13	3	977	3	placation
plectrons	13	25	807	3	plectrons
plication	13	3	1168	3	plication
portion	9	6	1549	3	portion
potion	8	45	1957	3	_potion
prelection	14	15	1129	3	~~pre~~lection
question	17	4	582	3	question
ration	6	42	2601	3	_ration
reactions	11	7	1171	3	reactions
recaution	11	4	809	3	recaution
reception	13	4	1032	3	reception
recision	10	3	1027	3	recision
reckon	12	30	1054	3	rec_kon
recoin	8	43	2029	3	recoi_n
recon	7	56	2424	3	rec__on
recti	7	36	1962	3	recti__
rectify	15	3	645	3	rectify
recto	7	45	2080	3	rect_o_
rector	8	40	1975	3	rect_or
rectos	8	57	1878	3	rect_os
redaction	12	5	966	3	redaction
reduction	12	5	990	3	reduction
reelection	12	19	863	3	~~ree~~lection
refection	14	15	1228	3	refection
reflection	15	16	899	3	~~ref~~lection
region	7	46	1490	3	re_gion
rejection	18	17	1025	3	rejection
relation	8	26	1977	3	relation
reliction	11	3	1069	3	reliction
remotion	10	4	1023	3	remotion
resection	11	16	1327	3	resection
reunion	7	3	767	3	reunion
ructions	10	28	1168	3	ructions
sanction	10	4	953	3	sanction
scion	7	22	1499	3	_sc_ion
secretion	11	11	830	3	secretion
sectile	9	3	1197	3	sectile
sectional	11	4	942	3	sectional
sectioned	12	4	652	3	sectioned
sector	8	34	1593	3	sect_or
sedation	9	3	1245	3	sedation
sedition	9	3	933	3	sedition
seduction	12	6	698	3	seduction
selections	12	3	1087	3	selections
session	7	3	976	3	session
seton	5	52	2354	3	se_t_on
sexton	13	36	1079	3	sext_on
station	7	27	1724	3	station
stiction	10	3	882	3	stiction
suctions	10	30	1290	3	suctions
tactions	10	29	1242	3	tactions
tectite	9	3	1058	3	tectite
tension	7	3	1180	3	tension
ternion	7	3	949	3	ternion
tertian	7	5	1119	3	tertian
teston	6	3	1330	3	test_on
testoon	7	4	837	3	testoon
traction	10	4	1268	3	traction
tuition	7	3	882	3	tuition
unctions	10	3	973	3	unctions
vacation	13	19	1189	3	vacation
vector	11	32	1206	3	vect_or
venation	11	5	1350	3	venation
version	10	3	1092	3	version
vexation	18	3	878	3	vexation
vocation	13	23	1198	3	vocation
zeatin	15	4	1282	3	zeati_n
zechin	20	13	770	3	zechi_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	134027	0.406	440125.6
2	DLD Change Limit	134027	291	6.470	20715.1
3	Display Results	291	291	0.106	2745.3
	(SQL Overall)	178691	291	6.982	25593.1