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

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

59 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
disconsolation	17	6	341	(None)
disconsolations	18	6	320	1	disconsolations
consolation	13	4	1098	3	___consolation
discoloration	16	12	472	3	disco_loration
disconsolate	15	6	316	3	disconsolat__e
disconsolately	20	7	154	3	disconsolately
consolations	14	4	974	4	___consolations
discolorations	17	10	430	4	disco_lorations
disconnection	18	5	420	4	discon_nection
discontinuation	18	10	323	4	discontinuation
disinflation	16	5	658	4	dis_in_flation
dispensation	15	5	560	4	dispens__ation
dissolution	12	14	502	4	dis___solution
insolation	10	4	1021	4	_i___nsolation
miscorrelation	18	7	323	4	miscorrelation
condonation	14	4	885	5	___condonation
conflation	15	4	1208	5	___con_flation
congelation	14	4	1034	5	___congelation
connotation	13	4	798	5	___connotation
consociation	16	4	819	5	___consociation
consolidation	16	5	515	5	___consolidation
consultation	14	4	747	5	___consultation
convocation	18	4	788	5	___convocation
convolution	16	4	512	5	___convolution
decollation	14	4	819	5	d_eco__llation
deconsecration	19	5	478	5	d_econsecration
demonstration	16	12	628	5	d_emonstration
desolation	11	3	1140	5	d____esolation
disapprobation	21	6	266	5	disapprobation
disassociation	17	6	328	5	dis_association
disclamation	17	5	424	5	disc__lamation
disconnections	19	5	402	5	discon_nections
discrimination	19	5	535	5	discrimination
disinflations	17	5	629	5	dis_in_flations
disinformation	20	6	333	5	dis_information
dislocation	14	14	750	5	dis___location
dispensations	16	5	548	5	dispens__ations
disposition	14	4	668	5	dispo_s__ition
disrelation	12	4	881	5	dis___relation
dissimilation	16	5	652	5	dis_similation
dissimulation	16	5	537	5	dis_simulation
dissipation	14	4	721	5	dis___sipation
dissociation	15	5	664	5	disso__ciation
dissolutions	13	14	492	5	dis___solutions
distillation	13	4	774	5	dis__tillation
glycosylation	22	8	139	5	glyco_sylation
incorporation	17	11	561	5	_incorporation
insolations	11	4	918	5	_i___nsolations
insulation	10	3	1166	5	_i___nsulation
isolation	9	3	1164	5	_i____solation
miscalculation	20	8	303	5	miscalculation
miscomputation	22	9	230	5	miscomputation
misconception	21	6	399	5	miscon_ception
misconnection	19	5	413	5	miscon_nection
misconstruction	21	6	270	5	misconstruction
miscorrelations	19	6	300	5	miscorrelations
mistranslation	16	12	317	5	mistrans_lation
nonsolution	11	5	474	5	___nonsolution
postisolation	15	5	357	5	pos_tisolation

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.376	475242.0
2	DLD Change Limit	95024	59	7.046	13486.2
3	Display Results	59	59	0.046	1282.6
	(SQL Overall)	178691	59	7.468	23927.6