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

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

65 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
coalesces	13	4	604	(None)
coalesce	12	4	542	1	coalesce_
coalesced	14	4	455	1	coalesced
coalescent	14	9	665	2	coalescent
convalesces	18	5	312	2	convalesces
covalences	17	4	583	2	covalences
opalesces	13	4	399	2	opalesces
uncoalesces	15	5	225	2	uncoalesces
cadences	13	3	847	3	c_adences
calashes	13	3	1053	3	c_alashes
calces	10	44	2005	3	c_al__ces
caleches	15	26	993	3	c_aleches
calesas	9	4	1183	3	c_ales_as
calescent	13	11	822	3	c_alescent
calices	11	43	2169	3	c_al_ices
calyces	14	42	880	3	c_al_yces
caresses	10	3	1406	3	c_aresses
celestes	10	3	1001	3	c_elestes
chalices	15	3	1081	3	chal_ices
clarences	13	4	645	3	clarences
coagencies	15	4	562	3	coagencies
coalboxes	20	4	368	3	coalboxes
coalers	9	44	1935	3	coale__rs
coalescence	14	5	509	3	coalescence
coalescences	15	5	421	3	coales~~cen~~ces
coalescing	15	4	516	3	coalescing
coalfishes	18	4	469	3	coalfishes
coalholes	14	4	537	3	coalholes
coalifies	14	3	911	3	coalifies
coalless	10	3	819	3	coalles__s
coalsacks	17	4	351	3	coalsacks
coalshed	14	3	501	3	coal_shed
coalsheds	15	4	286	3	coal_sheds
coatees	9	38	1655	3	coate__es
coatless	10	3	969	3	coatles__s
coerces	11	3	1194	3	co__erces
coleseed	11	4	740	3	co_leseed
coleseeds	12	4	432	3	co_leseeds
colessee	10	9	879	3	co_lessee
colessees	11	14	605	3	co_lessees
coleuses	10	3	972	3	co_leuses
collects	12	27	978	3	colle_cts
colleges	11	24	1052	3	colle_ges
commences	17	13	958	3	commences
commerces	17	14	723	3	commerces
confesses	14	3	862	3	confesses
convalesce	17	5	299	3	convalesce_
convalesced	19	5	215	3	convalesced
coolnesses	12	3	719	3	coolnesses
cordlesses	13	4	630	3	cordlesses
coulees	9	3	1551	3	coule__es
coulisses	11	4	563	3	coulisses
covalence	16	4	584	3	covalence_
covalencies	18	5	399	3	covalencies
coxless	16	3	774	3	coxles__s
coynesses	14	3	757	3	coynesses
evanesces	14	6	318	3	evanesces
noblesses	11	4	600	3	noblesses
opalesce	12	4	351	3	opalesce_
opalesced	14	4	279	3	opalesced
scoleces	12	3	708	3	sco_le_ces
uncoalesce	14	6	218	3	uncoalesce_
uncoalesced	16	5	215	3	uncoalesced
valences	13	8	851	3	_valences
vocaleses	14	14	532	3	vocales_es

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.436	409841.7
2	DLD Change Limit	148641	65	7.376	20152.0
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	7.842	22786.4