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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

146 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
midsections	16	4	440	(None)
midsection	15	4	443	1	midsection_
bisections	14	13	673	2	bi_sections
dissections	14	19	826	2	dissections
advections	16	4	555	3	_advections
bijections	21	13	493	3	bi_jections
bilections	14	13	650	3	bi_lections
bisection	13	13	698	3	bi_section_
directions	13	7	964	3	di_rections
dissection	13	15	861	3	dissection_
dissentions	12	16	804	3	dissentions
exsections	19	4	763	3	_exsections
ideations	10	3	990	3	_id_eations
infections	15	5	1023	3	_infections
injections	19	4	866	3	_injections
insertions	10	4	1034	3	_insertions
inspections	15	4	642	3	_inspections
misdirections	18	5	423	3	misdirections
resections	12	15	1303	3	_resections
sections	10	27	1470	3	___sections
subsections	15	9	710	3	subsections
trisections	13	4	564	3	trisections
vivisections	20	5	271	3	vivisections
abductions	15	12	538	4	abd_uctions
abjections	21	4	567	4	_abjections
addictions	14	12	536	4	_addictions
adductions	14	10	495	4	_adductions
advection	15	4	555	4	_advection_
affections	18	4	589	4	_affections
assertions	10	4	658	4	_assertions
bijection	20	13	479	4	bi_jection_
bilection	13	15	680	4	bi_lection_
bisecting	14	3	697	4	bi_secti_ng
bisectional	15	5	464	4	bi_sectional
bisectors	13	4	573	4	bi_sect_ors
bolections	14	13	729	4	_bolections
caseations	12	5	830	4	_caseations
codirections	17	4	470	4	codirections
collections	15	4	793	4	collections
confections	18	4	1139	4	confections
connections	15	4	1070	4	connections
consecutions	16	4	704	4	consecutions
convections	18	4	1149	4	convections
corrections	15	4	886	4	corrections
deductions	14	6	713	4	ded_uctions
defections	16	15	1020	4	_defections
deflections	17	18	732	4	deflections
dejections	20	16	835	4	_dejections
desertions	11	3	988	4	_desertions
detections	13	14	1004	4	_detections
dictions	11	18	1267	4	__d_ictions
digestions	12	4	640	4	di_gestions
direction	12	8	978	4	di_rection_
dissecting	14	13	947	4	dissecti_ng
dissectors	13	4	536	4	dissect_ors
dissensions	12	17	557	4	dissensions
dissention	11	18	807	4	dissention_
dissentious	12	18	447	4	dissentious
distentions	12	17	884	4	distentions
eductions	12	6	877	4	_ed_uctions
ejections	18	24	996	4	__ejections
elections	11	24	1497	4	__elections
erections	11	25	1521	4	__erections
evections	14	25	1069	4	__evections
exsection	18	4	749	4	_exsection_
exsertions	17	4	674	4	_exsertions
fictions	13	24	1074	4	fi___ctions
flections	14	23	921	4	__flections
ideation	9	3	1049	4	_id_eation_
impactions	16	4	541	4	_impactions
impletions	14	4	500	4	imple_tions
imprecations	18	4	627	4	imprecations
inactions	11	3	932	4	_i_nactions
inceptions	14	4	853	4	_inceptions
indentions	11	4	906	4	_indentions
indictions	13	3	931	4	_indictions
indirections	15	5	619	4	indirections
inductions	13	4	880	4	_inductions
infection	14	4	1047	4	_infection_
infectious	15	4	560	4	_infectious
inflections	16	4	699	4	inflections
ingestions	11	9	759	4	_ingestions
injection	18	3	865	4	_injection_
insertion	9	4	1059	4	_insertion_
inspection	14	4	666	4	_inspection_
intentions	10	4	1140	4	_intentions
inunctions	12	4	675	4	_inunctions
inventions	13	4	831	4	_inventions
lections	10	24	1384	4	___lections
lineations	10	3	954	4	li_neations
liposuctions	16	6	203	4	liposuctions
mediations	13	3	1098	4	med_iations
medications	16	4	993	4	medications
meditations	14	4	933	4	meditations
mentions	10	3	1289	4	m___entions
migrations	13	16	868	4	mi_grations
misacting	14	3	908	4	mi_sacti_ng
misbuttons	14	5	211	4	mi_sbuttons
miscaptions	17	4	418	4	miscaptions
miscoins	12	3	1108	4	mi_s_coi_ns
miscreations	16	4	706	4	miscreations
misdirection	17	5	416	4	misdirection_
miseating	12	12	1543	4	mi_seati_ng
miseducations	18	11	329	4	mi_seducations
misfunctions	19	5	371	4	misfunctions
mislocations	16	14	565	4	mislocations
misreckons	18	5	249	4	misrec_kons
misseating	13	13	1094	4	misseati_ng
missetting	13	10	790	4	missetti_ng
missions	10	3	1190	4	mi_s__sions
misunions	11	5	453	4	mi_s_unions
mitigations	14	4	762	4	mitigations
moderations	14	4	827	4	moderations
modulations	14	14	726	4	modulations
nidations	10	3	921	4	nid__ations
objections	21	4	563	4	_objections
perfections	18	4	814	4	perfections
persecutions	16	5	479	4	persecutions
prelections	15	12	1047	4	prelections
projections	22	5	847	4	projections
prosecutions	16	4	561	4	prosecutions
protections	15	5	1070	4	protections
redactions	13	5	913	4	red_actions
redirections	15	4	617	4	redirections
reductions	13	5	958	4	red_uctions
reelections	13	16	794	4	reelections
refections	15	18	1164	4	_refections
reflections	16	17	855	4	reflections
reinfections	17	4	532	4	reinfections
reinjections	21	4	440	4	reinjections
reinsertions	12	4	527	4	reinsertions
reinspections	17	5	309	4	reinspections
rejections	19	15	1010	4	_rejections
resection	11	16	1327	4	_resection_
section	9	25	1566	4	___section_
seductions	13	6	687	4	sed_uctions
selections	12	3	1087	4	_selections
subjections	22	9	635	4	subjections
subsection	14	9	678	4	subsection_
suctions	10	30	1290	4	___suctions
surjections	20	7	528	4	surjections
trajections	20	4	451	4	trajections
transections	14	4	676	4	transections
trisection	12	4	598	4	trisection_
venesections	17	5	293	4	venesections
vivisection	19	5	270	4	vivisection_

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	146	8.780	16949.8
3	Display Results	146	146	0.093	1569.9
	(SQL Overall)	178691	146	9.296	19222.4