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

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

129 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
compassions	17	4	577	(None)
compassion	16	4	598	1	compassion_
commissions	17	4	526	2	commissions
compactions	19	4	654	2	compactions
companions	16	9	726	2	compa_nions
comparisons	17	5	397	2	comparisons
compassing	17	4	655	2	compassi_ng
compressions	18	5	640	2	compressions
compulsions	17	4	459	2	compulsions
impassions	14	4	484	2	_impassions
combustions	17	4	453	3	combustions
commission	16	4	562	3	commission_
compaction	18	4	675	3	compaction_
companion	15	7	768	3	compa_nion_
comparison	16	4	435	3	comparison_
compasses	15	4	739	3	compass__es
compassionate	19	6	309	3	compassionate
compassionates	20	6	260	3	compassion~~ate~~s
compassionless	20	9	210	3	compassion~~les~~s
compatriots	17	5	354	3	compatriots
completions	17	4	691	3	completions
complexions	24	4	362	3	complexions
compositions	18	4	625	3	compositions
compression	17	5	656	3	compression_
compulsion	16	4	467	3	compulsion_
concessions	15	12	810	3	concessions
concussions	15	12	532	3	concussions
confessions	16	13	663	3	confessions
corrasions	12	4	635	3	corra_sions
dispassions	14	5	388	3	dispassions
impassion	13	4	486	3	_impassion_
omissions	11	4	615	3	_om_issions
passions	10	3	1058	3	___passions
admissions	13	4	346	4	adm_issions
campaigns	16	4	347	4	campa__igns
campesinos	16	4	243	4	camp_esinos
campions	14	35	1129	4	camp___ions
caparisons	14	4	367	4	c_aparisons
cassinos	10	30	935	4	c___assinos
cessions	10	3	985	4	c___essions
classons	10	3	770	4	c__lass_ons
coactions	13	4	974	4	co__actions
coaptations	15	4	754	4	coaptations
coassists	11	27	576	4	co__assists
cochampions	22	6	118	4	cochampions
cognations	13	3	959	4	cogna_tions
cohesions	14	4	709	4	co__hesions
collations	12	3	1285	4	colla_tions
collisions	12	4	632	4	co_llisions
collusions	12	4	597	4	co_llusions
combustion	16	4	456	4	combustion_
commissioned	19	5	314	4	commissioned
commissioner	18	5	307	4	commissioner
commissioners	19	7	251	4	commissioners
commotions	16	8	684	4	com_motions
communions	16	5	618	4	com_munions
compacting	19	17	709	4	compacti_ng
compactors	18	25	625	4	compa_ctors
companies	15	3	1180	4	compa_ni_es
companioned	18	5	360	4	compa_nioned
companying	20	4	481	4	companyi_ng
comparators	17	8	568	4	comparators
comparing	16	24	1058	4	compa_ri_ng
comparting	17	18	838	4	comparti_ng
compass	13	37	956	4	compa_s___s
compassable	19	5	421	4	compassable
compassed	16	4	554	4	compass__ed
compassionated	21	6	239	4	compassion~~ate~~d
compatriot	16	5	596	4	compatrio_t
compendious	18	5	337	4	compendious
compensations	19	13	618	4	compensations
competitions	18	4	553	4	competitions
compilations	18	4	868	4	compilations
complains	15	4	919	4	comp_lai_ns
completion	16	4	730	4	completion_
complexion	23	4	375	4	complexion_
complins	14	3	1311	4	comp__li_ns
composing	16	17	984	4	comp_osi_ng
composites	16	4	890	4	comp_osites
composition	17	4	679	4	composition_
compositors	17	5	438	4	compositors
composting	17	17	805	4	composti_ng
compressing	18	4	643	4	compressi_ng
compressional	19	5	426	4	compressional
compressors	17	5	419	4	compressors
comprising	17	4	863	4	comprisi_ng
compunctions	20	14	569	4	compunctions
computations	18	4	812	4	computations
conations	11	13	1890	4	co_na_tions
concession	14	14	813	4	concession_
concisions	14	4	824	4	co_ncisions
conclusions	15	4	488	4	conclusions
concussion	14	15	557	4	concussion_
confession	15	12	650	4	confession_
confusions	15	4	630	4	co_nfusions
congestions	14	4	931	4	congestions
connations	12	3	1294	4	conna_tions
contagions	13	4	660	4	conta_gions
contusions	12	4	699	4	co_ntusions
conversions	16	4	827	4	conversions
convulsions	16	4	431	4	convulsions
cooptions	13	10	776	4	coop__tions
copastors	13	4	699	4	co_pa_stors
copatrons	13	4	633	4	co_pa_trons
corrasion	11	4	648	4	corra_sion_
corrosions	12	4	530	4	co_rrosions
decommissions	20	5	285	4	decommissions
decompressions	21	10	266	4	decompressions
demissions	13	4	566	4	dem_issions
dispassion	13	4	432	4	dispassion_
emissions	11	4	692	4	_em_issions
encompassing	19	6	230	4	encompassi_ng
expansions	19	4	415	4	_expansions
impactions	16	4	541	4	_impactions
impassioned	16	5	293	4	_impassioned
implosions	14	4	402	4	_implosions
impressions	15	4	682	4	_impressions
impulsions	14	4	360	4	_impulsions
mansions	10	6	979	4	__m_ansions
missions	10	3	1190	4	__m_issions
obsessions	12	4	427	4	_obsessions
occasions	13	4	406	4	_occa_sions
omission	10	4	653	4	_om_ission_
oppressions	15	4	572	4	_oppressions
passion	9	3	1088	4	___passion_
possessions	12	6	502	4	possessions
recommissions	19	5	365	4	recommissions
remissions	12	4	661	4	rem_issions
tompions	12	26	700	4	tomp___ions

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.640	279204.7
2	DLD Change Limit	148819	129	8.360	17801.3
3	Display Results	129	129	0.080	1612.5
	(SQL Overall)	178691	129	9.080	19679.6