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

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

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

138 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
scramming	16	3	488	(None)
cramming	15	33	943	1	_cramming
scamming	15	32	854	1	sc_amming
scrumming	16	5	402	1	scrumming
clamming	15	32	937	2	_clamming
cramping	15	34	1185	2	_cramping
dramming	14	34	757	2	_dramming
ramming	12	31	1506	2	__ramming
scamping	15	35	1019	2	sc_amping
scragging	14	3	527	2	scragging
scrambling	17	4	347	2	scrambling
scraping	13	33	1086	2	scra_ping
scrapping	16	3	574	2	scrapping
scrawling	15	19	558	2	scrawling
screaming	14	21	783	2	screaming
scrimping	16	3	495	2	scrimping
scumming	15	25	679	2	sc_umming
shamming	16	28	941	2	s_hamming
slamming	13	33	1000	2	s_lamming
spamming	15	31	760	2	s_pamming
strumming	14	5	441	2	strumming
tramming	13	27	934	2	_tramming
bamming	14	46	1181	3	__bamming
brimming	15	19	662	3	_brimming
calming	12	39	1597	3	_c_alming
camping	14	31	1897	3	_c_amping
caroming	13	33	1296	3	_caroming
chammying	22	4	335	3	_chammying
champing	18	36	1093	3	_champing
charming	16	30	1203	3	_charming
chumming	18	36	620	3	_chumming
claiming	13	27	930	3	_claiming
clamping	15	40	1115	3	_clamping
coaming	12	38	1832	3	_coa_ming
craaling	11	27	1135	3	_craaling
crabbing	15	28	793	3	_crabbing
cracking	17	40	1390	3	_cracking
cradling	12	24	1145	3	_cradling
crafting	14	37	1017	3	_crafting
craning	10	36	2030	3	_cra_ning
cranking	15	46	1307	3	_cranking
craping	12	40	1871	3	_cra_ping
crapping	15	39	1145	3	_crapping
crashing	14	35	1263	3	_crashing
crating	10	37	2520	3	_cra_ting
craving	13	40	1573	3	_cra_ving
crawling	14	31	1051	3	_crawling
crazing	19	39	1458	3	_cra_zing
creaming	13	34	1314	3	_creaming
crimping	15	29	978	3	_crimping
crumbing	15	26	781	3	_crumbing
crumping	15	31	990	3	_crumping
damming	13	38	1274	3	__damming
drumming	14	26	578	3	_drumming
flamming	16	35	715	3	_flamming
framing	13	30	1479	3	_fra_ming
gamming	13	31	1262	3	__gamming
hamming	15	30	1409	3	__hamming
jamming	19	32	979	3	__jamming
lamming	12	30	1458	3	__lamming
primming	15	26	817	3	_primming
ramping	12	33	1687	3	__ramping
rimming	12	34	1107	3	__rimming
salaaming	12	6	536	3	salaaming
scabbing	15	27	719	3	sc_abbing
scalding	12	33	939	3	sc_alding
scaling	10	35	1937	3	sc_a_ling
scalping	13	34	1045	3	sc_alping
scammony	17	4	302	3	sc_ammony
scanning	11	33	1077	3	sc_anning
scanting	11	39	1476	3	sc_anting
scaping	12	37	1569	3	sc_a_ping
scarfing	14	30	971	3	sc_arfing
scaring	10	34	2197	3	sc_a_ring
scarphing	17	3	524	3	scarphing
scarping	13	33	1246	3	sc_arping
scarring	11	25	1151	3	sc_arring
scarting	11	34	1526	3	sc_arting
scathing	14	26	970	3	sc_athing
scatting	11	33	1181	3	sc_atting
scheming	16	3	663	3	sc_heming
sclaffing	18	4	336	3	sclaffing
scrabbling	17	4	285	3	scrabbling
scraiching	18	4	379	3	scraiching
scraighing	17	4	293	3	scraighing
scrammed	15	5	500	3	scramm_ed
scrapings	14	25	517	3	scra_pings
scratching	18	4	453	3	scratching
screaking	16	22	824	3	screaking
screeding	13	3	632	3	screeding
screening	12	4	719	3	screening
screwing	14	28	823	3	scr_ewing
scribing	13	23	818	3	scr_ibing
scrieving	15	3	413	3	scrieving
scrimmaging	19	5	125	3	scrimmaging
scripting	14	3	747	3	scripting
scriving	14	25	876	3	scr_iving
scrolling	12	18	780	3	scrolling
scrooping	14	4	659	3	scrooping
scrouging	13	3	526	3	scrouging
scrubbing	16	3	393	3	scrubbing
scrummaging	19	5	114	3	scrummaging
scrupling	14	3	519	3	scrupling
scrying	13	3	866	3	scr__ying
seaming	10	32	2211	3	s_ea_ming
shaming	13	30	1674	3	s_ha_ming
shammying	20	4	295	3	s_hammying
shimming	16	27	825	3	s_himming
shrimping	17	3	406	3	shrimping
skimming	17	28	627	3	s_kimming
slammings	14	23	412	3	s_lammings
slimming	13	28	809	3	s_limming
slumming	13	27	838	3	s_lumming
spasming	13	22	720	3	s_pasming
spraining	12	4	815	3	spraining
sprawling	15	17	512	3	sprawling
spraying	14	29	988	3	spra_ying
stamping	13	33	1096	3	s_tamping
steaming	11	40	1321	3	stea_ming
stemming	13	40	820	3	s_temming
strafing	12	21	1119	3	stra_fing
straining	10	4	1056	3	straining
stranding	11	4	965	3	stranding
strapping	14	3	699	3	strapping
strawing	12	24	1162	3	stra_wing
straying	12	29	1269	3	stra_ying
streaming	12	23	965	3	streaming
stumming	13	34	767	3	s_tumming
summing	12	29	1238	3	s__umming
surnaming	12	4	514	3	surnaming
swamping	16	30	792	3	s_wamping
swarming	14	5	822	3	s_warming
swimming	16	31	632	3	s_wimming
thrumming	17	4	290	3	thrumming
tramping	13	27	1127	3	_tramping
trimming	13	31	865	3	_trimming
unjamming	21	4	304	3	unjamming
whamming	19	27	522	3	_whamming

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	148641	0.423	422437.4
2	DLD Change Limit	148641	138	7.720	19254.0
3	Display Results	138	138	0.060	2300.0
	(SQL Overall)	178691	138	8.203	21783.6