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

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

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.

69 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
fictionists	16	5	599	(None)
fictionist	15	5	802	1	fictionist_
fictionizes	25	5	410	2	fictionizes
fictionalises	18	5	583	3	fictionalises
fictioneers	16	5	268	3	fictioneers
fictionize	24	5	420	3	fictioni_ze
fictionized	26	5	336	3	fictionized
fictions	13	24	1074	3	fiction___s
fusionists	13	5	447	3	f_usionists
vacationists	17	5	458	3	vacationists
abortionists	14	5	497	4	abortionists
actinisms	13	9	888	4	_acti_nisms
activists	14	9	704	4	_acti_vists
adoptionists	15	5	392	4	adoptionists
bibliotists	15	5	286	4	bibliotists
canonists	11	5	851	4	__canonists
cartoonists	13	8	440	4	cartoonists
colonists	11	25	1250	4	__colonists
creationists	14	7	662	4	creationists
declinists	13	4	436	4	decli_nists
deviationists	17	10	474	4	deviationists
diclinisms	15	4	403	4	dicli_nisms
dictions	11	18	1267	4	diction___s
disunionists	13	5	287	4	disunionists
divisionists	16	5	327	4	divisionists
educationists	16	5	434	4	educationists
elocutionists	15	5	431	4	elocutionists
factionalisms	20	10	636	4	factionalisms
factions	13	30	1306	4	faction___s
factualists	16	5	352	4	factualists
fashionista	17	6	193	4	fashionista
fashionistas	18	7	116	4	fashionistas
feminists	14	22	762	4	f_emi_nists
fetishists	16	5	230	4	f_etishists
fiction	12	20	1073	4	fiction____
fictional	14	7	779	4	fiction__al
fictionalise	17	5	626	4	fictionalis_e
fictionalised	19	6	429	4	fictionalised
fictionality	20	5	461	4	fictionality
fictionalizes	27	7	488	4	fictionalizes
fictionally	19	5	605	4	fictionally
fictioneer	15	5	312	4	fiction_eer
fictionizing	27	5	380	4	fictionizing
fictitious	15	5	309	4	ficti_tious
fictiveness	19	4	631	4	fictivenes_s
frictionless	17	5	255	4	frictionless
frictions	14	4	803	4	friction___s
functionalists	19	6	436	4	functionalists
fusionisms	15	4	399	4	f_usionisms
fusionist	12	4	607	4	f_usionist_
inflationists	16	5	384	4	inflationists
internists	10	4	1024	4	_internists
intimists	11	4	749	4	_inti_mists
ironists	8	3	929	4	_i__ronists
machinists	17	4	531	4	machi_nists
metafictionists	22	9	181	4	~~meta~~fictionists
perfectionists	21	6	401	4	~~per~~fectionists
receptionists	17	5	477	4	receptionists
reductionists	16	5	465	4	reductionists
reunionists	11	5	456	4	reunionists
routinists	10	4	609	4	routi_nists
sciolists	11	4	721	4	_sc_iolists
selectionists	15	5	602	4	selectionists
simonists	11	4	676	4	si__monists
tectonisms	14	4	557	4	tect_onisms
unionists	9	4	621	4	__unionists
vacationist	16	5	590	4	vacationist_
victimises	17	7	409	4	victi_mises
violinists	13	4	444	4	violi_nists

Search took 9 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.156	1145455.1
2	DLD Change Limit	148819	69	8.766	16976.8
3	Display Results	69	69	0.033	2090.9
	(SQL Overall)	178691	69	8.955	19954.3