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

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

65 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
dissections	14	19	826	(None)
dissection	13	15	861	1	dissection_
dissentions	12	16	804	1	dissentions
bisections	14	13	673	2	bi_sections
directions	13	7	964	2	di_rections
dissecting	14	13	947	2	dissecti_ng
dissectors	13	4	536	2	dissect_ors
dissensions	12	17	557	2	dissensions
dissention	11	18	807	2	dissention_
dissentious	12	18	447	2	dissentious
distentions	12	17	884	2	distentions
midsections	16	4	440	2	midsections
assertions	10	4	658	3	_assertions
bijections	21	13	493	3	bi_jections
bilections	14	13	650	3	bi_lections
bisection	13	13	698	3	bi_section_
defections	16	15	1020	3	d_efections
deflections	17	18	732	3	deflections
dejections	20	16	835	3	d_ejections
desertions	11	3	988	3	d_esertions
detections	13	14	1004	3	d_etections
dictions	11	18	1267	3	di___ctions
digestions	12	4	640	3	di_gestions
direction	12	8	978	3	di_rection_
disaffections	22	5	304	3	disaffections
discretions	14	4	722	3	discretions
disfunctions	18	5	452	3	disfunctions
disinfections	19	5	488	3	disinfections
disjecting	21	7	724	3	disjecti_ng
disjunctions	22	5	407	3	disjunctions
dislocations	15	13	698	3	dislocations
dispersions	14	4	645	3	dispersions
disrelations	13	4	850	3	disrelations
disruptions	14	12	568	3	disruptions
disseating	12	11	1178	3	disseati_ng
dissector	12	4	552	3	dissect_o_r
dissects	11	27	924	3	dissect___s
disseisins	11	4	595	3	disseisi_ns
disseizins	20	4	454	3	disseizi_ns
dissension	11	13	572	3	dissension_
dissentient	12	5	695	3	dissentient
dissentients	13	5	422	3	dissentients
dissenting	12	13	1029	3	dissenti_ng
dissertations	14	6	589	3	dissertations
disserting	12	13	1085	3	disserti_ng
dissipations	15	4	653	3	dissipations
dissociations	16	5	601	3	dissociations
dissolutions	13	14	492	3	dissolutions
dissuasions	12	4	352	3	dissuasions
distensions	12	14	627	3	distensions
distention	11	15	887	3	distention_
distinctions	15	5	732	3	distinctions
distortions	12	4	661	3	distortions
distractions	15	4	875	3	distractions
exsections	19	4	763	3	_exsections
infections	15	5	1023	3	_infections
injections	19	4	866	3	_injections
insertions	10	4	1034	3	_insertions
inspections	15	4	642	3	inspections
midsection	15	4	443	3	midsection_
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

Search took 6 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	121633	0.390	458182.1
2	DLD Change Limit	121633	65	4.970	24473.4
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	5.390	33152.3