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

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

87 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
concocted	13	4	676	(None)
concocter	12	4	762	1	concocter
conceited	14	3	1042	2	conceited
concerted	14	3	1211	2	concerted
concoct	10	3	1290	2	concoct__
concocters	13	4	675	2	concocters
concoctor	12	4	631	2	concoctor
concocts	11	3	863	2	concoct_s
concreted	14	3	941	2	concreted
conducted	15	4	730	2	conducted
confected	17	3	907	2	confected
connected	14	3	875	2	connected
connoted	11	3	886	2	conno_ted
consorted	12	3	977	2	consorted
contacted	14	13	909	2	contacted
contorted	12	3	947	2	contorted
convected	17	3	878	2	convected
convicted	17	4	631	2	convicted
boycotted	17	4	203	3	boycotted
coacted	12	36	1160	3	co__acted
cocooned	13	3	729	3	co_cooned
cocotte	11	3	860	3	co_cotte_
cocottes	12	3	830	3	co_cottes
coenacted	14	4	580	3	coenacted
coerected	14	4	764	3	coerected
cohosted	14	3	613	3	co_hosted
coinfected	18	4	382	3	coinfected
coldcocked	19	5	130	3	coldcocked
collected	14	4	796	3	collected
collocated	15	4	616	3	collocated
colocated	14	3	961	3	colocated
comforted	17	31	596	3	comforted
compacted	18	29	736	3	compacted
comported	16	31	953	3	comported
composted	16	37	881	3	composted
concaved	16	3	622	3	conc_aved
concealed	14	5	812	3	concealed
conceded	14	3	828	3	conc_eded
conceived	17	4	671	3	conceived
concenter	13	3	1221	3	concenter
concerned	14	3	864	3	concerned
concluded	15	4	402	3	concluded
concocting	14	4	841	3	concocting
concoction	13	4	823	3	concoction
concoctive	16	4	679	3	concoctive
concoctors	13	4	639	3	concoctors
concord	12	5	1034	3	conco__rd
concrete	12	4	1108	3	concrete_
concretes	13	4	1147	3	concretes
concurred	14	4	566	3	concurred
concussed	14	4	475	3	concussed
condoled	12	31	1071	3	condo_led
condoned	12	26	1202	3	condo_ned
conduced	14	13	695	3	conduc_ed
conflated	15	3	933	3	conflated
conflicted	18	4	405	3	conflicted
conformed	17	6	746	3	conformed
confronted	16	4	419	3	confronted
confuted	14	3	767	3	con_futed
congested	13	3	867	3	congested
conjoined	19	6	546	3	conjoined
connecter	13	4	905	3	connecter
connote	9	3	1161	3	conno_te_
connotes	10	3	1145	3	conno_tes
consented	12	3	1194	3	consented
consisted	12	3	850	3	consisted
consociated	16	4	521	3	consociated
consoled	11	29	1144	3	conso_led
consulted	12	7	792	3	consulted
contactee	13	14	931	3	contactee
contented	12	3	1304	3	contented
contested	12	3	1069	3	contested
contoured	12	3	729	3	contoured
contracted	15	4	981	3	contracted
convented	15	4	1075	3	convented
converted	15	3	1156	3	converted
convoked	18	23	616	3	convo_ked
convoluted	16	4	370	3	convoluted
convolved	18	4	408	3	convolved
convoyed	17	22	555	3	convo_yed
coopted	12	37	1076	3	co__opted
coplotted	14	4	479	3	coplotted
corrected	14	3	811	3	corrected
decocted	14	3	768	3	_decocted
monocled	13	3	710	3	mon_ocled
uncoated	11	3	1496	3	_uncoated
uncocked	17	24	875	3	_uncocked

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	148641	0.236	757165.3
2	DLD Change Limit	148641	87	8.763	16962.3
3	Display Results	87	87	0.033	2636.4
	(SQL Overall)	178691	87	9.032	19784.2