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

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

152 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
confliction	18	4	523	(None)
conflictions	19	4	522	1	conflictions
confection	17	4	1118	2	conf_ection
conflation	15	4	1208	2	confl_ation
conflicting	19	4	472	2	conflicting
conflictive	21	5	377	2	conflictive
conviction	17	4	818	2	con_viction
infliction	15	4	594	2	_infliction
nonfiction	15	4	630	2	nonf_iction
affliction	18	4	354	3	_affliction
coalition	11	4	870	3	co_ali_tion
cofunction	17	4	525	3	co_function
collection	14	4	820	3	co_llection
complication	20	4	820	3	complication
conciliation	16	4	823	3	conciliation
concoction	13	4	823	3	con_coction
condition	12	4	1116	3	con_di_tion
conduction	15	4	996	3	con_duction
confections	18	4	1139	3	conf_ections
confiscation	19	4	553	3	confiscation
conflations	16	4	1114	3	confl_ations
conflict	15	4	775	3	conflict___
conflicted	18	4	405	3	conflict_ed
conflictful	21	6	87	3	conflictful
conflicts	16	4	479	3	conflict__s
conflictual	18	5	175	3	conflictual
confutation	16	6	872	3	confutation
conjunction	22	4	562	3	conjunction
connection	14	4	1053	3	con_nection
conniption	14	4	627	3	con_niption
constriction	16	4	826	3	constriction
contraction	15	4	1124	3	contraction
contrition	12	4	1142	3	contri_tion
convection	17	4	1112	3	con_vection
convictions	18	4	805	3	con_victions
inflection	15	4	763	3	_inflection
inflictions	16	4	544	3	_inflictions
nonelection	13	4	720	3	nonelection
nonfictions	16	4	593	3	nonf_ictions
afflictions	19	4	340	4	_afflictions
benediction	16	4	332	4	benediction
bolection	13	11	767	4	bo__lection
canalization	23	4	1116	4	canalization
ciliation	11	11	1249	4	c__iliation
coaction	12	3	1077	4	co___action
coalitions	12	4	792	4	co_ali_tions
codification	20	10	807	4	codification
codirection	16	4	474	4	codirection
cofunctions	18	4	501	4	co_functions
cognition	12	4	701	4	co_gni_tion
coition	9	3	1431	4	co___i_tion
colicin	11	3	1374	4	co__lic_i_n
colistin	10	4	1055	4	co__listi_n
collation	11	3	1399	4	co__llation
collections	15	4	793	4	co_llections
colligation	14	5	745	4	co_lligation
collimation	15	5	757	4	co_llimation
collision	11	4	694	4	co_lli_sion
collocation	15	4	717	4	co_llocation
compaction	18	4	675	4	co_mpaction
compilation	17	4	931	4	compilation
completion	16	4	730	4	compl_etion
complications	21	4	743	4	complications
compunction	19	11	590	4	compunction
conation	10	14	2088	4	con___ation
conception	16	4	1045	4	con_ception
conciliations	17	4	720	4	conciliations
concision	13	4	849	4	con_ci_sion
conclusion	14	4	522	4	concl_usion
concoctions	14	4	826	4	con_coctions
concretion	14	4	929	4	con_cretion
conditions	13	4	1010	4	con_di_tions
condonation	14	4	885	4	condonation
conductions	16	4	966	4	con_ductions
confecting	18	3	1055	4	conf_ecting
confectioner	19	6	414	4	conf_ectioner
confession	15	12	650	4	conf_ession
confirmation	19	4	618	4	confirmation
confiscations	20	4	495	4	confiscations
confiteor	14	4	387	4	conf_i_teor
conflagration	19	5	301	4	conflagration
conflating	16	4	1000	4	confl_ating
conflictingly	24	6	168	4	conflictingly
conformation	19	4	732	4	conformation
confusion	14	4	647	4	conf__usion
confutations	17	6	779	4	confutations
congelation	14	4	1034	4	congelation
congestion	13	4	904	4	con_gestion
conglobation	17	5	425	4	conglobation
conjugation	21	4	662	4	conjugation
conjunctions	23	4	538	4	conjunctions
conjuration	20	4	951	4	conjuration
connation	11	3	1426	4	con__nation
connections	15	4	1070	4	con_nections
conniptions	15	4	603	4	con_niptions
connotation	13	4	798	4	connotation
conscription	18	5	533	4	conscription
consecution	15	4	731	4	consecution
consociation	16	4	819	4	consociation
consolation	13	4	1098	4	consolation
consolidation	16	5	515	4	consolidation
conspiration	16	4	838	4	conspiration
constipation	16	4	856	4	constipation
constitution	14	5	526	4	constitution
constrictions	17	4	778	4	constrictions
construction	16	4	808	4	construction
consultation	14	4	747	4	consultation
consumption	17	4	542	4	consumption
contention	12	4	1222	4	con_tention
contortion	12	4	866	4	con_tortion
contractions	16	4	1040	4	contractions
contradiction	18	5	456	4	contradiction
contraption	15	4	810	4	contraption
contribution	16	5	509	4	contribution
contritions	13	4	1091	4	contri_tions
conurbation	15	4	746	4	conurbation
convections	18	4	1149	4	con_vections
convention	15	4	1056	4	con_vention
convicting	18	4	758	4	con_victing
convocation	18	4	788	4	convocation
convolution	16	4	512	4	convolution
copulation	14	11	1195	4	copul_ation
cornification	20	4	669	4	cornification
correction	14	4	881	4	co_rrection
covariation	16	4	677	4	covariation
deflection	16	14	773	4	_deflection
dereliction	14	4	457	4	dereliction
fiction	12	20	1073	4	___f_iction
flection	13	23	956	4	___flection
foliation	12	11	1079	4	fo__liation
friction	13	4	791	4	___friction
genuflection	18	5	161	4	genuflection
indiction	12	3	981	4	_in_diction
infarction	15	4	579	4	_infarction
infection	14	4	1047	4	_inf_ection
inflation	12	3	1109	4	_infl_ation
inflections	16	4	699	4	_inflections
inflicting	16	4	572	4	_inflicting
inflictive	18	10	463	4	_inflictive
inflictor	14	4	401	4	_inflict_or
infraction	15	5	745	4	_infraction
monition	10	3	1172	4	mon__i_tion
nonaction	11	4	944	4	non__action
nonelections	14	5	639	4	nonelections
nonfictional	17	5	485	4	nonf_ictional
olfaction	14	6	423	4	_olf_action
reconviction	19	5	508	4	recon_viction
reflection	15	16	899	4	_reflection
reliction	11	3	1069	4	__reliction
solifluction	17	6	125	4	solifluction
sonication	12	4	1118	4	son__ication
volition	11	7	917	4	vo__li_tion

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.453	394461.4
2	DLD Change Limit	148819	152	8.830	16853.8
3	Display Results	152	152	0.090	1688.9
	(SQL Overall)	178691	152	9.373	19064.4