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

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

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.

70 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
scarcity	15	4	509	(None)
scarcely	15	3	431	2	scarcely
scarify	15	3	744	2	scar_ify
scarily	12	3	1170	2	scar_ily
sparsity	13	4	546	2	sparsity
acerbity	15	4	427	3	acerbity
alacrity	13	5	548	3	alacrity
caducity	16	4	388	3	_caducity
calcify	17	3	587	3	_calcify
calcite	11	4	1378	3	_calcite
capacity	17	4	602	3	_capacity
carnify	15	5	588	3	_carnify
carroty	12	4	894	3	_carroty
cavity	14	3	1001	3	_ca_vity
cecity	13	9	815	3	_c_ecity
charity	15	3	1102	3	char_ity
circuity	15	4	496	3	_circuity
clarity	12	3	1091	3	clar_ity
edacity	13	3	637	3	eda_city
feracity	16	4	673	3	feracity
opacity	14	3	631	3	opa_city
parity	11	47	1987	3	_par_ity
paucity	14	3	582	3	_paucity
rarity	9	36	1549	3	_rar_ity
raucity	12	3	585	3	_raucity
sacristy	13	4	510	3	sacristy
sagacity	14	4	524	3	sagacity
salacity	13	4	785	3	salacity
sanctity	13	4	559	3	s_anctity
sanity	9	3	1620	3	s_a_nity
sarcina	9	3	1073	3	s_arcina
saucily	12	3	791	3	s_aucily
scabbily	17	6	394	3	scabbily
scantily	13	3	758	3	scantily
scanty	11	40	1466	3	sca__nty
scarce	10	40	1363	3	scarc__e
scarcer	11	39	1137	3	scarc_er
scarcest	12	16	917	3	scarcest
scarcities	14	4	640	3	scarcities
scarey	11	50	1698	3	scar__ey
scarfing	14	30	971	3	scarfing
scarier	9	40	1787	3	scar_ier
scaring	10	34	2197	3	scar_ing
scarlet	9	15	1694	3	scarlet_
scarlets	10	17	857	3	scarlets
scarping	13	33	1246	3	scarping
scarrier	10	29	845	3	scarrier
scarring	11	25	1151	3	scarring
scarry	11	63	1118	3	scar__ry
scart	7	61	3977	3	scar__t_
scarting	11	34	1526	3	scarting
scarts	8	53	2149	3	scar__ts
scary	10	52	2259	3	scar___y
scatty	11	53	1065	3	sca__tty
scorify	15	3	520	3	scor_ify
scurvily	16	4	378	3	scurvily
security	13	4	669	3	secur_ity
smarmily	15	4	352	3	smarmily
smarty	11	50	1379	3	smar__ty
snarkily	15	3	458	3	snarkily
sparkily	17	3	502	3	sparkily
starchily	17	4	501	3	starchily
starchy	15	28	674	3	starc_hy
starlit	7	15	1291	3	starlit_
suavity	13	3	631	3	sua_vity
supercity	16	4	881	3	supercity
swarty	12	58	1238	3	swar__ty
varsity	13	5	667	3	_varsity
veracity	16	4	755	3	veracity
voracity	16	4	553	3	voracity

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	70	6.690	21847.8
3	Display Results	70	70	0.013	5384.6
	(SQL Overall)	178691	70	7.123	25086.5