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

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

77 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
convicting	18	4	758	(None)
convecting	18	3	1043	1	convecting
concocting	14	4	841	2	concocting
conducting	16	4	883	2	conducting
confecting	18	3	1055	2	confecting
conflicting	19	4	472	2	conflicting
connecting	15	3	1038	2	connecting
consisting	13	4	952	2	consisting
contacting	15	6	1007	2	contacting
conventing	16	3	1154	2	conventing
converting	16	3	1313	2	converting
conviction	17	4	818	2	conviction
convictions	18	4	804	2	convictions
convincing	18	4	534	2	convincing
reconvicting	20	11	462	2	reconvicting
coacting	13	34	1270	3	co__acting
coediting	13	3	833	3	coedi_ting
coenacting	15	4	587	3	coenacting
coerecting	15	21	878	3	coerecting
coexisting	20	4	440	3	coexisting
coinfecting	19	4	457	3	coinfecting
coinventing	17	4	454	3	coinventing
collecting	15	4	828	3	collecting
committing	17	4	668	3	committing
compacting	19	17	709	3	compacting
conceiting	15	3	1177	3	conceiting
concerting	15	3	1389	3	concerting
concreting	15	3	987	3	concreting
conducing	15	3	769	3	conduc_ing
confiding	16	3	833	3	confi_ding
confining	15	3	999	3	confi_ning
confirming	18	4	590	3	confirming
confiscating	20	5	361	3	confiscating
conflating	16	4	1000	3	conflating
confuting	15	3	909	3	con_futing
congesting	14	4	1011	3	congesting
conniving	15	3	709	3	conni_ving
connoting	12	3	1002	3	con_noting
consenting	13	3	1322	3	consenting
consigning	14	4	678	3	consigning
consorting	13	4	1074	3	consorting
constricting	17	4	702	3	constricting
consulting	13	4	908	3	consulting
contenting	13	3	1332	3	contenting
contesting	13	3	1221	3	contesting
continuing	13	4	819	3	continuing
contorting	13	4	1010	3	contorting
contracting	16	6	1047	3	contracting
convection	17	4	1112	3	convection
convections	18	4	1149	3	convections
convective	20	4	911	3	convective
convening	15	3	1119	3	conv_ening
converging	17	5	809	3	converging
conversing	16	3	1054	3	conversing
conveying	18	3	832	3	conv_eying
convict	14	34	1098	3	convict___
convicted	17	4	631	3	convict_ed
convicts	15	33	771	3	convict__s
convoking	19	3	574	3	conv_oking
convoluting	17	4	420	3	convoluting
convolving	19	4	441	3	convolving
convoying	18	3	598	3	conv_oying
convulsing	16	4	538	3	convulsing
coppicing	18	4	540	3	coppic_ing
cornicing	14	3	904	3	cornic_ing
correcting	15	19	930	3	correcting
coveting	14	19	1230	3	co_v_eting
cowriting	15	5	732	3	cowri_ting
evicting	14	3	748	3	__evicting
indicting	13	3	961	3	_indicting
inviting	12	3	973	3	_invi_ting
nonacting	12	3	878	3	non_acting
nonbiting	12	4	782	3	nonbi_ting
nonrioting	11	4	675	3	nonrioting
nonvoting	13	4	690	3	nonv_oting
obviating	15	4	505	3	_obviating
sonicating	13	4	831	3	son_icating

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	140603	0.406	440125.6
2	DLD Change Limit	140603	77	6.360	22107.4
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.796	26293.6