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

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

78 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
coffining	18	4	548	(None)
confining	15	3	999	1	confining
coffering	18	3	804	2	coffering
coffing	16	38	1125	2	coff__ing
coffling	17	3	648	2	coff_ling
coining	10	39	2054	2	co__ining
cojoining	19	4	575	2	cojoining
combining	16	3	789	2	combining
confiding	16	3	833	2	confiding
tiffining	16	4	291	2	tiffining
uncoffining	20	6	196	2	uncoffining
affixing	22	6	433	3	_affixing
boffing	16	33	998	3	boff__ing
cabining	13	3	864	3	c_abining
calcining	14	4	781	3	calcining
chaining	14	28	1078	3	c_haining
chining	13	33	1684	3	c__hining
cocooning	14	4	702	3	cocooning
codifying	19	4	495	3	codifying
codriving	16	4	521	3	codriving
coediting	13	3	833	3	coediting
coffin	14	33	981	3	coff__in_
coffined	17	3	599	3	coffin_ed
coffins	15	31	1019	3	coff__ins
cofounding	17	4	367	3	cofounding
cognising	13	4	704	3	cognising
cognizing	22	4	717	3	cognizing
coiffing	17	5	593	3	coif_fing
coiffuring	19	4	257	3	coiffuring
coifing	13	32	1389	3	co__ifing
coigning	12	3	717	3	co_igning
coiling	10	37	2345	3	co__iling
colliding	13	3	858	3	colliding
commixing	23	4	519	3	commixing
communing	16	20	786	3	communing
compiling	16	3	776	3	compiling
condoning	13	3	978	3	condoning
confirming	18	4	590	3	confirming
confusing	15	3	733	3	confusing
confuting	15	3	909	3	confuting
coning	9	43	3182	3	co___ning
conjoining	20	4	610	3	conjoining
conning	10	37	1875	3	co__nning
conniving	15	3	709	3	conniving
consigning	14	4	678	3	consigning
containing	13	4	1093	3	containing
continuing	13	4	819	3	continuing
convening	15	3	1119	3	convening
convincing	18	4	534	3	convincing
coppicing	18	4	540	3	coppicing
cordoning	13	3	806	3	cordoning
cornicing	14	3	904	3	cornicing
corning	10	37	2012	3	co__rning
cosigning	13	4	539	3	cosigning
cotinine	10	3	1149	3	co_tinine
cottoning	12	3	734	3	cottoning
couponing	14	4	629	3	couponing
cowhiding	19	4	384	3	cowhiding
cowriting	15	5	732	3	cowriting
cozening	20	18	830	3	co_zening
cuffing	16	32	1025	3	cuff__ing
defining	13	37	1180	3	_defining
doffing	15	35	779	3	doff__ing
fining	10	42	2321	3	___fining
foining	11	30	1345	3	__foining
goffering	17	4	448	3	goffering
joining	15	30	1148	3	jo__ining
offending	17	4	409	3	_offending
offering	15	3	639	3	_offering
offing	13	36	864	3	_off__ing
opining	10	3	1174	3	_o_pining
reconfining	17	4	511	3	reconfining
refining	12	24	1686	3	_refining
rosining	9	24	1142	3	ro_sining
scoffing	17	27	594	3	scoff__ing
softening	13	6	549	3	softening
sufficing	18	4	488	3	sufficing
suffixing	23	4	347	3	suffixing

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.440	406115.9
2	DLD Change Limit	148641	78	7.093	20956.0
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.563	23627.0