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

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

74 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
crammer	13	40	1096	(None)
clammer	13	42	1179	1	clammer
crammed	14	37	1012	1	crammed
crammers	14	36	935	1	crammers
crimmer	13	33	1077	1	crimmer
rammer	10	35	1965	1	_rammer
brimmer	13	34	880	2	brimmer
calmer	10	52	1693	2	c_almer
camber	12	44	1848	2	c_amber
camper	12	47	2221	2	c_amper
chamber	16	40	1106	2	chamber
chamfer	17	39	986	2	chamfer
champer	16	38	1341	2	champer
charmer	14	49	1366	2	charmer
claimer	11	27	988	2	claimer
clamber	13	33	1174	2	clamber
clammed	14	36	996	2	clammed
clammers	14	35	1069	2	clammers
clammier	14	3	584	2	clammier
clamper	13	40	1299	2	clamper
crabber	13	38	1073	2	crabber
cracker	15	31	1417	2	cracker
cradler	10	29	1051	2	cradler
crafter	12	41	1133	2	crafter
crambe	12	3	907	2	crambe_
crambes	13	3	996	2	crambes
cramped	14	47	1218	2	cramped
crampier	14	28	890	2	crampier
cranker	13	36	1279	2	cranker
crapper	13	39	1319	2	crapper
crasher	12	46	1616	2	crasher
crasser	9	41	1434	2	crasser
crater	8	50	2664	2	cra_ter
craver	11	46	1847	2	cra_ver
crawler	12	35	1046	2	crawler
crazier	18	36	1074	2	crazier
creamer	11	37	1409	2	creamer
creamier	12	31	906	2	creamier
crimmers	14	29	854	2	crimmers
crimper	13	65	1042	2	crimper
crumber	13	33	964	2	crumber
crummier	14	3	560	2	crummier
cummer	12	44	1459	2	c_ummer
dammer	11	43	1793	2	_dammer
drammed	13	37	807	2	drammed
drummer	12	40	750	2	drummer
framer	11	48	1744	2	fra_mer
gammer	11	123	1833	2	_gammer
grammar	12	40	689	2	grammar
gramme	11	42	1033	2	gramme_
grammes	12	36	1132	2	grammes
grimmer	12	35	1009	2	grimmer
grummer	12	33	878	2	grummer
hammer	13	81	2003	2	_hammer
jammer	17	40	1413	2	_jammer
krimmer	15	37	687	2	krimmer
mammer	9	42	1886	2	_mammer
primmer	13	43	1016	2	primmer
rammed	11	31	1730	2	_rammed
rammers	11	37	1504	2	_rammers
rammier	11	28	1102	2	_rammier
rimmer	10	35	1603	2	_rimmer
rummer	10	47	1548	2	_rummer
scammer	13	36	1197	2	scammer
scrammed	15	5	500	2	scrammed
shammer	14	46	1314	2	shammer
slammer	11	39	1303	2	slammer
spammer	13	34	1043	2	spammer
stammer	11	60	1334	2	stammer
trammed	12	38	1071	2	trammed
trammel	11	35	766	2	trammel
tramper	11	38	1216	2	tramper
trimmer	11	36	1083	2	trimmer
yammer	13	37	1318	2	_yammer

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	74	3.516	30623.2
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	3.922	45561.2