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

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

331 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
snappy	13	6	610	(None)
nappy	12	63	1233	1	_nappy
sappy	12	54	1347	1	s_appy
snippy	13	7	484	1	snippy
crappy	15	44	680	2	crappy
flappy	16	5	448	2	flappy
gappy	13	62	1203	2	_gappy
happy	15	58	1353	2	_happy
nappa	9	85	1186	2	_nappa
nappe	9	61	1499	2	_nappe
nippy	12	49	1111	2	_nippy
pappy	11	47	1380	2	_pappy
scrappy	16	23	447	2	scrappy
sharpy	14	52	1103	2	sharpy
shnapps	14	6	334	2	shnapps
slippy	13	7	584	2	slippy
sloppy	13	9	530	2	sloppy
snaggy	11	48	805	2	snaggy
snakey	13	50	1127	2	snakey
snaky	12	51	1391	2	sna_ky
snap	6	57	2703	2	sna_p_
snapped	12	46	1120	2	snapped
snapper	11	35	1207	2	snapper
snappily	15	4	432	2	snappily
snaps	7	47	1956	2	sna_ps
snarky	13	42	1084	2	snarky
snarly	9	38	1500	2	snarly
snazzy	17	3	401	2	snazzy
snoopy	11	44	947	2	snoopy
soapy	10	61	1478	2	soa_py
soppy	12	51	1352	2	s_oppy
strappy	14	20	526	2	strappy
swampy	16	43	723	2	swampy
unhappy	17	4	280	2	unhappy
zappy	21	54	894	2	_zappy
anally	9	5	1350	3	anally
app	7	68	2760	3	__app_
apply	12	51	1139	3	__apply
apps	8	63	1969	3	__apps
buppy	14	48	1007	3	_buppy
campy	14	51	1618	3	_campy
canopy	13	3	772	3	canopy
champy	18	50	961	3	champy
chippy	18	43	761	3	chippy
choppy	18	37	629	3	choppy
crampy	15	47	1099	3	crampy
cuppy	14	47	1038	3	_cuppy
dippy	13	51	1154	3	_dippy
drapey	12	50	1058	3	drapey
drippy	14	44	565	3	drippy
flippy	16	5	461	3	flippy
floppy	16	5	487	3	floppy
frappe	13	28	695	3	frappe
gapy	10	63	2091	3	_ga_py
gloppy	14	5	472	3	gloppy
gnarly	10	46	1038	3	gnarly
gnatty	10	33	648	3	gnatty
grapey	12	60	1230	3	grapey
grappa	11	39	644	3	grappa
grapy	11	54	1643	3	gra_py
grippy	14	44	776	3	grippy
guppy	13	52	1127	3	_guppy
haply	13	59	1506	3	_haply
harpy	13	64	1820	3	_harpy
heapy	13	59	1498	3	hea_py
hippy	15	51	1279	3	_hippy
hoppy	15	49	1235	3	_hoppy
inapt	7	35	2269	3	ina_pt
inaptly	12	4	440	3	inaptly
kappa	13	46	974	3	_kappa
knap	10	58	1540	3	kna_p_
knapped	16	39	710	3	knapped
knapper	15	38	715	3	knapper
knaps	11	55	1117	3	kna_ps
knarry	13	3	461	3	knarry
lippy	12	45	1190	3	_lippy
loppy	12	59	1166	3	_loppy
naggy	10	66	1282	3	_naggy
nancy	10	52	1492	3	_nancy
nanny	8	48	1381	3	_nanny
nap	5	67	5320	3	_na_p_
napa	6	69	2726	3	_na_pa
napas	7	59	2435	3	_napas
nape	6	52	3080	3	_na_pe
napery	11	48	981	3	_napery
napes	7	48	2846	3	_napes
nappas	10	55	1161	3	_nappas
napped	11	42	1816	3	_napped
napper	10	37	1828	3	_napper
nappes	10	45	1562	3	_nappes
nappie	10	41	1226	3	_nappie
naps	6	62	3858	3	_na_ps
narky	12	60	1780	3	_narky
nary	7	69	3122	3	_na_ry
nasty	8	57	1728	3	_nasty
natty	8	57	1914	3	_natty
navvy	14	69	668	3	_navvy
navy	10	75	1863	3	_na_vy
nay	6	69	5277	3	_na__y
pappi	8	48	1089	3	_pappi
peppy	11	43	1036	3	_peppy
poppy	11	48	1319	3	_poppy
preppy	12	3	552	3	preppy
puppy	11	49	1241	3	_puppy
quippy	22	38	426	3	quippy
raspy	10	65	1170	3	_raspy
reapply	14	3	432	3	reapply
sadly	9	45	1912	3	s_adly
saggy	10	59	1746	3	s_aggy
sagy	8	53	2708	3	s_a_gy
sally	8	51	2971	3	s_ally
salp	6	45	3409	3	s_alp_
salpa	7	50	1835	3	s_alpa
salps	7	44	2324	3	s_alps
salty	8	55	2438	3	s_alty
samp	8	57	3359	3	s_amp_
samps	9	61	2467	3	s_amps
sandy	9	42	2113	3	s_andy
sanely	9	31	1461	3	sanely
sanity	9	3	1620	3	sanity
sap	5	64	6323	3	s_a_p_
sapid	8	47	2093	3	s_apid
sapor	7	51	1925	3	s_apor
sapped	11	44	2201	3	s_apped
sapper	10	38	2235	3	s_apper
sappily	14	3	716	3	s_appily
saps	6	53	4637	3	s_a_ps
sarky	12	55	2178	3	s_arky
sassy	8	58	1381	3	s_assy
satay	8	47	1846	3	s_atay
saucy	10	46	1516	3	s_aucy
saury	8	43	1722	3	s_aury
savoy	11	47	1388	3	s_avoy
savvy	14	49	750	3	s_avvy
say	6	72	6476	3	s_a__y
scabby	15	3	550	3	scabby
scalp	9	52	1798	3	scalp_
scalps	10	43	1523	3	scalps
scaly	10	47	1872	3	sca_ly
scamp	11	57	1731	3	scamp_
scampi	12	46	910	3	scampi
scamps	12	50	1417	3	scamps
scanty	11	40	1466	3	scanty
scape	9	69	2184	3	sca_pe
scaped	11	55	1955	3	scaped
scapes	10	51	2226	3	scapes
scarey	11	50	1698	3	scarey
scarp	9	57	2410	3	scarp_
scarph	13	42	960	3	scarph
scarps	10	47	1860	3	scarps
scarry	11	63	1118	3	scarry
scary	10	52	2259	3	sca_ry
scatty	11	53	1065	3	scatty
scaup	9	55	1599	3	scaup_
scaups	10	54	1193	3	scaups
schappe	16	3	526	3	schappe
schnapps	17	5	203	3	schnapps
seamy	10	59	2127	3	sea_my
seaway	12	30	999	3	seaway
seepy	10	47	1797	3	s_eepy
senary	9	37	1607	3	sena_ry
sepoy	10	3	1430	3	s_epoy
shabby	16	3	580	3	shabby
shady	12	54	1651	3	sha_dy
shaggy	14	47	804	3	shaggy
shaky	15	46	1684	3	sha_ky
shaley	12	37	1499	3	shaley
shaly	11	43	2286	3	sha_ly
shammy	16	38	850	3	shammy
shamoy	14	37	991	3	shamoy
shandy	13	47	1003	3	shandy
shanny	12	41	1009	3	shanny
shanty	12	47	1511	3	shanty
shape	10	51	2511	3	sha_pe
shaped	12	50	2010	3	shaped
shapely	15	3	689	3	shapely
shapen	11	44	1465	3	shapen
shaper	11	41	1993	3	shaper
shapes	11	51	2494	3	shapes
sharny	12	47	1183	3	sharny
sharp	10	49	2253	3	sharp_
sharply	15	40	683	3	sharply
sharps	11	55	1608	3	sharps
shay	10	71	3334	3	sha__y
shnaps	11	4	808	3	shna_ps
shoppe	13	31	1031	3	shoppe
simply	13	30	1052	3	simply
sirupy	11	37	705	3	sirupy
skanky	12	47	696	3	skanky
skimpy	17	47	572	3	skimpy
slaggy	11	43	879	3	slaggy
slangy	10	54	1139	3	slangy
slanty	9	51	1484	3	slanty
slap	6	64	3404	3	sla_p_
slapped	12	35	1184	3	slapped
slapper	11	35	1246	3	slapper
slaps	7	60	2571	3	sla_ps
slatey	9	54	1706	3	slatey
slaty	8	65	2315	3	sla_ty
slavey	12	40	1180	3	slavey
slay	7	64	3638	3	sla__y
sleepy	11	47	941	3	sleepy
smarmy	13	62	935	3	smarmy
smarty	11	50	1379	3	smarty
snack	11	47	1806	3	sna_ck
snacks	12	45	1455	3	snacks
snafu	8	4	1214	3	sna_fu
snafus	9	3	674	3	snafus
snag	5	58	2787	3	sna__g
snags	6	44	2131	3	sna_gs
snail	5	70	2020	3	sna_il
snails	6	48	1665	3	snails
snake	9	48	2111	3	sna_ke
snaked	11	50	1759	3	snaked
snakes	10	39	1960	3	snakes
snakily	14	3	691	3	snakily
snappers	12	35	1016	3	snappers
snappier	12	6	621	3	snappier
snapping	13	34	965	3	snapping
snappish	15	4	523	3	snappish
snare	5	44	2998	3	sna_re
snared	7	48	2455	3	snared
snarer	6	46	2084	3	snarer
snares	6	53	2903	3	snares
snarf	8	65	2542	3	sna_rf
snarfs	9	51	1342	3	snarfs
snark	9	54	1994	3	sna_rk
snarks	10	48	1573	3	snarks
snarl	5	49	2108	3	sna_rl
snarls	6	40	1687	3	snarls
snash	8	48	1567	3	sna_sh
snatch	11	43	1060	3	snatch
snatchy	15	35	529	3	snatchy
snath	8	64	1980	3	sna_th
snathe	9	44	1511	3	snathe
snaths	9	51	1291	3	snaths
snaw	7	89	2307	3	sna__w
snawed	10	48	1373	3	snawed
snaws	8	61	1636	3	sna_ws
sneaky	13	42	784	3	sneaky
sneap	7	55	1482	3	sneap_
sneaped	10	33	881	3	sneaped
sneaps	8	45	1086	3	sneaps
sneery	9	36	1041	3	sneery
sneezy	18	34	527	3	sneezy
sniffy	15	33	719	3	sniffy
snip	6	64	2465	3	sn_ip_
snipe	7	53	2057	3	sn_ipe
sniped	9	49	1348	3	sniped
sniper	8	44	1364	3	sniper
snipes	8	39	1739	3	snipes
snipped	12	35	1004	3	snipped
snipper	11	39	1132	3	snipper
snippet	11	33	1043	3	snippet
snippety	15	26	349	3	snippety
snippily	15	4	357	3	snippily
snips	7	58	1801	3	sn_ips
snobby	13	3	440	3	snobby
snoop	7	53	1717	3	snoop_
snoops	8	43	1416	3	snoops
snooty	9	42	1150	3	snooty
snoozy	18	51	722	3	snoozy
snotty	9	48	919	3	snotty
snouty	9	41	995	3	snouty
snowy	11	50	1156	3	sn_owy
snubby	13	4	453	3	snubby
snuffy	15	35	624	3	snuffy
snugly	10	5	566	3	snugly
soap	6	58	3113	3	soa_p_
soaped	9	58	1797	3	soaped
soaper	8	45	1787	3	soaper
soapily	12	3	796	3	soapily
soaps	7	51	2071	3	soa_ps
sophy	13	66	1176	3	s_ophy
soupy	10	61	1540	3	s_oupy
spacey	13	62	1253	3	spacey
spacy	12	54	1562	3	spa_cy
sparky	15	45	1152	3	sparky
sparry	11	51	1130	3	sparry
spay	9	66	3166	3	s__pay
spry	9	68	1912	3	s__pry
spy	8	60	2374	3	s___py
stably	11	33	1412	3	stably
stagey	10	59	1558	3	stagey
staggy	11	55	1039	3	staggy
stagy	9	66	1889	3	sta_gy
stalky	13	49	930	3	stalky
stamp	9	52	1736	3	stamp_
stamps	10	56	1402	3	stamps
stapes	8	50	2873	3	stapes
staph	10	43	1465	3	sta_ph
staphs	11	44	1103	3	staphs
staple	8	44	1582	3	staple
starry	9	49	1167	3	starry
stay	7	83	3372	3	sta__y
steppe	10	31	987	3	steppe
stripy	11	58	1274	3	stripy
stroppy	14	20	509	3	stroppy
stumpy	13	45	813	3	stumpy
suably	11	28	1453	3	suably
supply	13	4	689	3	supply
swabby	16	3	435	3	swabby
swamp	12	50	1532	3	swamp_
swamps	13	59	1026	3	swamps
swamy	13	67	1440	3	swa_my
swanky	16	44	797	3	swanky
swanny	12	33	682	3	swanny
swap	9	59	2543	3	swa_p_
swapped	15	42	914	3	swapped
swapper	14	35	970	3	swapper
swaps	10	48	1920	3	swa_ps
swarty	12	58	1238	3	swarty
sway	10	71	2823	3	swa__y
sweepy	14	44	745	3	sweepy
swoopy	14	48	728	3	swoopy
sylphy	17	4	415	3	sylphy
synapse	12	3	413	3	synapse
syncarpy	18	4	248	3	syncarpy
syrupy	14	28	582	3	syrupy
teapoy	11	3	811	3	teapoy
tippy	12	54	1179	3	_tippy
trampy	13	49	925	3	trampy
trippy	13	45	780	3	trippy
unapt	7	104	2159	3	una_pt
unaptly	12	4	479	3	unaptly
unary	8	3	1599	3	una_ry
vampy	15	53	940	3	_vampy
waspy	13	54	1099	3	_waspy
whippy	19	38	584	3	whippy
yuppy	15	48	791	3	_yuppy
zippy	21	51	874	3	_zippy

Search took 6 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	331	5.533	20371.6
3	Display Results	331	331	0.090	3677.8
	(SQL Overall)	178691	331	5.763	31006.6