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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

118 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
confirmation	19	4	618	(None)
confirmations	20	5	567	1	confirmations
conformation	19	4	732	1	conformation
confirmational	21	15	339	2	confirmational
confiscation	19	4	553	2	confiscation
conformations	20	4	672	2	conformations
reconfirmation	21	5	322	2	reconfirmation
affirmation	19	5	368	3	_affirmation
collimation	15	5	757	3	colli_mation
conciliation	16	4	823	3	conciliation
configuration	19	5	413	3	configuration
confirmatory	22	5	357	3	confirmatory
confiscations	20	4	495	3	confiscations
conflation	15	4	1208	3	conf__lation
conformational	21	15	371	3	conformational
confutation	16	6	872	3	conf_utation
conjuration	20	4	951	3	conjur_ation
conservation	17	4	940	3	conservation
consignation	15	13	631	3	consignation
conspiration	16	4	838	3	conspir_ation
consummation	18	5	529	3	consummation
continuation	14	4	819	3	continuation
conurbation	15	4	746	3	con_urbation
conversation	17	4	780	3	conversation
information	16	14	771	3	_information
reconfirmations	22	8	308	3	reconfirmations
affirmations	20	5	323	4	_affirmations
animation	11	3	1368	4	_an_i_mation
cantillation	14	4	669	4	cantillation
chrismation	18	5	351	4	c_hrismation
coacervation	19	6	427	4	coacervation
codification	20	10	807	4	codification
codirection	16	4	474	4	co_direction
cogitation	13	4	1008	4	co_gi_tation
colligation	14	5	744	4	colli_gation
collimations	16	5	687	4	colli_mations
coloration	12	9	1318	4	co_lor_ation
colorization	23	17	1119	4	colorization
combination	17	10	880	4	combi_nation
commination	17	11	1164	4	commi_nation
compilation	17	4	931	4	compi_lation
compurgation	19	13	418	4	compurgation
conation	10	14	2088	4	con____ation
conciliations	17	4	720	4	conciliations
concretion	14	4	929	4	con_cr_etion
condemnation	17	4	604	4	condemnation
condensation	15	4	678	4	condensation
condition	12	4	1116	4	condi___tion
condonation	14	4	885	4	con_donation
confabulation	20	6	330	4	confabulation
confection	17	4	1118	4	conf__ection
confederation	19	9	525	4	confederation
configurations	20	6	370	4	configurations
confirmable	20	6	418	4	confirma_ble
confirmand	18	5	322	4	confirma__nd
confirmands	19	5	285	4	confirma_nds
confirming	18	4	590	4	confirm__ing
confiscating	20	5	361	4	confiscating
confiscator	18	11	374	4	confiscat_or
conflagration	19	5	301	4	conflagration
conflations	16	4	1114	4	conf__lations
confliction	18	4	523	4	conf_liction
conformities	19	5	492	4	conformities
confrontation	18	5	322	4	confrontation
confutations	17	6	779	4	conf_utations
congelation	14	4	1034	4	con_gelation
conglobation	17	5	425	4	conglobation
congregation	16	22	676	4	congregation
conjugation	21	4	662	4	con_jugation
conjurations	21	4	849	4	conjur_ations
connation	11	3	1426	4	con___nation
conniption	14	4	627	4	conni__ption
connotation	13	4	798	4	con_notation
conscription	18	5	533	4	conscription
consecration	16	4	978	4	consecration
conservations	18	4	909	4	conservations
consideration	16	5	552	4	consideration
consignations	16	10	593	4	consignations
consociation	16	4	819	4	consociation
consolation	13	4	1098	4	con_solation
conspirations	17	4	772	4	conspir_ations
consternation	15	10	636	4	consternation
constipation	16	4	856	4	constipation
constriction	16	4	826	4	constriction
construction	16	4	808	4	construction
consultation	14	4	747	4	consultation
consummations	19	5	515	4	consummations
consumption	17	4	542	4	con_sumption
contestation	14	4	866	4	contestation
continuations	15	4	714	4	continuations
contortion	12	4	866	4	contor__tion
contraction	15	4	1124	4	con_traction
contraption	15	4	810	4	con_traption
contribution	16	5	509	4	contribution
contrition	12	4	1141	4	con_tr_ition
conurbations	16	4	666	4	con_urbations
conversations	18	4	745	4	conversations
conviction	17	4	818	4	convi__ction
convocation	18	4	788	4	con_vocation
cooperation	15	4	1002	4	cooper_ation
cornification	20	4	669	4	cornification
corporation	15	12	1065	4	corpor_ation
covariation	16	4	677	4	co_variation
deformation	17	4	766	4	_deformation
formation	14	3	942	4	___formation
infixation	20	4	753	4	_infi_xation
informations	17	12	703	4	_informations
infuriation	14	4	824	4	_infuriation
intimation	12	4	1304	4	_inti_mation
ionization	19	4	1127	4	ion_i_zation
malformation	19	5	332	4	malformation
nonfiction	15	4	630	4	nonfi__ction
noninformation	19	7	331	4	noninformation
officiation	19	4	383	4	_officiation
preformation	19	4	647	4	preformation
reaffirmation	21	5	206	4	reaffirmation
reformation	16	4	841	4	_reformation
sonication	12	4	1118	4	son_i_cation

Search took 7 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	124790	0.376	475242.0
2	DLD Change Limit	124790	118	6.513	19160.1
3	Display Results	118	118	0.063	1873.0
	(SQL Overall)	178691	118	6.952	25703.5