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

Here are the results of your fuzzy-string dictionary search for “bilection” 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
bilection	13	15	680	(None)
bijection	20	13	479	1	bijection
bilections	14	13	650	1	bilections
bisection	13	13	698	1	bisection
bolection	13	11	767	1	bolection
bijections	21	13	493	2	bijections
bilocation	14	4	612	2	bilocation
bisections	14	13	673	2	bisections
bolections	14	13	729	2	bolections
direction	12	8	977	2	direction
election	10	20	1535	2	_election
flection	13	23	956	2	_flection
lection	9	26	1486	2	__lection
selection	11	3	1127	2	selection
abjection	20	4	532	3	abjection
advection	15	4	555	3	advection
affection	17	4	589	3	affection
bijective	23	4	391	3	bijective
billion	9	22	1217	3	bil__lion
bilocations	15	4	529	3	bilocations
bisecting	14	3	697	3	bisecting
bisectional	15	5	463	3	bisectional
bisector	12	4	519	3	bisect_or
ciliation	11	11	1249	3	ciliation
collection	14	4	820	3	collection
defection	15	16	1064	3	defection
deflection	16	14	773	3	deflection
dejection	19	17	866	3	dejection
deletion	9	20	1197	3	dele_tion
detection	12	13	1041	3	detection
diction	10	23	1305	3	di__ction
digestion	11	4	657	3	digestion
dilation	9	22	1546	3	dil_ation
dilution	9	23	914	3	dil_ution
directions	13	7	963	3	directions
dissection	13	15	861	3	dissection
ejection	17	25	1004	3	_ejection
elections	11	24	1497	3	_elections
electron	10	26	1141	3	_electron
erection	10	21	1551	3	_erection
evection	13	19	1083	3	_evection
exsection	18	4	749	3	exsection
fiction	12	20	1073	3	fi__ction
filiation	12	11	1024	3	filiation
flections	14	23	921	3	_flections
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	inflection
injection	18	3	865	3	injection
lectin	8	25	1501	3	__lecti_n
lections	10	24	1384	3	__lections
lineation	9	3	1076	3	lineation
midsection	15	4	442	3	midsection
objection	20	4	509	3	objection
plectron	12	22	802	3	_plectron
prelection	14	15	1129	3	prelection
reelection	12	19	863	3	reelection
refection	14	15	1228	3	refection
reflection	15	16	899	3	reflection
rejection	18	17	1025	3	rejection
reliction	11	3	1069	3	reliction
resection	11	16	1327	3	resection
section	9	25	1566	3	__section
selections	12	3	1087	3	selections
siltation	9	3	921	3	siltation
trisection	12	4	598	3	trisection

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	148641	0.156	1145455.1
2	DLD Change Limit	148641	68	6.513	22822.2
3	Display Results	68	68	0.033	2060.6
	(SQL Overall)	178691	68	6.702	26662.3