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

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

242 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
whippy	19	38	584	(None)
chippy	18	43	761	1	chippy
hippy	15	51	1279	1	_hippy
chirpy	16	49	891	2	chirpy
choppy	18	37	629	2	choppy
dippy	13	51	1154	2	_dippy
drippy	14	44	565	2	drippy
flippy	16	5	461	2	flippy
grippy	14	44	776	2	grippy
happy	15	58	1353	2	_happy
hiply	13	41	1361	2	_hiply
hippo	12	36	906	2	_hippo
hoppy	15	49	1235	2	_hoppy
lippy	12	45	1190	2	_lippy
nippy	12	49	1111	2	_nippy
quippy	22	38	426	2	quippy
slippy	13	7	584	2	slippy
snippy	13	7	484	2	snippy
tippy	12	54	1179	2	_tippy
trippy	13	45	780	2	trippy
whimsy	17	37	522	2	whimsy
whiney	15	50	1264	2	whiney
whinny	15	58	749	2	whinny
whiny	14	49	1557	2	whi_ny
whip	12	55	2184	2	whi_p_
whipped	18	37	933	2	whipped
whipper	17	36	1138	2	whipper
whippet	17	32	884	2	whippet
whipray	18	4	340	2	whipray
whips	13	49	1708	2	whi_ps
whipt	13	53	1742	2	whi_pt
whirly	15	44	886	2	whirly
whirry	15	47	706	2	whirry
whisky	19	45	590	2	whisky
whitey	15	49	1188	2	whitey
whity	14	55	1347	2	whi_ty
whizzy	23	27	407	2	whizzy
wimpy	15	59	1192	2	w_impy
wispy	13	72	1097	2	w_ispy
zippy	21	51	874	2	_zippy
buppy	14	48	1007	3	_buppy
champy	18	50	961	3	champy
chicly	16	42	920	3	chicly
chilly	14	41	1322	3	chilly
chimp	14	52	1647	3	chimp_
chimps	15	57	1366	3	chimps
chinky	18	56	1054	3	chinky
chip	11	67	2642	3	chi_p_
chipped	17	41	1081	3	chipped
chipper	16	39	1258	3	chipper
chippie	16	29	769	3	chippie
chips	12	57	2125	3	chi_ps
chirp	12	47	1716	3	chirp_
chirps	13	54	1400	3	chirps
chitty	14	32	943	3	chitty
chivvy	20	37	443	3	chivvy
chivy	16	48	1036	3	chi_vy
chuppa	15	4	397	3	chuppa
crappy	15	44	680	3	crappy
crimpy	15	48	939	3	crimpy
crispy	13	47	856	3	crispy
cuppy	14	47	1038	3	_cuppy
flappy	16	5	448	3	flappy
floppy	16	5	487	3	floppy
gappy	13	62	1203	3	_gappy
gimpy	13	52	1223	3	_gimpy
gipsy	11	57	954	3	_gipsy
gloppy	14	5	472	3	gloppy
gripey	12	41	1120	3	gripey
grippe	11	53	1032	3	grippe
gripy	11	51	1525	3	gri_py
guppy	13	52	1127	3	_guppy
haply	13	59	1506	3	_haply
harpy	13	64	1821	3	_harpy
heapy	13	59	1498	3	_heapy
hempy	15	49	1276	3	_hempy
hilly	11	44	2216	3	_hilly
hinky	15	56	1875	3	_hinky
hinny	11	56	1667	3	_hinny
hip	8	67	5044	3	_hi_p_
hipped	14	43	1769	3	_hipped
hipper	13	38	1802	3	_hipper
hippie	13	28	1124	3	_hippie
hippos	13	40	843	3	_hippos
hips	9	64	3371	3	_hi_ps
hissy	11	61	1212	3	_hissy
humpy	15	51	1567	3	_humpy
jimpy	19	52	1082	3	_jimpy
loppy	12	59	1166	3	_loppy
nappy	12	63	1233	3	_nappy
pappy	11	47	1380	3	_pappy
peppy	11	43	1036	3	_peppy
pipy	11	54	2152	3	_pi_py
poppy	11	48	1319	3	_poppy
preppy	12	3	552	3	preppy
puppy	11	49	1241	3	_puppy
quippu	19	34	486	3	quippu
ripply	13	34	800	3	_ripply
sappy	12	54	1347	3	_sappy
sharpy	14	52	1103	3	sharpy
shifty	15	40	926	3	shifty
shily	11	52	2201	3	shi_ly
shimmy	16	30	641	3	shimmy
shindy	13	44	932	3	shindy
shinny	12	48	1078	3	shinny
shiny	11	51	2214	3	shi_ny
ship	9	52	2824	3	shi_p_
shipped	15	33	1210	3	shipped
shippen	14	29	886	3	shippen
shipper	14	35	1404	3	shipper
shippon	14	28	580	3	shippon
ships	10	51	2377	3	shi_ps
shipway	18	4	421	3	shipway
shirty	12	43	1256	3	shirty
shitty	12	41	1006	3	shitty
shoppe	13	31	1032	3	shoppe
shrimpy	17	41	540	3	shrimpy
skimpy	17	47	572	3	skimpy
sloppy	13	9	530	3	sloppy
snappy	13	6	610	3	snappy
soppy	12	51	1352	3	_soppy
thinly	12	3	867	3	thinly
thirty	12	37	840	3	thirty
tipsy	10	60	1050	3	_tipsy
triply	11	42	1102	3	triply
unhappy	17	4	280	3	unhappy
waspy	13	54	1099	3	w_aspy
weepy	13	42	1259	3	w_eepy
weirdy	13	39	546	3	weirdy
whacky	21	55	649	3	whacky
whammy	19	37	529	3	whammy
whap	12	51	1964	3	wh_ap_
whapped	18	36	757	3	whapped
whapper	17	34	827	3	whapper
whaps	13	51	1516	3	wh_aps
whaup	13	45	888	3	whaup_
whaups	14	40	575	3	whaups
wheep	13	62	1435	3	wheep_
wheeps	14	43	995	3	wheeps
wheezy	24	24	452	3	wheezy
whelky	19	31	497	3	whelky
whelp	13	60	1209	3	whelp_
whelps	14	43	784	3	whelps
wherry	15	47	734	3	wherry
whey	13	50	1871	3	wh__ey
wheyey	18	3	432	3	wheyey
which	16	39	1008	3	whi_ch
whid	11	54	1888	3	whi__d
whidah	16	3	480	3	whidah
whids	12	54	1399	3	whi_ds
whiff	17	3	1006	3	whi_ff
whiffs	18	3	508	3	whiffs
whig	11	55	1642	3	whi__g
whigs	12	56	1264	3	whi_gs
while	11	54	1869	3	whi_le
whiled	13	45	1413	3	whiled
whiles	12	44	1801	3	whiles
whilom	14	3	613	3	whilom
whilst	12	3	914	3	whilst
whim	12	62	2053	3	whi__m
whimper	17	29	772	3	whimper
whims	13	45	1533	3	whi_ms
whimsey	18	37	389	3	whimsey
whin	10	52	2569	3	whi__n
whine	11	60	2281	3	whi_ne
whined	13	47	1520	3	whined
whiner	12	45	1663	3	whiner
whines	12	51	2010	3	whines
whinge	13	43	1154	3	whinge
whins	11	49	2233	3	whi_ns
whippers	18	32	904	3	whippers
whippets	18	25	525	3	whippets
whippier	18	26	582	3	whippier
whipping	19	32	817	3	whipping
whiprays	19	4	250	3	whiprays
whipsaw	18	4	272	3	whipsaw
whir	10	55	1928	3	whi__r
whirl	11	49	1382	3	whi_rl
whirls	12	47	1053	3	whirls
whirr	11	46	1119	3	whi_rr
whirrs	12	40	859	3	whirrs
whirs	11	52	1809	3	whi_rs
whish	14	45	1292	3	whi_sh
whisht	15	45	1081	3	whisht
whisk	15	45	1014	3	whi_sk
whiskey	20	44	558	3	whiskey
whisks	16	49	735	3	whisks
whisper	15	29	801	3	whisper
whispery	19	28	429	3	whispery
whist	11	53	2295	3	whi_st
whists	12	46	1381	3	whists
whit	10	48	3417	3	whi__t
white	11	49	2030	3	whi_te
whited	13	48	1408	3	whited
whitely	16	34	647	3	whitely
whiten	12	41	1192	3	whiten
whiter	12	43	1639	3	whiter
whites	12	39	1988	3	whites
whiteys	16	39	615	3	whiteys
whits	11	59	2382	3	whi_ts
whiz	19	59	1994	3	whi__z
whizz	19	42	1032	3	whi_zz
wholly	15	36	657	3	wholly
whomp	15	50	1132	3	whomp_
whomps	16	45	760	3	whomps
whoop	13	42	1144	3	whoop_
whoops	14	48	786	3	whoops
whop	12	55	2092	3	wh_op_
whopped	18	35	800	3	whopped
whopper	17	32	850	3	whopper
whops	13	50	1393	3	wh_ops
whump	15	49	1004	3	whump_
whumps	16	42	709	3	whumps
whup	12	57	1416	3	wh_up_
whupped	18	36	541	3	whupped
whups	13	42	1000	3	wh_ups
why	12	69	2001	3	wh___y
wicopy	16	3	403	3	wicopy
widdy	13	61	1219	3	w_iddy
wifey	14	49	1367	3	w_ifey
wifty	14	42	1209	3	w_ifty
wiggy	13	45	1073	3	w_iggy
willy	11	53	2191	3	w_illy
wily	10	64	2882	3	w_i_ly
wimp	11	55	2153	3	w_imp_
wimps	12	52	1380	3	w_imps
windy	12	61	1811	3	w_indy
winey	11	53	2543	3	w_iney
wingy	12	65	2103	3	w_ingy
winy	10	70	3433	3	w_i_ny
wipe	9	48	3029	3	w_i_pe
wiped	11	47	2208	3	w_iped
wiper	10	54	2129	3	w_iper
wipes	10	48	2708	3	w_ipes
wiry	10	64	2284	3	w_i_ry
wisp	9	71	2408	3	w_isp_
wisps	10	52	1418	3	w_isps
withy	14	48	1376	3	w_ithy
witty	11	47	1701	3	w_itty
wristy	12	50	970	3	wristy
yuppy	15	48	791	3	_yuppy
zappy	21	54	894	3	_zappy

Search took 7 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.373	479064.3
2	DLD Change Limit	112716	242	5.703	19764.3
3	Display Results	242	242	0.063	3841.3
	(SQL Overall)	178691	242	6.139	29107.5