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

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

112 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
congregation	16	22	676	(None)
congregations	17	18	641	1	congregations
congelation	14	4	1034	2	cong_elation
congregating	17	5	428	2	congregating
congregational	18	6	343	2	congregational
congregator	15	5	411	2	congregat_or
aggregation	14	5	425	3	_aggregation
concretion	14	4	929	3	concre__tion
congelations	15	4	973	3	cong_elations
congestion	13	4	904	3	cong_e_stion
conglobation	17	5	425	3	conglobation
congregate	14	4	524	3	congregat__e
congregated	16	4	473	3	congregat_ed
congregates	15	4	550	3	congregat_es
congregators	16	5	383	3	congregators
conjugation	21	4	662	3	con_jugation
conservation	17	4	940	3	conservation
conurbation	15	4	746	3	conur_bation
conversation	17	4	780	3	conversation
correlation	13	5	855	3	co_rrelation
corrugation	14	4	599	3	co_rrugation
nonsegregation	16	13	280	3	nonsegregation
segregation	13	4	638	3	_segregation
abnegation	13	4	541	4	abn__egation
aggregations	15	5	384	4	_aggregations
cancelation	15	4	777	4	can_celation
coacervation	19	6	427	4	coacervation
coagulation	14	4	727	4	coag_ulation
coarctation	15	9	507	4	co_arctation
codirection	16	4	474	4	codire_ction
cogeneration	15	4	644	4	cogeneration
cogitation	13	4	1008	4	co_g_itation
cognation	12	3	1075	4	co_g__nation
colligation	14	5	744	4	co_lligation
coloration	12	9	1318	4	color__ation
colorization	23	17	1119	4	colorization
complexation	25	14	424	4	complexation
compurgation	19	13	418	4	compurgation
conation	10	14	2088	4	con____ation
concatenation	17	6	409	4	concatenation
conception	16	4	1045	4	con_ce_ption
conciliation	16	4	823	4	conciliation
concretions	15	4	929	4	concre__tions
concretization	27	5	437	4	concretization
condemnation	17	4	604	4	condemnation
condensation	15	4	678	4	condensation
condonation	14	4	885	4	con_donation
confection	17	4	1118	4	con_fe_ction
confederation	19	9	525	4	confederation
confirmation	19	4	618	4	confirmation
confiscation	19	4	553	4	confiscation
conflagration	19	5	301	4	conflagration
conflation	15	4	1208	4	con__flation
conformation	19	4	732	4	conformation
confrontation	18	5	322	4	confrontation
confutation	16	6	872	4	con_futation
congestions	14	4	931	4	cong_e_stions
conglobations	18	5	394	4	conglobations
conglomeration	19	6	300	4	conglomeration
congratulation	17	8	282	4	congratulation
congregant	14	5	457	4	congrega__nt
congregants	15	5	315	4	congrega_nts
conjugations	22	4	586	4	con_jugations
conjuration	20	4	951	4	con_juration
connation	11	3	1426	4	con___nation
connection	14	4	1053	4	con_ne_ction
connotation	13	4	798	4	con_notation
consecration	16	4	978	4	consecration
consecution	15	4	730	4	con_secution
conservations	18	4	909	4	conservations
consideration	16	5	552	4	consideration
consignation	15	13	631	4	consignation
consociation	16	4	819	4	consociation
consolation	13	4	1098	4	con_solation
conspiration	16	4	838	4	conspiration
constellation	15	5	479	4	constellation
consternation	15	10	636	4	consternation
constipation	16	4	856	4	constipation
consultation	14	4	747	4	consultation
consummation	18	5	529	4	consummation
contention	12	4	1222	4	con_te_ntion
contestation	14	4	866	4	contestation
continuation	14	4	819	4	continuation
contraction	15	4	1124	4	contr_action
contraption	15	4	810	4	contr_aption
contribution	16	5	509	4	contribution
contrition	12	4	1141	4	contr__ition
conurbations	16	4	666	4	conur_bations
convection	17	4	1112	4	con_ve_ction
convention	15	4	1056	4	con_ve_ntion
conversations	18	4	745	4	conversations
convocation	18	4	788	4	con_vocation
cooperation	15	4	1002	4	co_operation
coronation	12	4	1207	4	co__ronation
corotation	12	4	1097	4	co__rotation
correction	14	4	881	4	co_rre_ction
correlations	14	4	786	4	co_rrelations
corrugations	15	6	548	4	co_rrugations
covariation	16	4	677	4	covar_iation
creation	10	28	1651	4	c___re_ation
cremation	13	5	1164	4	c___remation
crenation	11	4	1292	4	c___renation
denegation	12	4	941	4	den__egation
desegregation	16	6	381	4	desegregation
mongrelization	26	5	373	4	mongrelization
negation	9	29	1302	4	__n__egation
nongregarious	15	10	149	4	nongregarious
nonregulation	14	7	390	4	non_regulation
nonsegregations	17	16	269	4	nonsegregations
reaggregation	16	5	314	4	reaggregation
resegregation	15	6	390	4	resegregation
segregations	14	4	580	4	_segregations

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	124790	0.390	458182.1
2	DLD Change Limit	124790	112	6.530	19110.3
3	Display Results	112	112	0.080	1400.0
	(SQL Overall)	178691	112	7.000	25527.3