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

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

64 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
compacters	18	24	702	(None)
compacter	17	25	788	1	compacter_
compactors	18	25	625	1	compactors
combaters	15	3	811	2	comba_ters
compacted	18	29	736	2	compacte_d
compactest	18	4	504	2	compactest
compactness	19	5	330	2	compactness
compactor	17	25	602	2	compactor_
compacts	16	36	890	2	compact__s
comparers	15	31	939	2	compa_rers
completers	16	29	832	2	completers
composters	16	38	832	2	composters
computers	15	33	975	2	comp_uters
impacters	15	30	548	2	_impacters
bombasters	16	4	371	3	bombasters
characters	17	4	550	3	characters
coachers	15	43	1230	3	co__achers
coactors	12	3	948	3	co__actors
coasters	10	43	1733	3	co__asters
coaters	9	35	2579	3	co__a_ters
cofactors	16	4	594	3	co_factors
comakers	16	33	917	3	com_a_kers
comates	11	41	2364	3	com_a_te_s
combater	14	3	938	3	comba_ter_
comforters	17	27	519	3	comforters
commanders	17	14	668	3	commanders
commenters	16	13	948	3	commenters
commuters	15	37	891	3	com_muters
compact	15	37	1221	3	compact___
compacting	19	17	709	3	compacting
compaction	18	4	675	3	compaction
compactions	19	4	654	3	compactions
compactly	20	4	382	3	compact_ly
compadres	16	26	641	3	compadre_s
companies	15	3	1180	3	companie_s
comparators	17	8	568	3	comparators
comparer	14	36	1136	3	compa_rer_
compares	14	38	1643	3	compa_re_s
comparted	16	33	842	3	comparte_d
comparts	14	42	1083	3	compart__s
compasses	15	4	739	3	compasse_s
compeers	14	34	1001	3	comp__eers
compellers	16	4	519	3	compellers
competes	14	41	1724	3	comp_ete_s
compilers	15	3	705	3	comp_ilers
complainers	17	4	447	3	complainers
completer	15	33	1041	3	completer_
completes	15	32	1292	3	complete_s
compliers	15	3	829	3	comp_liers
composers	15	39	1062	3	comp_osers
composter	15	36	956	3	composter_
compotes	14	47	1651	3	comp_ote_s
computer	14	45	1151	3	comp_uter_
computes	14	39	1455	3	comp_ute_s
concocters	13	4	675	3	concocters
connecters	14	4	801	3	connecters
contactees	14	13	599	3	contactees
contactors	14	4	884	3	contactors
copartners	14	4	357	3	co_partners
copastors	13	4	699	3	co_pastors
copters	11	36	2128	3	co_p__ters
impacter	14	29	657	3	_impacter_
impactors	15	26	501	3	_impactors
imparters	13	27	657	3	_imparters

Search took 6 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.410	435831.7
2	DLD Change Limit	140603	64	5.436	25865.2
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	5.876	30410.3