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

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

319 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
mappings	15	29	641	(None)
cappings	15	36	949	1	cappings
mapping	14	34	1399	1	mapping_
tappings	13	26	771	1	tappings
campings	15	40	1020	2	campings
capping	14	38	1967	2	capping_
carpings	13	38	1238	2	carpings
cuppings	15	33	605	2	cuppings
dampings	14	37	752	2	dampings
dapping	13	37	1479	2	dapping_
gapping	13	42	1478	2	gapping_
happing	15	38	1723	2	happing_
harpings	14	37	977	2	harpings
hoppings	16	30	652	2	hoppings
lapping	12	41	1702	2	lapping_
lapwings	14	27	497	2	lapwings
lippings	13	29	609	2	lippings
mailings	11	30	1192	2	mailings
makings	14	54	1316	2	ma_kings
mallings	11	34	1309	2	mallings
markings	15	34	1024	2	markings
marlings	11	37	1349	2	marlings
maskings	15	44	875	2	maskings
matings	10	45	1621	2	ma_tings
mattings	11	36	967	2	mattings
mayings	13	44	1051	2	ma_yings
mopping	14	34	1147	2	mopping_
napping	12	35	1418	2	napping_
rapping	12	36	1910	2	rapping_
raspings	11	33	785	2	raspings
saplings	11	26	980	2	saplings
sapping	12	35	1931	2	sapping_
tapping	12	33	1713	2	tapping_
toppings	13	28	642	2	toppings
trappings	14	26	575	2	trappings
uppings	12	25	712	2	_uppings
wapping	15	35	1460	2	wapping_
wrappings	17	25	371	2	wrappings
yapping	15	34	1261	2	yapping_
yawpings	17	25	358	2	yawpings
zapping	21	32	1147	2	zapping_
ablings	10	3	874	3	_ablings
actings	10	45	1246	3	_actings
ageings	9	43	769	3	_ageings
agings	8	63	1267	3	_a_gings
airings	8	39	1384	3	_airings
alpines	9	40	1619	3	_alpines
amping	11	43	1757	3	_amping_
antings	8	50	1558	3	_antings
aping	8	73	2723	3	_a_ping_
appends	12	3	639	3	_appends
appoints	12	8	640	3	_appoints
armings	10	38	1150	3	_armings
askings	12	51	917	3	_askings
audings	9	28	939	3	_audings
awnings	11	40	671	3	_awnings
backings	17	40	1221	3	backings
baggings	13	30	752	3	baggings
bakings	14	43	1202	3	ba_kings
bankings	15	48	940	3	bankings
bashings	14	43	1124	3	bashings
bastings	11	42	1469	3	bastings
battings	11	40	1057	3	battings
bopping	14	35	1203	3	bopping_
calkings	15	28	922	3	calkings
callings	11	36	1383	3	callings
camping	14	31	1897	3	camping_
campongs	15	35	612	3	campongs
cannings	11	37	1033	3	cannings
caplins	11	35	1599	3	caplin_s
cardings	12	38	1263	3	cardings
carlings	11	40	1585	3	carlings
carping	12	35	2108	3	carping_
carvings	14	38	1020	3	carvings
casings	10	40	1351	3	ca_sings
castings	11	36	1405	3	castings
catlings	11	37	1204	3	catlings
cavings	13	47	1254	3	ca_vings
chapping	18	37	1072	3	chapping_
clapping	15	38	1060	3	clapping_
clippings	16	27	375	3	clippings
copings	12	41	1184	3	_copings
copping	14	39	1859	3	copping_
crapping	15	39	1145	3	crapping_
cupping	14	43	1238	3	cupping_
damping	13	34	1400	3	damping_
dappling	14	3	684	3	dappling_
darings	9	37	1365	3	da_rings
darlings	10	37	1038	3	darlings
darnings	10	37	855	3	darnings
dipping	13	40	1483	3	dipping_
dopings	11	40	878	3	_dopings
drippings	15	31	390	3	drippings
droppings	15	26	450	3	droppings
dumpings	14	29	576	3	dumpings
dupping	13	37	1104	3	dupping_
eanlings	9	12	847	3	eanlings
earings	8	45	1771	3	ea_rings
earnings	9	41	933	3	earnings
earrings	9	29	963	3	earrings
eastings	9	34	1295	3	eastings
eatings	8	46	1644	3	ea_tings
emptings	13	6	482	3	emptings
facings	13	45	1126	3	fa_cings
fadings	12	46	930	3	fa_dings
failings	12	38	1101	3	failings
fairings	12	38	819	3	fairings
farmings	14	29	822	3	farmings
fastings	12	40	1194	3	fastings
fatlings	12	35	930	3	fatlings
flapping	16	29	815	3	flapping_
fopping	15	35	1113	3	fopping_
frapping	16	34	810	3	frapping_
gamings	11	46	1091	3	ga_mings
gaping	10	56	1892	3	ga_ping_
gaskings	14	42	747	3	gaskings
gasping	11	37	1436	3	gasping_
gassings	10	43	840	3	gassings
gatings	9	52	1282	3	ga_tings
gawping	14	41	846	3	gawping_
gaywings	16	3	319	3	gaywings
gipping	13	38	1312	3	gipping_
grapplings	16	4	232	3	grapplings
gypping	16	30	584	3	gypping_
hangings	13	25	858	3	hangings
happenings	18	4	262	3	happenings
happens	14	35	917	3	happen_s
happiness	16	3	599	3	happiness
harping	13	41	1838	3	harping_
harpins	12	36	1570	3	harpin_s
hasping	13	44	1490	3	hasping_
hatpins	12	34	1064	3	hatpin_s
hawkings	19	33	613	3	hawkings
hayings	14	37	939	3	ha_yings
hazings	20	37	834	3	ha_zings
helpings	14	25	565	3	helpings
hipping	15	39	1510	3	hipping_
hopping	15	41	1527	3	hopping_
imagings	12	3	455	3	ima_gings
impings	12	34	855	3	_impings
japing	16	50	1357	3	ja_ping_
jauping	17	30	719	3	jauping_
kampongs	17	29	303	3	kampongs
kartings	13	41	852	3	kartings
keepings	15	34	594	3	keepings
kepping	16	26	859	3	kepping_
kipping	16	33	1187	3	kipping_
knapping	17	31	497	3	knapping_
lacings	10	50	1365	3	la_cings
ladings	9	38	1413	3	la_dings
laggings	11	29	840	3	laggings
lakings	12	47	1351	3	la_kings
lamping	12	31	1600	3	lamping_
landings	10	31	1007	3	landings
lapins	8	45	2068	3	la_pin_s
lapsing	10	35	1116	3	lapsing_
lapwing	13	30	826	3	lapwing_
lashings	12	44	1225	3	lashings
lastings	9	42	1442	3	lastings
lathings	12	46	985	3	lathings
lawings	11	36	1147	3	la_wings
lipping	12	30	1607	3	lipping_
lopping	12	38	1522	3	lopping_
machines	15	3	1289	3	machines
macing	11	42	2155	3	ma_cing_
madding	12	37	1199	3	madding_
magpies	12	3	1036	3	magpi_es
mahjongs	21	4	181	3	mahjongs
mahuangs	14	5	288	3	mahuangs
mailing	10	29	2334	3	mailing_
maiming	12	29	1272	3	maiming_
mains	7	56	3511	3	ma__in_s
making	13	48	2385	3	ma_king_
maligns	10	3	813	3	ma_ligns
malines	9	36	2560	3	ma_lines
malkins	13	33	1180	3	malkin_s
malling	10	36	2366	3	malling_
malting	10	32	1908	3	malting_
manning	10	36	1638	3	manning_
mantlings	12	20	723	3	mantlings
mapmakings	21	4	245	3	mapmakings
mappers	13	33	1378	3	mapp_ers
marblings	14	22	554	3	marblings
margins	10	38	1519	3	margin_s
marinas	9	35	1938	3	ma_rinas
marines	9	39	2801	3	ma_rines
marking	14	40	2013	3	marking_
marlines	10	38	1871	3	marlines
marling	10	33	2276	3	marling_
marlins	9	34	2047	3	marlin_s
marring	10	33	1955	3	marring_
marting	10	33	2501	3	marting_
martinis	10	33	1161	3	martinis
martins	9	33	2206	3	martin_s
mashing	13	44	2224	3	mashing_
masking	14	51	1661	3	masking_
massing	10	43	1802	3	massing_
masting	10	43	2582	3	masting_
mating	9	48	3291	3	ma_ting_
matins	8	45	2778	3	ma_tin_s
matting	10	36	2014	3	matting_
mattins	9	33	1614	3	mattin_s
mauling	10	33	1568	3	mauling_
mavins	11	51	1918	3	ma_vin_s
mawing	12	40	2080	3	ma_wing_
maxing	16	48	1707	3	ma_xing_
maying	12	44	2115	3	ma_ying_
mayvins	15	3	532	3	mayvin_s
mazing	18	44	1897	3	ma_zing_
meanings	11	32	916	3	meanings
meetings	11	28	741	3	meetings
mendings	12	33	830	3	mendings
millings	11	37	1258	3	millings
minings	10	39	1207	3	m_inings
moldings	12	26	720	3	moldings
moorings	11	25	771	3	moorings
moping	11	40	1710	3	m_oping_
mornings	11	29	792	3	mornings
morphings	17	4	468	3	morphings
moshings	14	36	733	3	moshings
mousings	11	27	770	3	mousings
mowings	13	32	848	3	m_owings
muggings	13	24	459	3	muggings
mumping	14	34	1163	3	mumping_
muntings	11	28	981	3	muntings
musings	10	38	954	3	m_usings
napkins	13	3	667	3	napkin_s
nappies	11	46	1339	3	nappi_es
nappiness	13	3	523	3	nappiness
nipping	12	34	1287	3	nipping_
packings	17	43	1006	3	packings
paddings	13	29	701	3	paddings
pagings	11	44	1106	3	pa_gings
pairings	11	39	831	3	pairings
palings	10	39	1582	3	pa_lings
palping	12	41	1287	3	palping_
papains	11	3	1236	3	papain_s
pappies	10	32	1482	3	pappi_es
pargings	12	34	1016	3	pargings
parings	10	42	1921	3	pa_rings
parkings	15	36	1068	3	parkings
partings	11	35	1373	3	partings
passings	11	40	987	3	passings
pavings	13	40	1163	3	pa_vings
pepping	11	35	1162	3	pepping_
pings	8	58	3088	3	___pings
pipings	12	33	825	3	_pipings
pipping	11	34	1474	3	pipping_
pippins	10	31	975	3	pippin_s
popping	11	37	1541	3	popping_
pupping	11	44	1250	3	pupping_
racings	10	50	1513	3	ra_cings
railings	9	34	1215	3	railings
raisings	9	33	844	3	raisings
ramping	12	33	1687	3	ramping_
rankings	13	38	917	3	rankings
rapines	9	51	2086	3	ra_pines
raping	9	48	2985	3	ra_ping_
rappini	11	34	757	3	rappin_i
rasping	10	43	1625	3	rasping_
ratings	8	42	1741	3	ra_tings
ravings	11	46	1450	3	ra_vings
remapping	16	3	502	3	remapping_
repping	12	33	1498	3	repping_
ripping	12	33	1574	3	ripping_
sackings	15	38	963	3	sackings
sacrings	11	27	892	3	sacrings
sailings	9	35	1325	3	sailings
salpinges	12	4	452	3	salpinges
saltings	9	28	1125	3	saltings
samplings	14	3	555	3	samplings
sapling	10	32	1786	3	sapling_
sappiness	13	3	743	3	sappiness
savings	11	44	1295	3	sa_vings
sayings	11	36	1083	3	sa_yings
shippings	17	27	568	3	shippings
shoppings	17	29	507	3	shoppings
sipping	12	31	1743	3	sipping_
slapping	13	35	1083	3	slapping_
snapping	13	34	965	3	snapping_
sopping	12	39	1720	3	sopping_
spacings	13	28	704	3	spacings
spaeings	11	27	625	3	spaeings
springs	10	44	1592	3	_springs
strappings	15	4	335	3	strappings
supping	12	38	1453	3	supping_
swapping	16	34	867	3	swapping_
tailings	9	32	1167	3	tailings
takings	12	45	1257	3	ta_kings
talkings	13	35	840	3	talkings
tamping	12	28	1581	3	tamping_
tannings	9	26	863	3	tannings
taping	9	42	2239	3	ta_ping_
tattings	9	40	882	3	tattings
tipping	12	28	1497	3	tipping_
topping	12	35	1462	3	topping_
trapping	13	29	1139	3	trapping_
trippings	14	22	572	3	trippings
tupping	12	34	1166	3	tupping_
upping	11	40	1370	3	_upping_
vamping	15	28	1023	3	vamping_
vaporings	15	4	409	3	vaporings
waddings	14	35	647	3	waddings
waitings	12	34	1374	3	waitings
walkings	16	32	731	3	walkings
warnings	12	35	845	3	warnings
warping	13	37	1518	3	warping_
washings	15	41	927	3	washings
waxings	18	36	645	3	wa_xings
waxwings	22	3	295	3	waxwings
weepings	14	34	648	3	weepings
whapping	19	31	711	3	whapping_
whippings	20	28	418	3	whippings
wrapping	16	29	762	3	wrapping_
yappingly	20	4	379	3	yappingly
yauping	13	35	724	3	yauping_
yawping	16	35	733	3	yawping_
yipping	15	27	1068	3	yipping_
zipping	21	29	1057	3	zipping_

Search took 8 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	146162	0.406	440125.6
2	DLD Change Limit	146162	319	6.893	21204.4
3	Display Results	319	319	0.123	2593.5
	(SQL Overall)	178691	319	7.422	24075.9