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

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

238 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
scarify	15	3	744	(None)
scarily	12	3	1170	1	scarily
scorify	15	3	520	1	scorify
carnify	15	5	588	2	_carnify
clarify	15	3	609	2	clarify
rarify	12	32	1006	2	_rarify
salify	12	3	1137	2	s_alify
scarcity	15	4	509	2	scarcity
scarey	11	50	1698	2	scar_ey
scarf	10	54	2714	2	scar_f_
scarfs	11	47	1468	2	scar_fs
scarier	9	40	1787	2	scarier
scaring	10	34	2197	2	scaring
scarry	11	63	1118	2	scar_ry
scary	10	52	2259	2	scar__y
scurfy	14	33	876	2	scur_fy
sharif	12	29	1711	2	sharif_
sharifs	13	27	990	2	sharifs
acari	7	50	2028	3	acari__
acarid	9	50	1706	3	acari_d
acarids	10	53	1224	3	acarids
acarine	9	3	1600	3	acarine
acetify	15	4	500	3	acetify
acidify	16	4	524	3	acidify
aerify	12	28	1011	3	_aerify
ascarid	10	39	1071	3	ascari_d
ascarids	11	43	850	3	ascarids
ascaris	9	36	1332	3	ascari_s
basify	14	3	751	3	_basify
beatify	15	3	659	3	beatify
cagily	12	4	1156	3	_cagily
cairny	11	55	782	3	_cairny
calcify	17	3	587	3	_calcify
calif	10	49	2909	3	_calif_
califs	11	49	1589	3	_califs
carafe	11	54	1616	3	_carafe
carboy	13	49	1418	3	_carboy
caribe	10	34	1674	3	_caribe
caried	9	45	2869	3	_caried
caries	8	51	4762	3	_caries
carina	8	43	2532	3	_carina
caring	9	51	3799	3	_caring
carney	11	53	1570	3	_carney
carny	10	58	2292	3	_car_ny
carry	10	58	2378	3	_car_ry
casefy	14	3	627	3	_casefy
cavity	14	3	1001	3	_cavity
certify	15	4	624	3	_certify
charily	15	3	1028	3	charily
charity	15	3	1102	3	charity
citify	14	3	744	3	_citify
clarity	12	3	1091	3	clarity
coalify	15	3	668	3	coalify
codify	15	3	716	3	_codify
cornify	15	3	625	3	_cornify
esterify	14	4	562	3	esterify
gasify	13	3	633	3	_gasify
glorify	14	4	458	3	glorify
gratify	14	3	611	3	gratify
hoarily	13	3	897	3	hoarily
horrify	16	3	502	3	horrify
metrify	15	3	562	3	metrify
micrify	17	4	469	3	micrify
nazify	21	3	423	3	_nazify
nigrify	14	4	413	3	nigrify
nitrify	13	3	579	3	nitrify
ocarina	9	4	802	3	ocarina
opacify	17	4	365	3	opacify
pacify	16	6	747	3	_pacify
parity	11	47	1987	3	_parity
petrify	15	3	657	3	petrify
purify	14	39	915	3	_purify
qualify	22	3	547	3	qualify
ramify	14	26	875	3	_ramify
rarefy	12	29	634	3	_rarefy
rarity	9	36	1549	3	_rarity
ratify	12	26	1004	3	_ratify
saccharify	23	6	234	3	saccharify
sacring	10	31	1598	3	sacring
sacrist	9	3	1542	3	sacrist
sacristy	13	4	510	3	sacristy
salsify	13	3	470	3	salsify
sanity	9	3	1620	3	s_anity
sari	4	54	4404	3	s_ari__
sarin	5	52	3925	3	s_ari_n
sarins	6	39	3262	3	s_arins
saris	5	45	4495	3	s_ari_s
sarky	12	55	2178	3	s_ar_ky
satiny	9	38	1798	3	s_atiny
satisfy	13	4	418	3	s_atisfy
scabbily	17	6	394	3	scabbily
scabby	15	3	550	3	sca_bby
scabies	11	6	1333	3	scabies
scalier	9	43	1691	3	scalier
scaling	10	35	1937	3	scaling
scaly	10	47	1872	3	sca__ly
scantily	13	3	758	3	scantily
scantly	12	41	955	3	scantly
scanty	11	40	1466	3	sca_nty
scaping	12	37	1569	3	scaping
scar	6	64	3420	3	scar___
scarab	10	3	1006	3	scar_ab
scarabs	11	3	729	3	scarabs
scarce	10	40	1363	3	scar_ce
scarcely	15	3	430	3	scarcely
scarcer	11	39	1137	3	scarcer
scare	7	53	3446	3	scar__e
scared	9	52	2729	3	scar_ed
scarer	8	45	2460	3	scar_er
scarers	9	46	1850	3	scarers
scares	8	50	3300	3	scar_es
scarfed	13	47	1118	3	scarfed
scarfer	12	45	1108	3	scarfer
scarfing	14	30	971	3	scarfing
scariest	10	16	1594	3	scariest
scarified	15	4	729	3	scarified
scarifier	14	4	665	3	scarifier
scarifies	14	3	960	3	scarifies
scarifying	19	4	501	3	scarify~~ing~~
scariose	10	3	759	3	scariose
scarious	10	6	1020	3	scarious
scarlet	9	15	1694	3	scarlet
scarp	9	57	2410	3	scar__p
scarped	12	43	1439	3	scarped
scarper	11	48	1482	3	scarper
scarph	13	42	960	3	scar_ph
scarphs	14	43	741	3	scarphs
scarping	13	33	1246	3	scarping
scarps	10	47	1860	3	scar_ps
scarred	10	45	1263	3	scarred
scarrier	10	29	845	3	scarrier
scarring	11	25	1151	3	scarring
scars	7	54	3353	3	scar__s
scart	7	61	3977	3	scar__t
scarted	10	48	1612	3	scarted
scarting	11	34	1526	3	scarting
scarts	8	53	2149	3	scar_ts
scarves	12	45	1162	3	scarves
scatty	11	53	1065	3	sca_tty
schizy	23	11	504	3	sc_hizy
schrik	15	20	670	3	schri_k
schriks	16	18	574	3	schriks
scoria	8	5	1348	3	scori_a
scoriae	9	3	1089	3	scoriae
scoring	10	31	1721	3	scoring
scraggy	14	30	458	3	scraggy
scraich	14	3	676	3	scraich
scraigh	13	3	567	3	scraigh
scrappy	16	23	447	3	scrappy
scrawly	15	19	718	3	scrawly
scrawny	15	21	393	3	scrawny
screwy	14	65	945	3	sc_rewy
scribe	10	46	1352	3	sc_ribe
scried	9	58	1730	3	sc_ried
scries	8	52	2682	3	sc_ries
scrim	9	54	1972	3	sc_ri_m
scrimp	12	51	1058	3	sc_rimp
scrimpy	16	48	613	3	sc_rimpy
scrims	10	46	1593	3	sc_rims
scrip	9	66	1919	3	sc_ri_p
scrips	10	53	1603	3	sc_rips
script	10	57	1790	3	sc_ript
scrive	11	54	1494	3	sc_rive
scruff	14	3	796	3	sc_ruff
scruffy	18	4	264	3	scruffy
scry	9	60	1776	3	sc_r__y
scurf	10	47	1932	3	scur_f_
scurfs	11	32	1081	3	scur_fs
scurry	11	41	958	3	scur_ry
scurvily	16	4	377	3	scurvily
scurvy	14	38	610	3	scur_vy
sealift	10	3	1279	3	sealift
searing	8	33	3092	3	searing
security	13	4	669	3	security
serif	8	41	3212	3	s_erif_
serifs	9	40	1705	3	s_erifs
shadily	14	3	772	3	shadily
shakily	17	3	690	3	shakily
sharia	9	31	1672	3	shari_a
shariah	13	22	1053	3	shariah
sharias	10	25	1600	3	sharias
sharing	11	37	2324	3	sharing
sharny	12	47	1183	3	shar_ny
sharply	15	40	683	3	sharply
sharpy	14	52	1103	3	shar_py
sherif	12	29	1523	3	sherif_
sheriff	16	28	769	3	sheriff
sherifs	13	29	968	3	sherifs
shrift	12	4	1354	3	s_hrift
signify	14	4	485	3	signify
smarmily	15	4	352	3	smarmily
smarmy	13	62	935	3	smar_my
smartly	12	49	743	3	smartly
smarty	11	50	1379	3	smar_ty
snakily	14	3	691	3	snakily
snarf	8	65	2542	3	snar_f_
snarfs	9	51	1342	3	snar_fs
snaring	8	39	2095	3	snaring
snarkily	15	3	458	3	snarkily
snarky	13	42	1084	3	snar_ky
snarly	9	38	1500	3	snar_ly
soapily	12	3	796	3	soapily
soaring	8	35	2189	3	soaring
sorrily	10	3	982	3	sorrily
sparely	12	34	1066	3	sparely
sparid	9	40	1693	3	spari_d
sparids	10	35	1212	3	sparids
sparing	10	48	2387	3	sparing
sparkily	17	3	501	3	sparkily
sparkly	16	34	812	3	sparkly
sparky	15	45	1152	3	spar_ky
sparry	11	51	1130	3	spar_ry
sparsity	13	4	546	3	sparsity
specify	17	6	499	3	specify
stagily	11	3	905	3	stagily
starchy	15	28	674	3	starchy
staring	8	45	2705	3	staring
starkly	14	27	703	3	starkly
starry	9	49	1167	3	star_ry
startsy	10	53	670	3	startsy
stratify	14	4	570	3	stratify
strife	9	53	1836	3	s_trife
stripy	11	58	1274	3	s_tripy
suavity	13	3	631	3	suavity
surfy	11	53	1947	3	s_ur_fy
swarf	11	53	2465	3	swar_f_
swarfs	12	56	1206	3	swar_fs
swarthy	16	46	637	3	swarthy
swarty	12	58	1238	3	swar_ty
tackify	19	3	449	3	tackify
tariff	12	7	1135	3	_tariff
tearily	10	3	1115	3	tearily
terrify	13	3	635	3	terrify
torrify	13	3	501	3	torrify
verify	15	31	1016	3	_verify
vitrify	16	4	500	3	vitrify
warily	12	29	1509	3	_warily
wearily	13	3	878	3	wearily

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	134027	0.156	1145455.1
2	DLD Change Limit	134027	238	7.500	17870.3
3	Display Results	238	238	0.076	3131.6
	(SQL Overall)	178691	238	7.732	23110.6