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

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

175 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
wiping	12	39	1671	(None)
piping	11	40	1745	1	piping
riping	9	38	2161	1	riping
siping	9	42	2063	1	siping
swiping	13	31	982	1	swiping
wifing	13	35	1339	1	wifing
wiling	10	30	2429	1	wiling
wimping	15	39	1101	1	wimping
wining	10	36	2505	1	wining
wiring	10	45	2102	1	wiring
wising	10	33	1822	1	wising
wisping	13	37	1194	1	wisping
witing	10	35	2282	1	witing
wiving	13	33	1660	1	wiving
aiding	8	44	2361	2	aiding
ailing	7	43	3101	2	ailing
aiming	9	43	2084	2	aiming
airing	7	49	2750	2	airing
amping	11	43	1757	2	amping
aping	8	73	2723	2	_aping
biding	10	47	2079	2	biding
biking	13	50	1817	2	biking
biting	9	53	2182	2	biting
citing	9	42	2018	2	citing
coping	11	39	2766	2	coping
dicing	10	57	1876	2	dicing
dieing	8	40	1865	2	dieing
diking	12	43	2024	2	diking
dining	8	45	2513	2	dining
dipping	13	40	1483	2	dipping
diving	11	37	1795	2	diving
doping	10	39	1946	2	doping
duping	10	41	1363	2	duping
dwining	12	26	929	2	dwining
fifing	13	42	1234	2	fifing
filing	10	38	2376	2	filing
fining	10	42	2321	2	fining
firing	10	40	2172	2	firing
fixing	17	48	1378	2	fixing
gaping	10	56	1892	2	gaping
gibing	10	37	1235	2	gibing
gieing	8	36	1485	2	gieing
gimping	13	37	1076	2	gimping
gipping	13	38	1312	2	gipping
giving	11	43	1388	2	giving
griping	11	30	1206	2	griping
hiding	11	43	1933	2	hiding
hieing	10	42	1662	2	hieing
hiking	14	36	1710	2	hiking
hipping	15	39	1510	2	hipping
hiring	10	44	2160	2	hiring
hiving	13	41	1552	2	hiving
hoping	12	37	1974	2	hoping
hyping	15	40	848	2	hyping
icing	8	60	1775	2	_icing
imping	11	43	1535	2	imping
iring	6	60	2542	2	_iring
japing	16	50	1357	2	japing
jibing	16	37	962	2	jibing
jiving	17	37	1160	2	jiving
kipping	16	33	1187	2	kipping
kiting	11	41	1709	2	kiting
liking	11	43	1958	2	liking
liming	9	40	2124	2	liming
limping	12	46	1411	2	limping
lining	7	45	2680	2	lining
lipin	7	55	1889	2	lipin_
lipins	8	50	1688	2	lipins
lipping	12	30	1607	2	lipping
lisping	10	34	1275	2	lisping
living	10	43	1832	2	living
loping	9	39	2141	2	loping
miking	13	42	1846	2	miking
miming	11	43	1726	2	miming
mining	9	42	2545	2	mining
miring	9	37	2380	2	miring
mixing	16	47	1394	2	mixing
moping	11	40	1710	2	moping
niding	8	32	1797	2	niding
nipping	12	34	1287	2	nipping
nixing	14	33	1149	2	nixing
oiling	7	49	2531	2	oiling
oping	8	63	2241	2	_oping
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
ping	7	59	4359	2	__ping
pining	9	37	2653	2	pining
pipings	12	33	825	2	pipings
pipping	11	34	1474	2	pipping
raping	9	48	2985	2	raping
ricing	9	48	2276	2	ricing
riding	8	43	2596	2	riding
riling	7	42	2797	2	riling
riming	9	33	2222	2	riming
ripping	12	33	1574	2	ripping
rising	7	40	2588	2	rising
riving	10	45	2142	2	riving
roping	9	40	2302	2	roping
siding	8	38	2213	2	siding
sipping	12	31	1743	2	sipping
siring	7	51	2831	2	siring
siting	7	41	2662	2	siting
sizing	16	36	1644	2	sizing
sliping	10	33	1441	2	sliping
sniping	10	37	1205	2	sniping
swiving	14	35	895	2	swiving
taping	9	42	2239	2	taping
tiding	8	35	2009	2	tiding
tieing	7	35	1876	2	tieing
tiling	7	34	2655	2	tiling
timing	9	36	1930	2	timing
tining	7	49	2754	2	tining
tipping	12	28	1497	2	tipping
tiring	7	40	2309	2	tiring
toping	9	41	2299	2	toping
twining	11	32	1144	2	twining
typing	12	41	1058	2	typing
umping	11	48	1533	2	umping
upping	11	40	1370	2	upping
urping	9	39	1405	2	urping
vicing	12	40	1424	2	vicing
viking	14	34	1461	2	viking
vining	10	46	1946	2	vining
vising	10	39	1587	2	vising
wading	11	46	1953	2	wading
waging	11	43	1838	2	waging
waifing	14	29	1089	2	waifing
wailing	11	36	2090	2	wailing
wairing	11	34	1431	2	wairing
waiting	11	36	1895	2	waiting
waiving	14	32	963	2	waiving
waking	14	48	2138	2	waking
waling	10	45	2530	2	waling
waning	10	36	2380	2	waning
wapping	15	35	1460	2	wapping
waring	10	50	2944	2	waring
warping	13	37	1518	2	warping
waving	13	40	1820	2	waving
waxing	17	42	1528	2	waxing
weeping	13	36	1367	2	weeping
whiling	14	35	1174	2	whiling
whining	14	33	1167	2	whining
whipping	19	32	817	2	whipping
whiting	14	33	1130	2	whiting
wicking	17	34	1477	2	wicking
wigging	13	34	1383	2	wigging
wilding	12	38	1429	2	wilding
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
wing	8	63	3922	2	w__ing
winging	12	37	1871	2	winging
winking	15	33	1796	2	winking
winning	11	35	1655	2	winning
wirings	11	39	1010	2	wirings
wishing	14	41	1489	2	wishing
wissing	11	32	1294	2	wissing
wisting	11	35	1974	2	wisting
withing	14	38	1449	2	withing
witling	11	32	1581	2	witling
witting	11	34	1706	2	witting
wooing	10	42	1466	2	wooing
wowing	13	39	1539	2	wowing
wring	9	59	2071	2	w_ring
writing	11	37	1389	2	writing
wrying	13	37	962	2	wrying
wyling	13	36	855	2	wyling
wyting	13	27	724	2	wyting
yipping	15	27	1068	2	yipping
zipping	21	29	1057	2	zipping

Search took 3 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	82551	0.106	1685764.2
2	DLD Change Limit	82551	175	2.360	34979.2
3	Display Results	175	175	0.063	2777.8
	(SQL Overall)	178691	175	2.529	70656.8