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

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

88 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
wisping	13	37	1194	(None)
lisping	10	34	1275	1	lisping
wimping	15	39	1101	1	wimping
wiping	12	39	1671	1	wi_ping
wishing	14	41	1489	1	wishing
wising	10	33	1822	1	wis_ing
wissing	11	32	1294	1	wissing
wisting	11	35	1974	1	wisting
crisping	13	31	966	2	crisping
dipping	13	40	1483	2	dipping
discing	11	39	1459	2	discing
dishing	12	40	1710	2	dishing
disking	13	46	1549	2	disking
dissing	9	45	1768	2	dissing
fishing	14	39	1386	2	fishing
fisting	11	38	1812	2	fisting
gasping	11	37	1436	2	gasping
gimping	13	37	1076	2	gimping
gipping	13	38	1312	2	gipping
hasping	13	44	1490	2	hasping
hipping	15	39	1510	2	hipping
hissing	11	42	1314	2	hissing
histing	11	37	2037	2	histing
imping	11	43	1535	2	_imping
isling	7	12	1388	2	_isling
kipping	16	33	1187	2	kipping
kissing	12	29	1105	2	kissing
limping	12	46	1411	2	limping
lipping	12	30	1607	2	lipping
listing	8	40	2059	2	listing
missing	10	36	1907	2	missing
misting	10	36	2338	2	misting
nipping	12	34	1287	2	nipping
pimping	14	38	1212	2	pimping
piping	11	40	1745	2	pi_ping
pipping	11	34	1474	2	pipping
pishing	13	43	1437	2	pishing
pissing	10	39	1480	2	pissing
rasping	10	43	1625	2	rasping
riping	9	38	2161	2	ri_ping
ripping	12	33	1574	2	ripping
rising	7	40	2588	2	ris_ing
risking	12	39	1424	2	risking
siping	9	42	2063	2	si_ping
sipping	12	31	1743	2	sipping
swiping	13	31	982	2	swi_ping
swishing	15	27	781	2	swishing
tipping	12	28	1497	2	tipping
twisting	12	42	781	2	twisting
visaing	11	27	933	2	visaing
viseing	11	29	916	2	viseing
vising	10	39	1587	2	vis_ing
waisting	12	36	1521	2	waisting
wapping	15	35	1460	2	wapping
warping	13	37	1518	2	warping
washing	14	51	1928	2	washing
wasting	11	44	2284	2	wasting
weeping	13	36	1367	2	weeping
westing	11	50	2027	2	westing
whipping	19	32	817	2	whipping
whishing	18	28	718	2	whishing
whisking	19	28	661	2	whisking
whisting	15	32	954	2	whisting
wicking	17	34	1477	2	wicking
wifing	13	35	1339	2	wi_fing
wigging	13	34	1383	2	wigging
wilding	12	38	1429	2	wilding
wiling	10	30	2429	2	wi_ling
willing	11	38	2161	2	willing
wilting	11	35	1591	2	wilting
wimpling	16	20	748	2	wimpling
wincing	13	34	1390	2	wincing
winding	12	35	1791	2	winding
winging	12	37	1871	2	winging
wining	10	36	2505	2	wi_ning
winking	15	33	1796	2	winking
winning	11	35	1655	2	winning
wiring	10	45	2102	2	wi_ring
wispier	12	24	940	2	wispier
wispily	15	3	565	2	wispily
wispish	15	7	564	2	wispish
withing	14	38	1449	2	withing
witing	10	35	2282	2	wi_ting
witling	11	32	1581	2	witling
witting	11	34	1706	2	witting
wiving	13	33	1660	2	wi_ving
yipping	15	27	1068	2	yipping
zipping	21	29	1057	2	zipping

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.360	496363.9
2	DLD Change Limit	107671	88	3.390	31761.4
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	3.780	47272.8