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

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

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
checkmating	25	5	243	(None)
checkmarking	25	5	136	2	checkmarking
cheating	14	40	1452	3	che___ating
checkering	22	4	440	3	check_ering
checking	20	37	920	3	check___ing
checklisting	24	5	125	3	checklisting
checkmate	22	4	353	3	checkmat__e
checkmated	24	5	254	3	checkmat_ed
checkmates	23	4	338	3	checkmat_es
checkrowing	26	5	162	3	checkrowing
chelating	15	4	935	3	che__lating
cremating	14	3	1219	3	cre__mating
decimating	16	4	875	3	_decimating
backdating	20	4	571	4	_backdating
brecciating	18	4	422	4	brecciating
calculating	16	6	678	4	calculating
chairmaning	19	5	245	4	chairmaning
checkmark	21	5	216	4	checkma__rk
checkmarked	24	5	129	4	checkmarked
checkmarks	22	5	198	4	checkma_rks
checkpoint	23	5	288	4	check_point
checkrein	20	4	290	4	check_rein_
checkreins	21	5	249	4	check_reins
cheeking	18	34	908	4	cheek___ing
chicaning	17	4	516	4	chic__aning
chickening	22	4	413	4	chick_ening
chocking	20	40	1101	4	chock___ing
chromatin	16	4	1075	4	ch_romatin_
chromatins	17	4	912	4	ch_romatins
chucking	20	37	950	4	chuck___ing
chuckling	21	4	419	4	chuck__ling
circulating	16	4	773	4	circulating
cleating	11	35	1813	4	cle___ating
cocreating	15	3	1029	4	c_ocreating
coempting	16	3	607	4	coe__mpting
coequating	22	4	532	4	coe_quating
collimating	16	4	542	4	collimating
creating	11	39	2195	4	cre___ating
crenelating	14	4	551	4	crenelating
crepitating	16	4	580	4	crepitating
cricketing	19	4	403	4	crick_eting
decorating	14	3	1207	4	_decorating
execrating	20	4	788	4	exec_rating
gemmating	15	7	644	4	_ge_mmating
hacksawing	23	4	326	4	_hacksawing
heating	11	40	2432	4	_he___ating
hebetating	16	4	579	4	_hebetating
heckling	18	25	716	4	_heck__ling
helmeting	15	4	550	4	_he_lmeting
hematin	12	15	1602	4	_he__matin_
hematine	13	16	1467	4	_he__matine
hematins	13	17	1468	4	_he__matins
herniating	14	4	598	4	_herniating
hesitating	14	4	800	4	_hesitating
necklacing	19	4	281	4	_necklacing
peculating	15	4	915	4	_peculating
phenolating	17	4	525	4	phenolating
recoating	12	13	1746	4	_rec_oating
recrating	12	13	1879	4	_rec_rating
recreating	13	12	1458	4	_recreating
remating	11	23	2241	4	_re__mating
speciating	15	4	812	4	spec_iating
spectating	15	4	662	4	spec_tating
speculating	16	4	594	4	speculating

Search took 9 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.436	409841.7
2	DLD Change Limit	148819	64	8.206	18135.4
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	8.672	20605.5