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

Here are the results of your fuzzy-string dictionary search for “compacting” 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
compacting	19	17	709	(None)
comparting	17	18	838	1	comparting
coacting	13	34	1270	2	co__acting
coenacting	15	4	587	2	coenacting
combating	16	3	1016	2	comba_ting
combatting	17	5	514	2	combatting
compaction	18	4	675	2	compaction
compactions	19	4	654	2	compactions
companying	20	4	481	2	companying
comparing	16	24	1058	2	compa_ring
compassing	17	4	655	2	compassing
competing	16	37	1246	2	comp_eting
complecting	20	4	576	2	complecting
completing	17	4	842	2	completing
comporting	17	19	916	2	comporting
composting	17	17	805	2	composting
compting	15	30	1360	2	comp__ting
computing	16	30	985	2	comp_uting
contacting	15	6	1007	2	contacting
impacting	16	3	594	2	_impacting
coaching	16	40	1196	3	co__aching
coapting	13	35	1161	3	co__apting
coasting	11	36	1551	3	co__asting
coating	10	35	2531	3	co__a_ting
coempting	16	3	607	3	coemp__ting
coerecting	15	21	878	3	coerecting
collating	12	3	1276	3	colla_ting
collecting	15	4	828	3	collecting
colocating	15	4	862	3	colocating
comaking	17	3	999	3	com_a_king
combusting	17	4	545	3	combusting
comforting	18	16	593	3	comforting
commanding	18	4	592	3	commanding
commenting	17	4	917	3	commenting
committing	17	4	668	3	committing
commuting	16	28	844	3	com_muting
compact	15	37	1221	3	compact___
compacted	18	29	736	3	compact_ed
compacter	17	25	788	3	compact_er
compacters	18	24	702	3	compacters
compactest	18	4	504	3	compactest
compactible	21	5	365	3	compactible
compactly	20	4	382	3	compact_ly
compactor	17	25	602	3	compact_or
compactors	18	25	625	3	compactors
compacts	16	36	890	3	compact__s
compeering	17	4	705	3	compeering
compelling	17	4	655	3	compelling
compering	16	34	1416	3	comp_ering
compiling	16	3	776	3	comp_iling
comping	14	35	1859	3	comp___ing
complaining	18	4	473	3	complaining
complexing	24	4	474	3	complexing
complicating	21	4	563	3	complicating
complotting	18	12	426	3	complotting
complying	19	3	611	3	comp_lying
composing	16	17	984	3	comp_osing
compositing	18	4	626	3	compositing
comprising	17	4	863	3	comprising
comprizing	26	4	746	3	comprizing
concocting	14	4	841	3	concocting
conducting	16	4	883	3	conducting
confecting	18	3	1055	3	confecting
connecting	15	3	1038	3	connecting
contracting	16	6	1047	3	contracting
convecting	18	3	1043	3	convecting
convicting	18	4	758	3	convicting
coopting	13	34	1131	3	coop__ting
coppicing	18	4	540	3	coppic_ing
correcting	15	19	930	3	correcting
imparting	14	3	724	3	_imparting
impasting	14	3	632	3	_impasting
nonacting	12	3	878	3	no_nacting
oompahing	17	7	317	3	oompa_hing
outacting	12	3	921	3	_outacting
ramparting	15	4	389	3	ramparting
tomcatting	15	4	243	3	tomcatting

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	140603	0.453	394461.4
2	DLD Change Limit	140603	77	6.500	21631.2
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.983	25589.4