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

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

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.

55 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
consolidate	14	6	379	(None)
consolidated	16	6	331	1	consolidated
consolidates	15	6	386	1	consolidates
consociate	14	4	685	2	consoci_ate
consolidator	15	5	328	2	consolidator
reconsolidate	16	12	229	2	reconsolidate
conciliate	14	4	752	3	concili_ate
consociated	16	4	521	3	consoci_ated
consociates	15	4	654	3	consoci_ates
consolidating	17	5	328	3	consolidating
consolidation	16	5	515	3	consolidation
consolidators	16	5	329	3	consolidators
constipate	14	4	639	3	cons_tipate
consulate	11	6	1223	3	consul__ate
reconsolidated	18	13	213	3	reconsolidated
reconsolidates	17	12	222	3	reconsolidates
unconsolidated	18	6	203	3	unconsolidated
candidate	13	5	666	4	can__didate
catholicate	18	7	369	4	catholicate
colligate	12	4	829	4	co__lligate
collimate	13	4	817	4	co__llimate
complicate	18	4	762	4	co_mplicate
conciliated	16	4	564	4	concili_ated
conciliates	15	4	688	4	concili_ates
concordat	14	4	635	4	conco_rdat_
concordats	15	4	419	4	conco_rdats
conduplicate	19	5	261	4	conduplicate
confidante	16	4	488	4	con__fidante
conflate	13	3	1117	4	con_fl__ate
conglobate	15	6	365	4	con_globate
conoidal	11	4	901	4	con_o_ida_l
consecrate	14	4	843	4	cons_ecrate
considerate	14	5	547	4	considerate
console	9	27	1598	4	consol____e
consoled	11	29	1145	4	consoled___
consolidations	17	5	474	4	consolidat~~ion~~s
consoling	12	3	1087	4	consoli__ng
consolingly	17	5	308	4	consolingly
constellate	13	11	456	4	constellate
consternate	13	5	512	4	consternate
constipated	16	4	546	4	cons_tipated
constipates	15	4	635	4	cons_tipates
constitute	12	7	670	4	cons_titute
consulates	12	7	1110	4	consul__ates
consummate	16	5	426	4	cons_ummate
contaminate	15	5	657	4	contaminate
convolute	14	4	494	4	convol__ute
coprolite	13	4	862	4	coproli__te
corollate	11	4	812	4	co_rol_late
cuspidate	14	4	357	4	c_us_pidate
insolate	8	3	1189	4	_insol__ate
invalidate	14	4	442	4	_invalidate
nonconsolidated	19	8	152	4	~~non~~consolidated
nonsolid	9	5	741	4	nonsolid___
nonsolids	10	4	538	4	nonsolid__s

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	148819	0.403	443402.0
2	DLD Change Limit	148819	55	8.563	17379.3
3	Display Results	55	55	0.033	1666.7
	(SQL Overall)	178691	55	8.999	19856.8