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

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

59 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
pipings	12	33	825	(None)
pilings	10	33	1361	1	pilings
piping	11	40	1745	1	piping_
airings	8	39	1384	2	airings
copings	12	41	1184	2	copings
dopings	11	40	878	2	dopings
filings	11	52	1307	2	filings
finings	11	43	1177	2	finings
firings	11	41	1233	2	firings
fixings	18	34	744	2	fixings
hidings	12	34	970	2	hidings
icings	9	42	845	2	_icings
impings	12	34	855	2	impings
likings	12	53	941	2	likings
linings	8	43	1307	2	linings
lipins	8	50	1688	2	lipin_s
lippings	13	29	609	2	lippings
livings	11	40	892	2	livings
minings	10	39	1207	2	minings
pagings	11	44	1106	2	pagings
pairings	11	39	831	2	pairings
palings	10	39	1582	2	palings
parings	10	42	1921	2	parings
pavings	13	40	1163	2	pavings
pepinos	11	3	769	2	pepinos
pickings	17	35	938	2	pickings
piecings	13	4	534	2	piecings
pieing	9	39	1765	2	pieing_
piing	8	52	1883	2	pi_ing_
piking	13	37	1964	2	piking_
piling	9	50	2559	2	piling_
pimping	14	38	1212	2	pimping_
pinangs	10	26	779	2	pinangs
pings	8	58	3088	2	__pings
pining	9	37	2653	2	pining_
pinkings	15	33	814	2	pinkings
pipiness	12	3	800	2	pipiness
pipingly	16	3	570	2	pipingly
pipits	10	47	1306	2	pipi_ts
pipkins	15	32	818	2	pipkin_s
pipping	11	34	1474	2	pipping_
pippins	10	31	975	2	pippin_s
pittings	11	34	912	2	pittings
primings	13	33	814	2	primings
pulings	10	35	1132	2	pulings
ridings	9	34	1209	2	ridings
riping	9	38	2161	2	riping_
risings	8	32	1189	2	risings
sidings	9	40	1146	2	sidings
siping	9	42	2063	2	siping_
sizings	17	37	801	2	sizings
spilings	11	30	881	2	spilings
tidings	9	38	1026	2	tidings
tilings	8	42	1279	2	tilings
timings	10	27	930	2	timings
uppings	12	25	712	2	uppings
vikings	15	38	662	2	vikings
wiping	12	39	1671	2	wiping_
wirings	11	39	1011	2	wirings

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.376	475242.0
2	DLD Change Limit	107671	59	3.356	32083.1
3	Display Results	59	59	0.033	1787.9
	(SQL Overall)	178691	59	3.765	47461.1