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

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

205 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
piking	13	37	1964	(None)
biking	13	50	1817	1	biking
diking	12	43	2024	1	diking
hiking	14	36	1710	1	hiking
liking	11	43	1958	1	liking
miking	13	42	1846	1	miking
paiking	14	38	1481	1	paiking
picking	16	34	1833	1	picking
pieing	9	39	1765	1	pieing
piing	8	52	1883	1	pi_ing
piling	9	50	2559	1	piling
pining	9	37	2653	1	pining
pinking	14	39	1894	1	pinking
piping	11	40	1745	1	piping
poking	13	38	1930	1	poking
puking	13	39	1306	1	puking
spiking	14	43	1288	1	spiking
viking	14	34	1461	1	viking
aiding	8	44	2361	2	aiding
ailing	7	43	3101	2	ailing
aiming	9	43	2084	2	aiming
airing	7	49	2750	2	airing
asking	11	60	1723	2	asking
baking	13	56	2662	2	baking
biding	10	47	2079	2	biding
bikini	12	41	891	2	bikini
bilking	14	44	1355	2	bilking
biting	9	53	2182	2	biting
caking	13	46	2467	2	caking
citing	9	42	2018	2	citing
coking	13	45	2388	2	coking
deking	12	56	1455	2	deking
dicing	10	57	1876	2	dicing
dicking	15	36	1761	2	dicking
dieing	8	40	1865	2	dieing
dining	8	45	2513	2	dining
dinking	13	36	1828	2	dinking
dirking	13	38	1260	2	dirking
disking	13	46	1549	2	disking
diving	11	37	1795	2	diving
duking	12	47	1513	2	duking
dyking	15	45	801	2	dyking
eking	10	66	1498	2	_eking
faking	14	55	2098	2	faking
fifing	13	42	1234	2	fifing
filing	10	38	2376	2	filing
fining	10	42	2321	2	fining
finking	15	40	1660	2	finking
firing	10	40	2172	2	firing
fixing	17	48	1378	2	fixing
gibing	10	37	1235	2	gibing
gieing	8	36	1485	2	gieing
giving	11	43	1388	2	giving
hiding	11	43	1933	2	hiding
hieing	10	42	1662	2	hieing
hiring	10	44	2160	2	hiring
hiving	13	41	1552	2	hiving
hoking	14	44	1951	2	hoking
icing	8	60	1775	2	_icing
inking	11	51	1905	2	inking
iring	6	60	2542	2	_iring
irking	11	46	1175	2	irking
jibing	16	37	962	2	jibing
jinking	19	36	1354	2	jinking
jiving	17	37	1160	2	jiving
joking	18	41	1302	2	joking
juking	18	38	1047	2	juking
kicking	13	33	1402	2	kicking
king	9	59	3366	2	__king
kinking	11	36	1515	2	kinking
kiting	11	41	1709	2	kiting
laking	11	50	2704	2	laking
licking	14	41	1828	2	licking
likings	12	53	941	2	likings
liming	9	40	2124	2	liming
lining	7	45	2680	2	lining
linking	12	38	1825	2	linking
living	10	43	1832	2	living
making	13	48	2385	2	making
milking	14	37	1276	2	milking
miming	11	43	1726	2	miming
mining	9	42	2545	2	mining
miring	9	37	2380	2	miring
mixing	16	47	1394	2	mixing
nicking	14	35	1632	2	nicking
niding	8	32	1798	2	niding
nixing	14	33	1149	2	nixing
nuking	11	34	1125	2	nuking
oiling	7	49	2531	2	oiling
oinking	12	37	1471	2	oinking
opining	10	3	1174	2	opining
pacing	11	45	2275	2	pacing
packing	16	44	2072	2	packing
paging	10	40	2040	2	paging
paining	10	39	2024	2	paining
pairing	10	37	1673	2	pairing
paling	9	35	3013	2	paling
paring	9	42	3649	2	paring
parking	14	34	2304	2	parking
paving	12	45	1974	2	paving
pawing	12	45	1955	2	pawing
paying	12	37	2216	2	paying
peaking	14	43	1769	2	peaking
pecking	16	40	1778	2	pecking
peeing	9	46	1808	2	peeing
peeking	14	44	1495	2	peeking
peining	10	46	1915	2	peining
peising	10	34	1676	2	peising
pekin	11	15	1442	2	pekin_
pekins	12	18	1223	2	pekins
perking	14	37	1646	2	perking
pickings	17	35	938	2	pickings
pickling	17	23	920	2	pickling
piecing	12	4	1045	2	piecing
pigging	12	36	1467	2	pigging
piki	10	65	2056	2	piki__
pikis	11	51	1639	2	piki_s
pilings	10	33	1361	2	pilings
pilling	10	37	2256	2	pilling
pimping	14	38	1212	2	pimping
pinang	9	26	1159	2	pinang
ping	7	59	4359	2	p__ing
pinging	11	34	1955	2	pinging
pinkings	15	33	814	2	pinkings
pinning	10	34	1785	2	pinning
pipings	12	33	825	2	pipings
pipkin	14	24	860	2	pipkin_
pipkins	15	32	818	2	pipkins
pipping	11	34	1474	2	pipping
piquing	19	3	587	2	piquing
pishing	13	43	1437	2	pishing
pissing	10	39	1480	2	pissing
pithing	13	40	1405	2	pithing
pitting	10	36	1887	2	pitting
pitying	13	29	1024	2	pitying
plinking	15	36	1124	2	plinking
plying	12	43	1208	2	plying
pocking	16	39	1676	2	pocking
poising	10	36	1710	2	poising
poling	9	35	2650	2	poling
pooing	9	38	2068	2	pooing
poring	9	42	2727	2	poring
porking	14	35	1581	2	porking
posing	9	39	2264	2	posing
poxing	16	37	1494	2	poxing
pricing	12	34	1734	2	pricing
pricking	17	32	1260	2	pricking
priding	11	33	1754	2	priding
priming	12	34	1737	2	priming
prinking	15	32	1245	2	prinking
prising	10	33	2145	2	prising
prizing	19	35	1468	2	prizing
prying	12	41	1480	2	prying
puling	9	36	2140	2	puling
raking	11	47	2842	2	raking
ricing	9	48	2276	2	ricing
ricking	14	39	2023	2	ricking
riding	8	43	2596	2	riding
riling	7	42	2797	2	riling
riming	9	33	2222	2	riming
riping	9	38	2161	2	riping
rising	7	40	2588	2	rising
risking	12	39	1424	2	risking
riving	10	45	2142	2	riving
ryking	14	34	811	2	ryking
sicking	14	37	2017	2	sicking
siding	8	38	2213	2	siding
silking	12	37	1559	2	silking
sinking	12	33	2054	2	sinking
siping	9	42	2063	2	siping
siring	7	51	2831	2	siring
siting	7	41	2662	2	siting
sizing	16	36	1644	2	sizing
skiing	11	36	1019	2	skiing
spicing	12	39	1453	2	spicing
spiling	10	29	1970	2	spiling
spiring	10	39	1818	2	spiring
spiting	10	39	1762	2	spiting
spoking	14	32	1222	2	spoking
taking	11	47	2595	2	taking
ticking	14	32	1875	2	ticking
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
tiring	7	40	2309	2	tiring
toking	11	44	2072	2	toking
tsking	11	42	1042	2	tsking
vicing	12	40	1424	2	vicing
vikings	15	38	662	2	vikings
vining	10	46	1946	2	vining
vising	10	39	1587	2	vising
waking	14	48	2138	2	waking
wicking	17	34	1477	2	wicking
wifing	13	35	1339	2	wifing
wiling	10	30	2429	2	wiling
wining	10	36	2505	2	wining
winking	15	33	1796	2	winking
wiping	12	39	1671	2	wiping
wiring	10	45	2102	2	wiring
wising	10	33	1822	2	wising
witing	10	35	2282	2	witing
wiving	13	33	1660	2	wiving
yoking	14	39	1228	2	yoking

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.343	520965.0
2	DLD Change Limit	82551	205	2.546	32423.8
3	Display Results	205	205	0.080	2562.5
	(SQL Overall)	178691	205	2.969	60185.6