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

Here are the results of your fuzzy-string dictionary search for “lexicons” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

56 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
lexicons	17	4	389	(None)
lexicon	16	4	390	1	lexicon_
flexions	18	4	441	2	flexi_ons
helicons	13	3	761	2	helicons
legions	8	46	1178	2	legi_ons
lesions	7	38	1387	2	lesi_ons
lyricons	13	4	358	2	lyricons
alencons	10	4	548	3	ale_ncons
alexins	14	19	1066	3	alexi__ns
axions	13	47	1348	3	_axi_ons
beacons	11	4	1073	3	be_acons
benisons	10	3	704	3	benisons
deacons	10	3	1039	3	de_acons
eikons	10	3	850	3	_e_ikons
epigons	10	4	818	3	_epigons
excitons	17	4	604	3	_excitons
exons	12	58	1334	3	_ex__ons
flexagons	20	4	167	3	flexagons
flexion	17	3	507	3	flexi_on_
fluxions	18	4	442	3	fluxi_ons
helicon	12	3	764	3	helicon_
hexagons	19	4	394	3	hexagons
icons	7	65	1649	3	___icons
lections	10	24	1384	3	lections
legion	7	57	1298	3	legi_on_
lemons	8	44	1505	3	le__mons
lenitions	9	3	947	3	lenitions
leptons	9	19	1043	3	le_ptons
lesion	6	47	1506	3	lesi_on_
lessons	7	38	1102	3	le_ssons
leucins	9	3	810	3	le_ucins
leukons	11	3	575	3	le_ukons
levins	9	45	1465	3	levi__ns
lewissons	12	4	174	3	lewissons
lexica	15	3	610	3	lexic__a
lexical	16	3	736	3	lexic_al
lexis	12	59	1603	3	lexi___s
liaisons	8	4	429	3	liaisons
limacons	12	4	395	3	limacons
lions	5	59	2321	3	l__i_ons
logions	8	62	1129	3	logi_ons
lotions	7	46	1476	3	loti_ons
lyricon	12	4	371	3	lyricon_
medicos	12	33	983	3	medico_s
neocons	9	3	691	3	ne_ocons
pelicans	12	3	809	3	pelicans
pemicans	14	4	704	3	pemicans
perigons	11	3	1008	3	perigons
recons	8	49	2299	3	re__cons
regions	8	36	1347	3	regi_ons
replicons	13	4	409	3	replicons
sericins	10	3	1246	3	sericins
sextons	14	37	1041	3	sex_tons
silicons	10	10	716	3	silicons
venisons	11	3	613	3	venisons
vidicons	14	4	386	3	vidicons

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	146162	0.406	440125.6
2	DLD Change Limit	146162	56	6.500	22486.5
3	Display Results	56	56	0.033	1697.0
	(SQL Overall)	178691	56	6.939	25751.7