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

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

135 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
lamping	12	31	1600	(None)
amping	11	43	1757	1	_amping
camping	14	31	1897	1	camping
clamping	15	40	1115	1	clamping
damping	13	34	1400	1	damping
lambing	12	34	1241	1	lambing
laming	9	45	2836	1	lam_ing
lamming	12	30	1458	1	lamming
lapping	12	41	1702	1	lapping
limping	12	46	1411	1	limping
lumping	12	33	1464	1	lumping
ramping	12	33	1687	1	ramping
tamping	12	28	1581	1	tamping
vamping	15	28	1023	1	vamping
aping	8	73	2723	2	_a_ping
bamming	14	46	1181	2	bamming
blaming	12	35	1569	2	blam_ing
bumping	14	38	1249	2	bumping
campings	15	40	1020	2	campings
campong	14	31	812	2	campong
capping	14	38	1967	2	capping
carping	12	35	2108	2	carping
champing	18	36	1093	2	champing
clamming	15	32	937	2	clamming
clapping	15	38	1060	2	clapping
clasping	13	33	1026	2	clasping
clomping	15	32	965	2	clomping
clumping	15	31	988	2	clumping
comping	14	35	1859	2	comping
cramping	15	34	1185	2	cramping
damming	13	38	1274	2	damming
damning	11	42	1163	2	damning
dampings	14	37	752	2	dampings
dapping	13	37	1479	2	dapping
dumping	13	37	1291	2	dumping
faming	12	49	2297	2	fam_ing
flaming	13	42	1644	2	flam_ing
flamming	16	35	715	2	flamming
flapping	16	29	815	2	flapping
flumping	16	28	758	2	flumping
gaming	10	46	2204	2	gam_ing
gamming	13	31	1262	2	gamming
gaping	10	56	1892	2	ga_ping
gapping	13	42	1478	2	gapping
gasping	11	37	1436	2	gasping
gawping	14	41	846	2	gawping
gimping	13	37	1076	2	gimping
hamming	15	30	1409	2	hamming
happing	15	38	1723	2	happing
harping	13	41	1838	2	harping
hasping	13	44	1490	2	hasping
humping	15	32	1307	2	humping
imping	11	43	1535	2	_imping
jambing	19	32	853	2	jambing
jamming	19	32	979	2	jamming
japing	16	50	1357	2	ja_ping
jauping	17	30	719	2	jauping
jumping	19	31	980	2	jumping
kampong	16	29	493	2	kampong
lacing	9	46	2623	2	la_cing
lacking	14	38	2154	2	lacking
lading	8	42	2712	2	la_ding
ladling	9	28	1339	2	ladling
lagging	10	33	1674	2	lagging
lairing	8	37	1534	2	lairing
laking	11	50	2704	2	la_king
lalling	8	35	1963	2	lalling
lamina	8	49	2044	2	lam_ina
lampion	11	27	830	2	lampion
lampions	12	27	797	2	lampions
lancing	10	33	1412	2	lancing
landing	9	28	1932	2	landing
lapin	7	52	2292	2	la_pin_
lapins	8	45	2068	2	la_pins
lapsing	10	35	1116	2	lapsing
lapwing	13	30	826	2	lapwing
larding	9	29	1787	2	larding
larking	12	37	1825	2	larking
lashing	11	44	2289	2	lashing
lasing	7	47	2798	2	la_sing
lasting	8	47	2524	2	lasting
lathing	11	43	1569	2	lathing
lauding	9	32	1190	2	lauding
laving	10	46	2357	2	la_ving
lawing	10	46	2528	2	la_wing
laying	10	45	2570	2	la_ying
lazing	16	48	2147	2	la_zing
lazying	20	4	667	2	lazying
leaping	10	32	1599	2	leaping
lemming	12	26	939	2	lemming
limbing	12	34	1042	2	limbing
liming	9	40	2124	2	lim_ing
limning	10	37	1032	2	limning
lipping	12	30	1607	2	lipping
lisping	10	34	1275	2	lisping
loaming	10	36	1373	2	loam_ing
looping	10	36	1528	2	looping
loping	9	39	2141	2	l_oping
lopping	12	38	1522	2	lopping
louping	10	43	1398	2	louping
mapping	14	34	1399	2	mapping
mumping	14	34	1163	2	mumping
naming	9	39	1789	2	nam_ing
napping	12	35	1418	2	napping
palping	12	41	1287	2	palping
pimping	14	38	1212	2	pimping
plumping	15	27	763	2	plumping
pumping	14	42	1355	2	pumping
ramming	12	31	1506	2	ramming
raping	9	48	2985	2	ra_ping
rapping	12	36	1910	2	rapping
rasping	10	43	1625	2	rasping
romping	12	31	1303	2	romping
sampling	13	5	1064	2	sampling
sapping	12	35	1931	2	sapping
scamping	15	35	1019	2	scamping
slamming	13	33	1000	2	slamming
slapping	13	35	1084	2	slapping
slumping	13	35	997	2	slumping
stamping	13	33	1096	2	stamping
swamping	16	30	792	2	swamping
taming	9	40	2343	2	tam_ing
taping	9	42	2239	2	ta_ping
tapping	12	33	1713	2	tapping
temping	12	27	1069	2	temping
tramping	13	27	1127	2	tramping
tumping	12	31	1424	2	tumping
umping	11	48	1533	2	_umping
wapping	15	35	1460	2	wapping
warping	13	37	1518	2	warping
wimping	15	39	1101	2	wimping
yapping	15	34	1261	2	yapping
yauping	13	35	724	2	yauping
yawping	16	35	733	2	yawping
zapping	21	32	1147	2	zapping

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.390	458182.1
2	DLD Change Limit	107671	135	2.970	36252.9
3	Display Results	135	135	0.046	2934.8
	(SQL Overall)	178691	135	3.406	52463.6