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

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

43 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
fictioneers	16	5	268	(None)
fictioneer	15	5	312	1	fictioneer_
auctioneers	13	6	227	2	auctioneers
actioners	11	4	773	3	_action_ers
auctioneer	12	6	280	3	auctioneer_
electioneers	14	5	370	3	electioneers
fictioneering	19	6	175	3	fictioneering
fictioneerings	20	7	123	3	fictioneer~~ing~~s
fictionists	16	5	599	3	fictionists
fictionizes	25	5	411	3	fictionizes
fictions	13	24	1074	3	fiction___s
fictiveness	19	4	631	3	fictiveness
frictionless	17	5	255	3	frictionless
actioner	10	4	866	4	_action_er_
actionless	12	4	415	4	_actionless
cautioners	12	4	473	4	caution_ers
dictionary	16	5	459	4	diction_ary
dictions	11	18	1267	4	diction___s
electioneer	13	5	386	4	electioneer_
factions	13	30	1306	4	faction___s
fashioners	16	12	397	4	fashion_ers
fiction	12	20	1073	4	fiction____
fictional	14	7	780	4	fiction__al
fictionalise	17	5	626	4	fictionalise
fictionally	19	5	605	4	fictionally
fictionist	15	5	802	4	fiction_ist
fictionize	24	5	420	4	fiction_ize
fictionized	26	5	336	4	fictionized
fishmongers	20	5	198	4	fishmongers
frictions	14	4	803	4	friction___s
functionless	17	5	241	4	functionless
intoners	8	8	993	4	_int_on_ers
mentioners	12	4	534	4	mention_ers
missioners	12	4	585	4	mission_ers
motioners	11	4	658	4	_motion_ers
mutineers	11	4	463	4	_muti_neers
optionees	11	4	434	4	_optionee_s
pioneers	10	3	586	4	___pioneers
pistoleers	12	4	379	4	pist_oleers
portioners	12	5	742	4	portion_ers
stationers	10	4	476	4	station_ers
vacationers	16	5	248	4	vacation_ers
victimizers	27	5	204	4	victimizers

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	43	8.953	16622.2
3	Display Results	43	43	0.016	2687.5
	(SQL Overall)	178691	43	9.392	19025.9