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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

125 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
claying	13	36	1430	(None)
clawing	13	38	1267	1	clawing
cloying	13	35	1175	1	cloying
flaying	14	39	1446	1	flaying
laying	10	45	2570	1	_laying
playing	13	38	1609	1	playing
slaying	11	33	1684	1	slaying
allaying	12	33	930	2	allaying
allying	11	30	1166	2	allying
baying	12	52	2258	2	_baying
belaying	14	31	1060	2	belaying
blading	11	36	1536	2	blading
blaming	12	35	1569	2	blaming
blaring	10	43	1711	2	blaring
blawing	13	40	1275	2	blawing
blazing	19	36	1239	2	blazing
braying	13	44	1631	2	braying
caging	10	53	2102	2	c_aging
caking	13	46	2467	2	c_aking
calking	14	46	1778	2	calking
calling	10	38	2677	2	calling
calming	12	39	1597	2	calming
calving	13	41	1350	2	calving
caning	9	41	2862	2	c_aning
caring	9	51	3799	2	c_aring
casing	9	48	2910	2	c_asing
caving	12	48	2261	2	c_aving
cawing	12	43	2261	2	c_awing
ceasing	10	41	1826	2	ceasing
chafing	16	39	1149	2	chafing
charing	13	37	2132	2	charing
chasing	13	37	1589	2	chasing
chawing	16	48	1303	2	chawing
clacking	17	33	1349	2	clacking
cladding	13	3	714	2	cladding
clagging	13	32	887	2	clagging
claiming	13	27	930	2	claiming
clamming	15	32	937	2	clamming
clamping	15	40	1115	2	clamping
clang	8	60	1931	2	cla__ng
clanging	12	40	1212	2	clanging
clanking	15	43	1306	2	clanking
clapping	15	38	1060	2	clapping
clashing	14	38	1219	2	clashing
clasping	13	33	1026	2	clasping
classing	11	32	1179	2	classing
clayier	12	4	832	2	clayier
clayish	15	4	794	2	clayish
cleaning	11	31	1238	2	cleaning
clearing	11	30	1488	2	clearing
cleating	11	35	1813	2	cleating
cleaving	14	138	968	2	cleaving
cleping	12	33	1042	2	cleping
clewing	13	35	958	2	clewing
cling	8	64	2467	2	cl__ing
cloaking	15	29	971	2	cloaking
cloning	10	32	1547	2	cloning
closing	10	31	1484	2	closing
clueing	10	41	1009	2	clueing
cluing	9	39	1350	2	cl_uing
coaling	10	37	2282	2	coaling
coaming	12	38	1832	2	coaming
coating	10	35	2531	2	coating
coaxing	17	35	1170	2	coaxing
collying	14	31	954	2	collying
copying	15	34	1198	2	copying
cosying	13	45	1313	2	cosying
coying	12	40	2148	2	c_oying
cozying	22	30	806	2	cozying
craning	10	36	2030	2	craning
craping	12	40	1871	2	craping
crating	10	37	2520	2	crating
craving	13	40	1573	2	craving
crazing	19	39	1458	2	crazing
crying	12	36	1228	2	c_rying
cullying	14	29	750	2	cullying
delaying	13	32	1097	2	delaying
draying	12	38	1384	2	draying
elating	8	34	2308	2	elating
faying	13	45	2107	2	_faying
flaking	15	41	1449	2	flaking
flaming	13	42	1644	2	flaming
flaring	11	41	1680	2	flaring
flawing	14	38	1256	2	flawing
fleying	14	32	987	2	fleying
flying	13	46	1215	2	fl_ying
fraying	14	34	1343	2	fraying
glaring	9	37	1488	2	glaring
glazing	18	36	1100	2	glazing
gleying	12	31	843	2	gleying
graying	12	41	1588	2	graying
haying	13	44	2061	2	_haying
inlaying	12	4	789	2	inlaying
lacing	9	46	2623	2	_lacing
lading	8	42	2712	2	_lading
laking	11	50	2704	2	_laking
laming	9	45	2836	2	_laming
lasing	7	47	2798	2	_lasing
laving	10	46	2357	2	_laving
lawing	10	46	2528	2	_lawing
layin	8	47	2033	2	_layin_
layins	9	38	1765	2	_layins
lazing	16	48	2147	2	_lazing
lazying	20	4	667	2	_lazying
lying	9	57	1745	2	_l_ying
maying	12	44	2115	2	_maying
okaying	15	3	483	2	okaying
paying	12	37	2216	2	_paying
placing	12	38	1528	2	placing
planing	10	34	1825	2	planing
plating	10	38	2307	2	plating
ploying	13	28	1157	2	ploying
plying	12	43	1208	2	pl_ying
praying	13	37	1732	2	praying
raying	10	50	2719	2	_raying
relaying	12	25	1515	2	relaying
saying	10	43	2554	2	_saying
slaking	12	37	1747	2	slaking
slating	8	37	2465	2	slating
slaving	11	35	1483	2	slaving
spaying	13	30	1462	2	spaying
splaying	14	21	930	2	splaying
staying	11	40	1732	2	staying
swaying	14	36	1064	2	swaying
unlaying	12	5	836	2	unlaying

Search took 5 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.373	479064.3
2	DLD Change Limit	107671	125	4.140	26007.5
3	Display Results	125	125	0.050	2500.0
	(SQL Overall)	178691	125	4.563	39160.9