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

Here are the results of your fuzzy-string dictionary search for “cranker” 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
cranker	13	36	1278	(None)
canker	12	44	2252	1	c_anker
cracker	15	31	1417	1	cracker
cranked	14	38	1284	1	cranked
crankier	14	33	916	1	crankier
franker	14	35	1018	1	franker
ranker	10	50	2190	1	_ranker
banker	12	42	2273	2	_banker
blanker	13	46	1202	2	blanker
brander	10	39	1582	2	brander
branner	9	42	1237	2	branner
calker	12	49	1708	2	c_alker
cancer	10	42	2092	2	c_ancer
caner	7	53	3477	2	c_an_er
cankers	13	44	1875	2	c_ankers
canner	8	46	2598	2	c_anner
canoer	8	51	2107	2	c_anoer
canter	8	52	3011	2	c_anter
chancer	14	42	1563	2	chancer
changer	13	42	1554	2	changer
chanter	12	39	1973	2	chanter
clacker	15	38	1377	2	clacker
clanger	10	41	1349	2	clanger
clanked	14	38	1225	2	clanked
clankier	14	32	708	2	clankier
clinker	13	38	1166	2	clinker
clunker	13	41	945	2	clunker
conker	12	47	2155	2	c_onker
crabber	13	38	1073	2	crabber
cracked	16	35	1474	2	cracked
crackers	16	41	1172	2	crackers
cradler	10	29	1051	2	cradler
crafter	12	41	1133	2	crafter
crake	11	48	2352	2	cra_ke_
crakes	12	49	2181	2	cra_kes
crammer	13	40	1096	2	crammer
crane	7	53	3160	2	cran_e_
craned	9	61	2165	2	cran_ed
cranes	8	43	3075	2	cran_es
crank	11	48	1961	2	crank__
crankest	14	3	814	2	crankest
crankle	13	36	1006	2	crankle
crankled	15	40	815	2	crankled
crankles	14	35	1015	2	crankles
crankly	16	35	812	2	crankly
cranks	12	50	1531	2	crank_s
cranky	15	39	1063	2	crank_y
crapper	13	39	1319	2	crapper
crasher	12	46	1616	2	crasher
crasser	9	41	1433	2	crasser
crater	8	50	2664	2	cra_ter
craver	11	46	1846	2	cra_ver
crawler	12	35	1046	2	crawler
crazier	18	36	1074	2	crazier
cringer	10	35	1424	2	cringer
croaker	13	30	1068	2	croaker
crooker	13	41	1109	2	crooker
danker	11	43	1966	2	_danker
drinker	12	34	948	2	drinker
drunker	12	32	663	2	drunker
flanker	14	39	1129	2	flanker
franked	15	36	1005	2	franked
frankers	15	34	835	2	frankers
grander	9	33	1587	2	grander
granger	9	35	1421	2	granger
granter	8	41	1713	2	granter
hanker	13	46	2209	2	_hanker
lanker	10	41	2300	2	_lanker
prancer	11	36	1338	2	prancer
pranked	14	37	1209	2	pranked
prinker	13	34	1274	2	prinker
racker	12	48	2455	2	_racker
raker	9	45	2979	2	_ra_ker
ranger	7	39	2552	2	_ranger
ranked	11	46	2074	2	_ranked
rankers	11	32	1746	2	_rankers
ranter	6	38	2682	2	_ranter
skanker	10	26	848	2	skanker
spanker	13	36	1235	2	spanker
swanker	14	36	948	2	swanker
tanker	10	45	2112	2	_tanker
thanker	14	30	959	2	thanker
tracker	13	35	1517	2	tracker
wanker	13	42	1997	2	_wanker

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.373	479064.3
2	DLD Change Limit	107671	84	3.220	33438.2
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	3.623	49321.3