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

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

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.

84 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
copying	15	34	1198	(None)
coping	11	39	2766	1	cop_ing
copping	14	39	1859	1	copping
cosying	13	45	1313	1	cosying
coying	12	40	2148	1	co_ying
cozying	22	30	806	1	cozying
bodying	14	3	897	2	bodying
bopping	14	35	1203	2	bopping
canopying	17	4	506	2	canopying
capping	14	38	1967	2	capping
chopping	18	37	1026	2	chopping
claying	13	36	1430	2	claying
clopping	15	35	1108	2	clopping
cloying	13	35	1175	2	cloying
coaling	10	37	2282	2	coaling
coaming	12	38	1832	2	coaming
coapting	13	35	1161	2	coapting
coating	10	35	2531	2	coating
coaxing	17	35	1170	2	coaxing
cocking	16	36	1998	2	cocking
codding	12	40	1469	2	codding
coding	10	40	2479	2	co_ding
codling	11	44	1895	2	codling
coffing	16	38	1125	2	coffing
cogging	12	35	1371	2	cogging
coifing	13	32	1389	2	coifing
coiling	10	37	2345	2	coiling
coining	10	39	2054	2	coining
coking	13	45	2388	2	co_king
collying	14	31	954	2	collying
combing	14	37	1473	2	combing
coming	11	42	2545	2	co_ming
comping	14	35	1859	2	comping
complying	19	3	611	2	complying
compting	15	30	1360	2	compting
coning	9	43	3182	2	co_ning
conking	14	36	1845	2	conking
conning	10	37	1875	2	conning
cooeying	14	3	814	2	cooeying
cooing	9	40	2492	2	co_oing
cooking	14	38	1897	2	cooking
cooling	10	34	2257	2	cooling
cooping	12	39	1893	2	cooping
coopting	13	34	1131	2	coopting
copings	12	41	1184	2	cop_ings
copyist	14	3	905	2	copyist
cording	11	36	2082	2	cording
coring	9	44	3396	2	co_ring
corking	14	30	1882	2	corking
corning	10	37	2012	2	corning
coshing	13	43	1643	2	coshing
costing	10	43	2302	2	costing
coting	9	46	2925	2	co_ting
couping	12	43	1702	2	couping
coupling	13	3	1078	2	coupling
coving	12	43	2152	2	co_ving
cowing	12	45	2632	2	co_wing
cowling	13	40	1742	2	cowling
coxing	16	42	1886	2	co_xing
cropping	15	32	1088	2	cropping
crying	12	36	1228	2	c_rying
cupping	14	43	1238	2	cupping
doping	10	39	1946	2	dop_ing
espying	13	3	619	2	espying
fopping	15	35	1113	2	fopping
hoping	12	37	1974	2	hop_ing
hopping	15	41	1527	2	hopping
joying	17	38	1080	2	jo_ying
loping	9	39	2141	2	lop_ing
lopping	12	38	1522	2	lopping
moping	11	40	1710	2	mop_ing
mopping	14	34	1147	2	mopping
oping	8	63	2241	2	_op_ing
opting	9	45	1440	2	_opting
ponying	13	33	1212	2	ponying
popping	11	37	1541	2	popping
recopying	17	3	711	2	recopying
roping	9	40	2302	2	rop_ing
scoping	12	35	1382	2	scop_ing
sopping	12	39	1720	2	sopping
spying	12	39	1325	2	_spying
toping	9	41	2299	2	top_ing
topping	12	35	1462	2	topping
toying	10	50	1730	2	to_ying

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	84	2.873	37476.9
3	Display Results	84	84	0.033	2545.5
	(SQL Overall)	178691	84	3.282	54445.8