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

Here are the results of your fuzzy-string dictionary search for “counterreforms” with Change Limit: [1] [2] [3] [4] [5] [6]

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.

53 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
counterreforms	21	6	217	(None)
counterreform	20	6	258	1	counterreform_
counterreformer	22	7	162	2	counterreformer
counterefforts	22	8	205	3	counterefforts
countertenors	15	5	406	3	countertenor_s
countereffort	21	8	284	4	countereffor_t
counterfires	17	4	706	4	counte_r_fires
counterfoils	17	5	539	4	counte_r_foils
counterforce	19	8	579	4	counte_r_force
counterforces	20	8	555	4	counte_r_forces
countermemos	18	5	443	4	countermemo__s
counteroffers	21	5	326	4	counteroffer_s
countertenor	14	5	475	4	countertenor__
counterterrors	16	6	248	4	counterterrors
conferrers	15	4	645	5	co_nferre__r_s
counterblows	19	5	421	5	counte_rblo_ws
counterclaims	19	5	444	5	counte_rclaims
countercoups	18	5	460	5	counte_r_coups
counterdemands	20	6	239	5	counterdemands
counterfeiters	19	10	374	5	counterfeiters
counterfeits	17	5	621	5	counte_r_feits
counterfire	16	4	700	5	counte_r_fir_e
counterflows	20	5	435	5	counte_r_flows
counterfoil	16	5	520	5	counte_r_fo_il
counterions	13	4	982	5	counte_r_io_ns
countermeasures	19	12	229	5	countermeasures
countermelodies	20	9	216	5	countermelodies
countermelody	21	6	265	5	countermelo_dy
countermemo	17	5	472	5	counterme___mo
countermoves	19	5	601	5	counte_r_moves
counteroffer	20	5	411	5	counteroffer__
counterorders	16	5	447	5	counterorder_s
counterparts	16	4	671	5	counte_r_parts
counterplots	16	10	623	5	counte_rplo_ts
counterploys	19	9	535	5	counte_rplo_ys
counterposes	16	4	762	5	counte_r_poses
counterpowers	20	6	482	5	counterpower_s
counterraids	15	5	660	5	counterr__aids
counterrallies	16	8	395	5	counterrallies
counterresponse	19	6	176	5	counterresponse
countershots	17	5	593	5	counte_rsho_ts
counterstreams	18	10	280	5	counterstreams
counterstrokes	20	6	462	5	counterstrokes
counterterror	15	6	255	5	counterte_rror
countertops	15	4	635	5	counte_r_to_ps
countertrends	16	7	435	5	countertre__nds
counterweights	23	7	253	5	counterweights
counterworld	18	5	422	5	counte_r_world
counterworlds	19	5	346	5	counte_r_worlds
cuneiforms	17	11	223	5	c_un_e__iforms
outperforms	18	12	168	5	_ou_tper_forms
terraforms	15	5	258	5	____terraforms
underreports	15	7	177	5	__underreports

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	95024	0.360	496363.9
2	DLD Change Limit	95024	53	7.513	12647.9
3	Display Results	53	53	0.033	1606.1
	(SQL Overall)	178691	53	7.906	22601.9