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

Here are the results of your fuzzy-string dictionary search for “piecings” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

256 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
piecings	13	4	534	(None)
piecing	12	4	1045	1	piecing_
piercings	14	5	326	1	piercings
icings	9	42	845	2	_i_cings
peelings	11	33	952	2	peelings
pickings	17	35	938	2	pickings
pieing	9	39	1765	2	pie_ing_
piercing	13	4	666	2	piercing_
pilings	10	33	1361	2	pi_lings
pinkings	15	33	814	2	pinkings
pipings	12	33	825	2	pi_pings
piscinas	12	7	548	2	piscinas
pittings	11	34	912	2	pittings
viewings	15	3	398	2	viewings
ageings	9	43	769	3	age_ings
airings	8	39	1384	3	ai_rings
beings	9	46	1303	3	_be_ings
biddings	13	39	756	3	biddings
biestings	12	26	603	3	biestings
biggings	13	32	747	3	biggings
billings	11	34	1263	3	billings
bindings	12	38	1047	3	bindings
birdings	12	37	882	3	birdings
birlings	11	35	961	3	birlings
bitewings	15	4	294	3	bitewings
bittings	11	33	929	3	bittings
bracings	13	36	929	3	bracings
brewings	14	29	669	3	brewings
briefings	15	4	373	3	briefings
ceilings	11	39	799	3	ceilings
deckings	16	34	668	3	_deckings
deicing	11	3	1219	3	deicing_
dialings	10	32	982	3	dialings
dicing	10	57	1876	3	di_cing_
diecious	11	4	687	3	diecious
dieing	8	40	1865	3	die_ing_
dieting	9	36	1683	3	dieting_
diggings	12	31	662	3	diggings
discing	11	39	1459	3	discing_
dyeings	12	37	464	3	dye_ings
evenings	12	3	438	3	evenings
facings	13	45	1126	3	_facings
feelings	12	33	893	3	feelings
fencings	14	22	566	3	fencings
ficins	11	35	1398	3	fi_cin_s
filings	11	52	1307	3	fi_lings
fillings	12	29	1050	3	fillings
findings	13	32	844	3	findings
finings	11	43	1177	3	fi_nings
firings	11	41	1233	3	fi_rings
fishings	15	30	769	3	fishings
fittings	12	31	820	3	fittings
fixings	18	34	744	3	fi_xings
gieing	8	36	1485	3	gie_ing_
gildings	11	35	697	3	gildings
ginnings	10	36	652	3	ginnings
gleyings	13	28	365	3	gleyings
heelings	12	35	975	3	heelings
hidings	12	34	970	3	hi_dings
hieing	10	42	1662	3	hie_ing_
hildings	13	34	750	3	hildings
hirelings	13	6	576	3	hirelings
hissings	12	55	675	3	hissings
icing	8	60	1775	3	_i_cing_
impings	12	34	855	3	_impings
innings	8	32	944	3	_innings
itchings	14	38	619	3	_itchings
keepings	15	34	594	3	keepings
killings	13	37	1048	3	killings
kiltings	13	32	708	3	kiltings
kitlings	13	31	810	3	kitlings
lacings	10	50	1365	3	_lacings
lickings	15	29	814	3	lickings
likings	12	53	941	3	li_kings
linings	8	43	1307	3	li_nings
lippings	13	29	609	3	lippings
listings	9	33	1004	3	listings
livings	11	40	892	3	li_vings
meetings	11	28	741	3	meetings
millings	11	37	1258	3	millings
mincing	12	33	1433	3	mincing_
minings	10	39	1207	3	mi_nings
neckings	15	34	611	3	_neckings
niacins	9	3	854	3	niacin_s
niderings	11	7	540	3	niderings
openings	11	3	480	3	openings
pacing	11	45	2275	3	p_acing_
packings	17	43	1006	3	packings
paddings	13	29	701	3	paddings
pagings	11	44	1106	3	p_agings
paintings	12	32	709	3	paintings
pairings	11	39	831	3	pairings
palings	10	39	1582	3	p_alings
panelings	12	10	745	3	panelings
pargings	12	34	1016	3	pargings
parings	10	42	1921	3	p_arings
parkings	15	36	1068	3	parkings
partings	11	35	1373	3	partings
passings	11	40	987	3	passings
pavings	13	40	1163	3	p_avings
peacing	12	41	1707	3	peacing_
pecans	10	15	1583	3	p_ecan_s
peching	15	45	1390	3	p_eching_
pecking	16	40	1778	3	p_ecking_
pectines	12	19	1468	3	p_ectines
pectins	11	23	1523	3	p_ectin_s
peeing	9	46	1808	3	p_eeing_
peeking	14	44	1495	3	peeking_
peeling	10	29	1987	3	peeling_
peening	10	33	1830	3	peening_
peeping	12	36	1521	3	peeping_
peering	10	35	2035	3	peering_
peeving	13	51	1224	3	peeving_
peining	10	46	1915	3	peining_
peins	7	61	2806	3	p_e_in_s
peising	10	34	1676	3	peising_
pekins	12	18	1223	3	p_ekin_s
penangs	10	26	837	3	p_enangs
pepinos	11	3	769	3	p_epinos
pettings	11	34	970	3	pettings
pfennigs	14	6	198	3	pfennigs
picking	16	34	1833	3	picking_
picnics	13	29	734	3	pi_cnics
pidgins	11	25	912	3	pidgin_s
piecers	11	41	1225	3	piec_ers
pieces	10	42	1727	3	piec__es
piercingly	18	4	323	3	piercingly
pieties	9	4	1922	3	pieti_es
pietisms	12	4	746	3	pietisms
pietists	10	3	832	3	pietists
pigging	12	36	1467	3	pigging_
piggins	11	30	1047	3	piggin_s
piing	8	52	1883	3	pi__ing_
piking	13	37	1964	3	pi_king_
piling	9	50	2559	3	pi_ling_
pilling	10	37	2256	3	pilling_
pilotings	12	3	435	3	pilotings
pimping	14	38	1212	3	pimping_
pinangs	10	26	779	3	pi_nangs
pinching	16	37	1105	3	pinching_
pinecones	13	4	625	3	pinecones
pinging	11	34	1955	3	pinging_
pings	8	58	3088	3	p___ings
pining	9	37	2653	3	pi_ning_
pinking	14	39	1894	3	pinking_
pinning	10	34	1785	3	pinning_
pipelines	13	17	835	3	pipelines
piperines	13	16	1069	3	piperines
piping	11	40	1745	3	pi_ping_
pipkins	15	32	818	3	pipkin_s
pipping	11	34	1474	3	pipping_
pippins	10	31	975	3	pippin_s
piquing	19	3	587	3	piquing_
piscina	11	7	704	3	piscin_a
piscinae	12	8	521	3	piscinae
piscinal	12	8	584	3	piscinal
piscine	11	6	1097	3	piscin_e
pishing	13	43	1437	3	pishing_
pissing	10	39	1480	3	pissing_
pitching	16	34	1111	3	pitching_
pithing	13	40	1405	3	pithing_
pitting	10	36	1887	3	pitting_
pitying	13	29	1024	3	pitying_
placing	12	38	1528	3	placing_
platings	11	36	1136	3	platings
pleadings	13	28	554	3	pleadings
poncing	12	29	1358	3	poncing_
porcinis	12	4	695	3	porcinis
postings	11	29	1230	3	postings
prebinds	13	35	773	3	prebinds
precents	12	30	1504	3	precents
precinct	14	5	942	3	precinct
precincts	15	4	499	3	precincts
precious	12	3	1059	3	precious
precipes	14	32	1221	3	precipes
precis	10	34	1670	3	preci__s
precises	12	32	1833	3	precises
preeing	10	38	1767	3	preeing_
prescinds	14	4	495	3	prescinds
pressings	12	26	902	3	pressings
preying	13	31	1455	3	preying_
pricing	12	34	1734	3	pricing_
prickings	18	31	565	3	prickings
primings	13	33	814	3	primings
printings	12	26	810	3	printings
pterins	9	8	1299	3	pterin_s
puddings	13	32	550	3	puddings
pulings	10	35	1132	3	p_ulings
purgings	12	34	729	3	purgings
purlings	11	39	1028	3	purlings
racings	10	50	1513	3	_racings
reedings	10	35	1036	3	reedings
reelings	9	40	1256	3	reelings
ribbings	13	27	592	3	ribbings
ricing	9	48	2276	3	ri_cing_
ricins	8	36	1870	3	ri_cin_s
ricinus	9	40	812	3	ri_cinus
ridings	9	34	1209	3	ri_dings
rieslings	10	3	449	3	rieslings
riflings	12	22	730	3	riflings
riggings	11	32	713	3	riggings
rinsings	9	31	801	3	rinsings
risings	8	32	1189	3	ri_sings
seeings	8	44	1129	3	_seeings
seemings	11	33	764	3	seemings
seisings	9	39	852	3	seisings
seizings	18	32	647	3	seizings
sewings	11	36	917	3	_sewings
shielings	13	23	712	3	shielings
siblings	11	10	812	3	siblings
siccing	12	31	951	3	siccing_
sidings	9	40	1146	3	si_dings
sieging	9	26	1320	3	sieging_
sieving	11	23	1123	3	sieving_
siftings	12	23	658	3	siftings
sittings	9	33	973	3	sittings
sizings	17	37	801	3	si_zings
spacings	13	28	704	3	spacings
spaeings	11	27	625	3	spae_ings
speedings	13	26	540	3	speedings
speerings	12	27	684	3	speerings
spicing	12	39	1453	3	spi_cing_
spieling	11	32	1252	3	spieling_
spiering	11	27	1335	3	spiering_
spilings	11	30	881	3	spi_lings
spinnings	12	29	485	3	spinnings
ticcing	12	30	863	3	ticcing_
tickings	15	36	858	3	tickings
tidings	9	38	1026	3	ti_dings
tieing	7	35	1876	3	tie_ing_
tiepins	9	3	946	3	tiepin_s
tiering	8	3	1525	3	tiering_
tilings	8	42	1279	3	ti_lings
timings	10	27	930	3	ti_mings
tintings	9	28	871	3	tintings
tithings	12	32	769	3	tithings
tracings	11	29	1041	3	tracings
veilings	12	35	731	3	veilings
veinings	12	30	643	3	veinings
vicing	12	40	1424	3	vi_cing_
viewing	14	3	707	3	viewing_
vikings	15	38	662	3	vi_kings
voicings	14	27	461	3	voicings
weepings	14	34	648	3	weepings
wickings	18	35	718	3	wickings
wiggings	14	31	617	3	wiggings
wildings	13	28	793	3	wildings
wincing	13	34	1390	3	wincing_
windings	13	32	997	3	windings
winnings	12	32	758	3	winnings
wirings	11	39	1011	3	wi_rings
witchings	18	32	530	3	witchings
witlings	12	32	844	3	witlings
wittings	12	32	873	3	wittings
wreckings	19	23	368	3	wreckings
zincing	19	29	1028	3	zincing_

Search took 8 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	146162	0.420	425454.8
2	DLD Change Limit	146162	256	7.360	19859.0
3	Display Results	256	256	0.110	2327.3
	(SQL Overall)	178691	256	7.890	22647.8