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

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

155 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
whizzy	23	27	407	(None)
whizz	19	42	1032	1	whizz_
dizzy	17	74	1085	2	_dizzy
fizzy	19	90	1508	2	_fizzy
frizzy	20	55	583	2	frizzy
schizzy	23	13	236	2	schizzy
tizzy	16	54	889	2	_tizzy
wheezy	24	24	452	2	wheezy
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
whippy	19	38	584	2	whippy
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
whiz	19	59	1994	2	whi_z_
whizzed	22	3	406	2	whizzed
whizzer	21	3	458	2	whizzer
whizzes	21	3	471	2	whizzes
chicly	16	42	920	3	chicly
chilly	14	41	1322	3	chilly
chinky	18	56	1054	3	chinky
chintzy	24	36	422	3	chintzy
chippy	18	43	761	3	chippy
chirpy	16	49	891	3	chirpy
chitty	14	32	943	3	chitty
chivvy	20	37	443	3	chivvy
chivy	16	48	1036	3	chi_vy
ditzy	18	65	1328	3	_ditzy
drizzly	19	36	455	3	drizzly
fezzy	19	98	1145	3	_fezzy
fizz	15	75	1982	3	_fizz_
frizz	16	55	1262	3	frizz_
frizzly	21	45	579	3	frizzly
fuzzy	19	298	1451	3	_fuzzy
glitzy	19	40	478	3	glitzy
grizzly	19	35	447	3	grizzly
hazy	19	181	1919	3	_h_azy
hilly	11	44	2216	3	_hilly
hinky	15	56	1875	3	_hinky
hinny	11	56	1667	3	_hinny
hiply	13	41	1361	3	_hiply
hippy	15	51	1279	3	_hippy
hissy	11	61	1212	3	_hissy
huzza	16	4	609	3	_huzza
jazzy	23	39	636	3	_jazzy
lezzy	16	60	808	3	_lezzy
mizzly	19	25	610	3	_mizzly
muzzy	18	84	1060	3	_muzzy
phiz	18	67	1884	3	phi_z_
phizes	20	38	913	3	phizes
pizza	15	3	818	3	_pizza
ritzy	17	56	1116	3	_ritzy
schizy	23	11	504	3	schi_zy
scuzzy	19	3	308	3	scuzzy
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
shirty	12	43	1256	3	shirty
shitty	12	41	1006	3	shitty
sizy	16	48	1639	3	_si_zy
snazzy	17	3	401	3	snazzy
thinly	12	3	867	3	thinly
thirty	12	37	840	3	thirty
weirdy	13	39	546	3	weirdy
whacky	21	55	649	3	whacky
whammy	19	37	529	3	whammy
wheeze	21	27	681	3	wheeze
whelky	19	31	497	3	whelky
wherry	15	47	733	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	1887	3	whi__d
whidah	16	3	480	3	whidah
whids	12	54	1398	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
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
whip	12	55	2184	3	whi__p
whipray	18	4	340	3	whipray
whips	13	49	1708	3	whi_ps
whipt	13	53	1742	3	whi_pt
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
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
whizzers	22	3	342	3	whizzers
whizzier	22	3	328	3	whizzier
whizzing	23	3	338	3	whizzing
wholly	15	36	657	3	wholly
why	12	69	2001	3	wh___y
widdy	13	61	1218	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	2881	3	w_i_ly
wimpy	15	59	1192	3	w_impy
windy	12	61	1810	3	w_indy
winey	11	53	2543	3	w_iney
wingy	12	65	2103	3	w_ingy
winy	10	70	3432	3	w_i_ny
winze	17	50	1485	3	w_inze
wiry	10	64	2283	3	w_i_ry
wispy	13	72	1097	3	w_ispy
withy	14	48	1376	3	w_ithy
witty	11	47	1701	3	w_itty
wiz	15	64	3415	3	w_i_z_
wizen	17	58	1386	3	w_izen
wizes	17	47	2334	3	w_izes
wizzen	17	38	720	3	w_izzen
wizzes	17	51	1077	3	w_izzes
woozy	20	44	1060	3	w_oozy
wristy	12	50	970	3	wristy

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.376	475242.0
2	DLD Change Limit	112716	155	5.110	22057.9
3	Display Results	155	155	0.046	3369.6
	(SQL Overall)	178691	155	5.532	32301.3