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

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

142 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
pelting	10	29	1727	(None)
belting	10	41	1913	1	belting
felting	11	35	1521	1	felting
melting	10	33	1775	1	melting
petting	10	37	2095	1	petting
welting	11	36	1531	1	welting
beating	10	43	2687	2	beating
belling	10	38	2507	2	belling
beltings	11	36	925	2	beltings
belying	13	36	1244	2	belying
besting	10	49	2392	2	besting
betting	10	39	2140	2	betting
bolting	10	44	1676	2	bolting
celling	10	39	2126	2	celling
delating	10	31	1960	2	delating
deleing	9	33	1395	2	deleing
deleting	10	33	1442	2	deleting
delving	12	37	1157	2	delving
denting	9	44	2218	2	denting
eating	7	51	3440	2	_eating
elating	8	34	2308	2	_elating
eluting	8	41	1529	2	_eluting
felling	11	33	2113	2	felling
feltings	12	31	790	2	feltings
feting	10	44	1779	2	fe_ting
fetting	11	35	1787	2	fetting
gelating	10	30	1573	2	gelating
gelding	10	39	1179	2	gelding
gelling	9	32	1976	2	gelling
getting	9	33	1656	2	getting
halting	11	44	1907	2	halting
heating	11	40	2432	2	heating
hefting	14	45	1091	2	hefting
helling	11	46	2322	2	helling
helming	13	37	1200	2	helming
helping	13	35	1222	2	helping
helving	14	40	1113	2	helving
henting	11	37	1965	2	henting
hilting	11	33	1689	2	hilting
jelling	15	35	1661	2	jelling
jesting	15	43	1771	2	jesting
jetting	15	38	1534	2	jetting
jilting	15	32	1174	2	jilting
jolting	15	34	1091	2	jolting
kelping	14	31	919	2	kelping
kilting	12	32	1385	2	kilting
letting	8	32	1853	2	letting
lilting	8	35	1538	2	lilting
malting	10	32	1908	2	malting
meeting	10	33	1496	2	meeting
melding	11	34	1427	2	melding
melling	10	28	2263	2	melling
meting	9	43	2059	2	me_ting
milting	10	36	1912	2	milting
molting	10	35	1717	2	molting
nesting	8	43	2044	2	nesting
netting	8	40	1876	2	netting
paling	9	35	3013	2	pal_ing
palling	10	40	2448	2	palling
palming	12	39	1401	2	palming
palping	12	41	1287	2	palping
panting	10	40	2542	2	panting
parting	10	35	2738	2	parting
pasting	10	38	2655	2	pasting
patting	10	37	2234	2	patting
peacing	12	41	1707	2	peacing
peaking	14	43	1769	2	peaking
pealing	10	41	2320	2	pealing
peching	15	45	1390	2	peching
pecking	16	40	1778	2	pecking
pectin	10	26	1553	2	pectin_
pectins	11	23	1523	2	pectins
peeing	9	46	1808	2	pe_eing
peeking	14	44	1495	2	peeking
peeling	10	29	1987	2	peeling
peening	10	33	1830	2	peening
peeping	12	36	1521	2	peeping
peering	10	35	2035	2	peering
peeving	13	51	1224	2	peeving
pegging	12	28	1113	2	pegging
peining	10	46	1915	2	peining
peising	10	34	1676	2	peising
pelleting	12	3	795	2	pelleting
peltering	12	20	1167	2	peltering
pending	11	41	1977	2	pending
penning	10	36	1649	2	penning
pepping	11	35	1162	2	pepping
perking	14	37	1646	2	perking
perming	12	34	1609	2	perming
pestling	11	10	1025	2	pestling
pettings	11	34	970	2	pettings
pettling	11	6	821	2	pettling
piling	9	50	2559	2	pil_ing
pilling	10	37	2256	2	pilling
piloting	11	3	969	2	piloting
pitting	10	36	1887	2	pitting
plating	10	38	2307	2	plating
pleating	11	29	1605	2	pleating
plying	12	43	1208	2	p_lying
poling	9	35	2650	2	pol_ing
polling	10	29	2038	2	polling
porting	10	30	2178	2	porting
posting	10	56	2224	2	posting
potting	10	37	2089	2	potting
pouting	10	35	1994	2	pouting
prating	10	34	2445	2	prating
puling	9	36	2140	2	pul_ing
pulling	10	38	2107	2	pulling
pulping	12	36	1232	2	pulping
pulsing	10	37	1286	2	pulsing
punting	10	33	1844	2	punting
putting	10	32	1857	2	putting
relating	9	27	2544	2	relating
relying	11	29	1461	2	relying
renting	8	40	2685	2	renting
resting	8	50	3118	2	resting
retting	8	34	2588	2	retting
salting	8	41	2079	2	salting
seating	8	41	3068	2	seating
selfing	11	29	1162	2	selfing
selling	8	32	2583	2	selling
setting	8	36	2139	2	setting
silting	8	33	2048	2	silting
smelting	11	33	971	2	smelting
spelling	11	33	1523	2	spelling
telling	8	33	2108	2	telling
tenting	8	46	2115	2	tenting
testing	8	60	2105	2	testing
tilting	8	34	1710	2	tilting
venting	11	42	1809	2	venting
vesting	11	46	1868	2	vesting
vetting	11	42	1656	2	vetting
weeting	11	38	1605	2	weeting
welding	12	32	1325	2	welding
welling	11	29	2031	2	welling
weltings	12	38	820	2	weltings
westing	11	50	2027	2	westing
wetting	11	41	1738	2	wetting
wilting	11	35	1591	2	wilting
yelling	11	35	1670	2	yelling
yelping	13	31	787	2	yelping
zesting	17	45	1533	2	zesting

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	142	3.110	34620.9
3	Display Results	142	142	0.046	3087.0
	(SQL Overall)	178691	142	3.546	50392.3