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

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

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.

64 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
combatted	16	4	465	(None)
combated	15	3	982	1	comba_ted
combater	14	3	938	2	comba_ter
combusted	16	4	464	2	combusted
committed	16	4	572	2	committed
compacted	18	29	736	2	compacted
comparted	16	33	842	2	comparted
tomcatted	14	4	206	2	tomcatted
batted	9	56	2365	3	___batted
bombarded	17	12	363	3	bombarded
bombaster	15	4	380	3	bombaster
catted	9	54	2247	3	c___atted
chatted	13	34	1189	3	c__hatted
coacted	12	36	1161	3	co__acted
coadapted	15	4	316	3	coadapted
coapted	12	39	1150	3	co__apted
coasted	10	40	1595	3	co__asted
coated	9	49	2704	3	co__a_ted
coattend	11	3	465	3	co__attend
coenacted	14	4	580	3	coenacted
cogitated	13	4	632	3	cogitated
cohabited	17	4	402	3	cohabited
cohobated	17	4	488	3	cohoba_ted
collated	11	36	1506	3	colla_ted
comate	10	41	2484	3	com_a_te_
comates	11	41	2364	3	com_a_tes
combat	12	3	1675	3	comba_t__
combatant	15	4	605	3	combatant
combaters	15	3	811	3	combaters
combating	16	3	1016	3	combating
combative	18	4	721	3	combative
combats	13	3	1168	3	comba_t_s
combatting	17	5	514	3	combatting
combed	13	55	1654	3	comb___ed
combined	15	26	918	3	comb_ined
comforted	17	31	596	3	comforted
commanded	17	13	650	3	commanded
commented	16	12	961	3	commented
committee	15	4	624	3	committee
commutated	17	4	542	3	commutated
commuted	15	28	898	3	com_muted
compacter	17	25	788	3	compacter
companied	16	4	802	3	companied
compared	15	38	1182	3	compa_red
compassed	16	4	554	3	compassed
competed	15	41	1359	3	com_peted
completed	16	28	1027	3	completed
complotted	17	4	373	3	complotted
comported	16	31	953	3	comported
composted	16	37	881	3	composted
compted	14	38	1352	3	com__pted
computed	15	41	1095	3	com_puted
contacted	14	13	909	3	contacted
coplotted	14	4	479	3	coplotted
copycatted	20	5	157	3	copycatted
coquetted	21	5	482	3	coquetted
corotated	12	28	1005	3	corotated
embattled	14	4	256	3	_embattled
formatted	15	4	488	3	formatted
lambasted	14	10	325	3	lambasted
lobated	10	26	1094	3	lo_ba_ted
matted	9	45	2141	3	__m_atted
omitted	10	34	789	3	_om_itted
unmatted	11	3	829	3	unm_atted

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	148641	0.420	425454.8
2	DLD Change Limit	148641	64	6.940	21418.0
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	7.390	24180.1