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

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

63 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
concocter	12	4	763	(None)
concocted	13	4	677	1	concocted
concocters	13	4	676	1	concocters
concoctor	12	4	632	1	concoctor
concenter	13	3	1221	2	concenter
concoct	10	3	1290	2	concoct__
concoctors	13	4	641	2	concoctors
concocts	11	3	863	2	concoct_s
connecter	13	4	905	2	connecter
boycotter	16	4	207	3	boycotter
cocotte	11	3	860	3	co_cotte_
cocottes	12	3	831	3	co_cottes
comforter	16	25	598	3	comforter
compacter	17	25	788	3	compacter
composter	15	36	957	3	composter
concealer	13	6	822	3	concealer
conceder	13	3	874	3	conc_eder
conceited	14	3	1042	3	conceited
conceiver	16	5	741	3	conceiver
concenters	14	4	1059	3	concenters
concerted	14	3	1211	3	concerted
conciser	12	3	1024	3	conc_iser
concluder	14	4	418	3	concluder
concocting	14	4	841	3	concocting
concoction	13	4	823	3	concoction
concoctive	16	4	680	3	concoctive
concrete	12	4	1108	3	concrete_
concreted	14	3	941	3	concreted
concretes	13	4	1147	3	concretes
condoler	11	34	1212	3	condo_ler
condoner	11	29	1341	3	condo_ner
conducer	13	12	737	3	conduc_er
conducted	15	4	731	3	conducted
conductor	14	4	721	3	conductor
confected	17	3	907	3	confected
conformer	16	6	746	3	conformer
confronter	15	4	436	3	confronter
confuter	13	3	851	3	con_futer
conjoiner	18	5	593	3	conjoiner
connected	14	3	875	3	connected
connecters	14	4	802	3	connecters
connector	13	4	792	3	connector
connote	9	3	1161	3	conno_te_
connoted	11	3	886	3	conno_ted
connotes	10	3	1145	3	conno_tes
consenter	11	3	1249	3	consenter
consoler	10	28	1261	3	conso_ler
consorted	12	3	977	3	consorted
consulter	11	9	822	3	consulter
contacted	14	13	910	3	contacted
contactee	13	14	931	3	contactee
contactor	13	4	843	3	contactor
contester	11	3	1119	3	contester
contorted	12	3	948	3	contorted
convected	17	3	878	3	convected
convector	16	4	808	3	convector
converter	14	3	1101	3	converter
convicted	17	4	632	3	convicted
convoker	17	22	690	3	convo_ker
cooter	8	51	2861	3	co__o_ter
correcter	13	4	811	3	correcter
nondoctor	12	4	517	3	nondoctor
nonvoter	11	8	689	3	nonvo_ter

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.420	425454.8
2	DLD Change Limit	148641	63	7.220	20587.4
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	7.673	23288.3