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

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

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.

70 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
compactness	19	5	330	(None)
compacters	18	24	702	2	compact_ers
compactest	18	4	504	2	compact_est
compactnesses	21	5	300	2	compactnesses
compacted	18	29	736	3	compact_e_d
compacter	17	25	788	3	compact_e_r
compactions	19	4	654	3	compactions
compactors	18	25	625	3	compact_ors
compacts	16	36	890	3	compact___s
completeness	18	5	463	3	completeness
complexness	24	5	310	3	complexness
copartners	14	4	357	3	co_partners
correctness	15	5	381	3	correctness
apartness	11	4	605	4	__apartness
campaigners	18	5	187	4	campaigners
campiness	15	3	754	4	camp__iness
coatless	10	3	969	4	co__a_tless
comates	11	41	2364	4	com_a_t_e_s
combaters	15	3	811	4	comba_t_ers
comeliness	14	4	699	4	com_eliness
comfiness	16	4	695	4	com__finess
comfortless	18	5	148	4	comfortless
commonness	16	4	436	4	com_monness
compact	15	37	1221	4	compact____
compactible	21	5	365	4	compactible
compacting	19	17	709	4	compact_ing
compaction	18	4	675	4	compact_ion
compactly	20	4	382	4	compact__ly
compactor	17	25	602	4	compact__or
compadres	16	26	641	4	compa_dre_s
companies	15	3	1180	4	compa__nies
comparers	15	31	939	4	compa__rers
compares	14	38	1643	4	compa__re_s
comparted	16	33	842	4	compart_e_d
compartment	19	9	508	4	compartment
compartments	20	9	433	4	compartments
comparts	14	42	1083	4	compart___s
compass	13	37	956	4	compa____ss
compasses	15	4	739	4	compa_sse_s
competes	14	41	1724	4	comp_et_e_s
complacences	19	5	301	4	complacences
complainers	17	4	447	4	complainers
completers	16	29	832	4	complet_ers
completes	15	32	1292	4	complet_e_s
completest	16	29	787	4	complet_est
complines	15	3	1283	4	comp_line_s
composedness	19	5	240	4	composedness
composters	16	38	832	4	compost_ers
compotes	14	47	1651	4	comp_ot_e_s
compress	14	3	905	4	comp___ress
computers	15	33	975	4	comp_ut_ers
computes	14	39	1455	4	comp_ut_e_s
conductress	16	5	228	4	conductress
contactees	14	13	599	4	contact_ees
coparceners	17	5	234	4	co_parceners
copartner	13	4	356	4	co_partne_r
corruptness	15	5	275	4	corruptness
covertness	15	4	550	4	co_vertness
exactness	18	4	362	4	__exactness
impacters	15	30	548	4	_impact_ers
inexactness	20	5	269	4	inexactness
intactness	12	4	431	4	_intactness
packness	16	3	693	4	___packness
pastness	10	25	1050	4	___pastness
patness	9	29	1228	4	___pa_tness
pompousness	17	5	503	4	pompousness
promptness	16	4	330	4	promp__tness
smartness	11	3	614	4	_sm_artness
spaciness	13	3	708	4	__spaciness
womanness	14	4	447	4	wom_a_nness

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.423	422437.4
2	DLD Change Limit	148819	70	8.530	17446.5
3	Display Results	70	70	0.046	1521.7
	(SQL Overall)	178691	70	8.999	19856.8