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

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

68 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
bisection	13	13	698	(None)
bijection	20	13	479	1	bijection
bilection	13	15	680	1	bilection
bisections	14	13	673	1	bisections
bijections	21	13	493	2	bijections
bilections	14	13	650	2	bilections
bisecting	14	3	697	2	bisecting
bisectional	15	5	464	2	bisectional
bisector	12	4	519	2	bisect_or
bolection	13	11	767	2	bolection
direction	12	8	978	2	direction
dissection	13	15	861	2	dissection
exsection	18	4	749	2	exsection
midsection	15	4	443	2	midsection
resection	11	16	1327	2	resection
section	9	25	1566	2	__section
trisection	12	4	598	2	trisection
abjection	20	4	532	3	abjection
advection	15	4	555	3	advection
affection	17	4	589	3	affection
assertion	9	4	672	3	assertion
bastion	9	3	1247	3	bas__tion
bijective	23	4	391	3	bijective
bilocation	14	4	612	3	bilocation
bisect	10	3	1287	3	bisect___
bisected	13	3	620	3	bisect_ed
bisectors	13	4	573	3	bisectors
bisectrix	20	5	185	3	bisectrix
bisects	11	3	713	3	bisect__s
bolections	14	13	729	3	bolections
caseation	11	9	951	3	caseation
defection	15	16	1064	3	defection
dejection	19	17	866	3	dejection
desertion	10	4	1020	3	desertion
detection	12	13	1041	3	detection
diction	10	23	1305	3	di__ction
digestion	11	4	657	3	digestion
directions	13	7	964	3	directions
dissections	14	19	826	3	dissections
dissention	11	18	807	3	dissention
distention	11	15	888	3	distention
ejection	17	25	1004	3	_ejection
election	10	20	1535	3	_election
erection	10	21	1551	3	_erection
evection	13	19	1083	3	_evection
exsections	19	4	763	3	exsections
exsertion	16	4	685	3	exsertion
fiction	12	20	1073	3	fi__ction
flection	13	23	956	3	_flection
ideation	9	3	1049	3	_ideation
inaction	10	3	962	3	_inaction
infection	14	4	1047	3	infection
injection	18	3	865	3	injection
insertion	9	4	1059	3	insertion
inspection	14	4	666	3	inspection
lection	9	26	1486	3	__lection
lineation	9	3	1076	3	lineation
midsections	16	4	440	3	midsections
objection	20	4	509	3	objection
refection	14	15	1228	3	refection
rejection	18	17	1025	3	rejection
resections	12	15	1303	3	resections
sections	10	27	1470	3	__sections
selection	11	3	1127	3	selection
subsection	14	9	678	3	subsection
suction	9	37	1304	3	__suction
trisections	13	4	564	3	trisections
vivisection	19	5	270	3	vivisection

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	148641	0.423	422437.4
2	DLD Change Limit	148641	68	7.453	19943.8
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	7.906	22601.9