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

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

62 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
consolation	13	4	1098	(None)
consolations	14	4	974	1	consolations
condonation	14	4	885	2	condonation
conflation	15	4	1208	2	con_flation
congelation	14	4	1034	2	congelation
connotation	13	4	798	2	connotation
consociation	16	4	819	2	consociation
consolidation	16	5	515	2	consolidation
consultation	14	4	747	2	consultation
convocation	18	4	788	2	convocation
convolution	16	4	512	2	convolution
insolation	10	4	1021	2	_insolation
nonsolution	11	5	474	2	nonsolution
cancelation	15	4	777	3	cancelation
coagulation	14	4	727	3	coagulation
coevolution	16	5	422	3	coevolution
collation	11	3	1399	3	co__llation
collocation	15	4	717	3	collocation
coloration	12	9	1318	3	co_loration
compilation	17	4	931	3	compilation
conation	10	14	2088	3	con___ation
conciliation	16	4	823	3	conciliation
concoction	13	4	823	3	conco_ction
condonations	15	4	800	3	condonations
conflations	16	4	1114	3	con_flations
conformation	19	4	732	3	conformation
confutation	16	6	872	3	confutation
congelations	15	4	973	3	congelations
conglobation	17	5	425	3	conglobation
conjugation	21	4	662	3	conjugation
conjuration	20	4	951	3	conjuration
connation	11	3	1426	3	con__nation
connotations	14	4	728	3	connotations
consecration	16	4	978	3	consecration
consecution	15	4	730	3	consecution
conservation	17	4	940	3	conservation
consignation	15	13	631	3	consignation
consociations	17	4	751	3	consociations
consolatory	16	8	496	3	consolatory
consolidations	17	5	474	3	consolidations
conspiration	16	4	838	3	conspiration
constellation	15	5	479	3	constellation
constipation	16	4	856	3	constipation
consultations	15	4	693	3	consultations
consummation	18	5	529	3	consummation
consumption	17	4	542	3	consumption
contortion	12	4	866	3	conto_rtion
conurbation	15	4	746	3	conurbation
convocations	19	4	736	3	convocations
convolutions	17	4	519	3	convolutions
copulation	14	11	1195	3	co_pulation
coronation	12	4	1207	3	co_ronation
corotation	12	4	1097	3	co_rotation
corporation	15	12	1065	3	corporation
correlation	13	5	855	3	correlation
desolation	11	3	1140	3	_desolation
disconsolation	17	6	341	3	~~dis~~consolation
insolations	11	4	918	3	_insolations
insulation	10	3	1166	3	_insulation
isolation	9	3	1164	3	__isolation
nonsolutions	12	5	417	3	nonsolutions
solation	8	9	1615	3	___solation

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	121633	0.390	458182.1
2	DLD Change Limit	121633	62	4.766	25521.0
3	Display Results	62	62	0.030	2066.7
	(SQL Overall)	178691	62	5.186	34456.4