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

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

258 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
whisht	15	45	1081	(None)
whish	14	45	1292	1	whish_
whishts	16	42	531	1	whishts
whist	11	53	2295	1	whis_t
hight	12	53	2723	2	_hight
hist	7	65	5154	2	_his_t
shist	8	48	2961	2	shis_t
waist	8	61	3238	2	wais_t
weight	13	39	1418	2	weight
which	16	39	1008	2	which_
whilst	12	3	914	2	whilst
whipt	13	53	1742	2	whi_pt
whished	17	42	802	2	whished
whishes	16	30	944	2	whishes
whishted	18	4	315	2	whishted
whisk	15	45	1014	2	whis_k
whisks	16	49	735	2	whisks
whisky	19	45	590	2	whisky
whists	12	46	1381	2	whists
whit	10	48	3417	2	whi__t
wight	12	37	2557	2	w_ight
wish	10	72	2873	2	w_ish_
wisha	11	49	1085	2	w_isha
wist	7	80	4929	2	w_is_t
wright	13	37	1351	2	wright
wrist	8	48	2756	2	wris_t
agist	6	63	2558	3	agis_t
ahis	7	61	3538	3	ahis__
alight	10	38	1686	3	alight
alist	5	61	3678	3	alis_t
apish	10	51	1663	3	apish_
aright	10	38	1766	3	aright
bight	11	87	2884	3	_bight
blight	12	41	1462	3	blight
borsht	11	8	1350	3	borsht
bright	12	42	1592	3	bright
chest	10	49	2614	3	ches_t
chichi	16	3	709	3	chichi
chis	9	59	3331	3	chis__
chisel	11	21	1194	3	chisel
chit	9	69	3746	3	chi__t
cist	6	72	4496	3	_cis_t
cuish	10	3	1317	3	cuish_
deist	6	46	3359	3	deis_t
dight	10	40	2700	3	_dight
dish	8	63	2833	3	_dish_
dishy	12	57	1235	3	_dishy
eight	9	49	2805	3	_eight
exist	12	46	1894	3	exis_t
feist	8	62	3007	3	feis_t
fight	12	40	2709	3	_fight
fish	10	69	2627	3	_fish_
fishy	14	60	1166	3	_fishy
fist	7	62	4842	3	_fis_t
flight	13	40	1481	3	flight
foist	8	57	3097	3	fois_t
fright	13	37	1524	3	fright
geisha	10	3	520	3	geisha
ghast	9	56	2122	3	ghas_t
ghis	8	50	2016	3	ghis__
ghost	9	63	1876	3	ghos_t
gist	5	60	4676	3	_gis_t
grist	6	55	2987	3	gris_t
hash	10	69	3650	3	_hash_
hast	7	62	5948	3	_has_t
height	13	47	1343	3	height
heishi	12	3	584	3	heishi
heist	8	70	3091	3	heis_t
hest	7	59	5077	3	_hes_t
high	11	66	1992	3	_high_
highs	12	54	1252	3	_highs
highth	12	38	915	3	_highth
hights	13	37	1689	3	_hights
hilt	7	58	5071	3	_hi_lt
hint	7	74	5574	3	_hi_nt
hipshot	15	10	664	3	_hipshot
his	6	63	5950	3	_his__
hisn	7	96	2093	3	_his_n
hiss	7	56	2921	3	_his_s
hissy	11	61	1212	3	_hissy
hists	8	63	2837	3	_hists
hit	6	65	6919	3	_hi__t
hoist	8	64	3321	3	hois_t
host	7	78	5283	3	_hos_t
hush	10	52	2411	3	_hush_
joist	12	51	2565	3	jois_t
khis	11	70	1798	3	khis__
kist	8	65	4079	3	_kis_t
knight	14	3	817	3	knight
knish	12	3	860	3	knish_
licht	10	47	2349	3	_licht
light	9	44	2960	3	_light
list	4	70	5534	3	_lis_t
maist	7	55	3568	3	mais_t
might	11	38	2708	3	_might
mishit	11	26	1819	3	_mishit
mist	6	61	5453	3	_mis_t
moist	7	60	3358	3	mois_t
neist	5	46	2844	3	neis_t
night	9	43	2785	3	_night
odist	6	4	2191	3	odis_t
orisha	9	3	677	3	orisha
owlish	12	3	870	3	owlish_
phis	9	57	2490	3	phis__
phpht	15	3	806	3	ph_pht
pish	9	61	2791	3	_pish_
plight	12	35	1336	3	plight
poisha	11	3	572	3	poisha
right	9	44	3050	3	_right
rishi	8	3	1125	3	_rishi
schist	11	3	1265	3	schis_t
shiest	9	58	2152	3	shiest
shift	11	42	2514	3	shi_ft
shirt	8	45	3390	3	shi_rt
shists	9	65	1511	3	shists
shit	7	67	4594	3	shi__t
shush	11	38	1254	3	shush_
sight	9	46	2929	3	_sight
slight	10	34	1600	3	slight
swish	11	51	1482	3	swish_
swishy	15	36	584	3	swishy
theist	9	3	1476	3	theis_t
thigh	12	4	1012	3	thigh_
thighs	13	4	663	3	thighs
thirst	9	3	1225	3	thirst
this	7	60	2738	3	this__
tight	9	36	2650	3	_tight
twist	8	68	2098	3	twis_t
visit	8	3	2096	3	_visit
wadset	10	3	1430	3	wadset
waists	9	74	1545	3	waists
wait	7	55	5369	3	wai__t
wash	10	60	3381	3	w_ash_
washy	14	59	1184	3	w_ashy
wast	7	56	5585	3	w_as_t
waucht	14	39	941	3	waucht
waught	13	38	1104	3	waught
wecht	13	4	1544	3	w_echt
weest	8	50	2677	3	wees_t
weigh	12	54	1251	3	weigh_
weighs	13	33	887	3	weighs
weights	14	40	955	3	weights
weighty	17	37	623	3	weighty
welsh	11	31	1036	3	welsh_
west	7	57	4808	3	w_es_t
what	10	54	3407	3	wh__at
whatsit	13	4	582	3	whatsit
wheat	11	49	2457	3	wh_eat
whet	10	51	3378	3	wh__et
wheyish	19	4	406	3	wheyish_
whid	11	54	1887	3	whi__d
whidah	16	3	480	3	whidah
whidahs	17	4	333	3	whidahs
whids	12	54	1398	3	whi_ds
whiff	17	3	1006	3	whi_ff
whiffet	19	6	534	3	whiffet
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
whim	12	62	2053	3	whi__m
whims	13	45	1533	3	whi_ms
whimsey	18	37	389	3	whimsey
whimsy	17	37	522	3	whimsy
whin	10	52	2569	3	whi__n
whinchat	19	4	434	3	whinchat
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
whiney	15	50	1264	3	whiney
whinge	13	43	1154	3	whinge
whinny	15	58	749	3	whinny
whins	11	49	2233	3	whi_ns
whiny	14	49	1557	3	whi_ny
whip	12	55	2184	3	whi__p
whippet	17	32	884	3	whippet
whippy	19	38	584	3	whippy
whips	13	49	1708	3	whi_ps
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
whirly	15	44	886	3	whirly
whirr	11	46	1119	3	whi_rr
whirrs	12	40	859	3	whirrs
whirry	15	47	706	3	whirry
whirs	11	52	1809	3	whi_rs
whishing	18	28	718	3	whishing
whishting	19	8	356	3	whisht~~ing~~
whisked	18	33	691	3	whisked
whisker	17	36	793	3	whisker
whiskey	20	44	558	3	whiskey
whisper	15	29	801	3	whisper
whisted	14	40	1001	3	whisted
whistle	13	10	753	3	whistle
white	11	49	2030	3	whi_te
whited	13	48	1408	3	whited
whiten	12	41	1192	3	whiten
whiter	12	43	1639	3	whiter
whites	12	39	1988	3	whites
whitest	13	37	1011	3	whitest
whitey	15	49	1188	3	whitey
whither	16	35	1025	3	whither
whitish	16	3	597	3	whitish_
whits	11	59	2382	3	whi_ts
whity	14	55	1347	3	whi_ty
whiz	19	59	1994	3	whi__z
whizz	19	42	1032	3	whi_zz
whizzy	23	27	407	3	whizzy
whoosh	15	24	435	3	whoosh_
whorish	16	3	660	3	whorish_
whort	11	46	2369	3	wh_ort
whose	11	49	1453	3	whos_e
whosis	12	3	717	3	whosis
whoso	11	50	922	3	whos_o
whys	13	70	1166	3	whys__
wich	12	57	2474	3	w_ich_
widish	13	41	936	3	widish_
width	12	3	1096	3	w_idth
wights	13	33	1578	3	w_ights
wilt	7	62	4629	3	w_i_lt
winish	12	42	1226	3	winish_
wis	6	65	5233	3	w_is__
wise	7	57	3734	3	w_is_e
wised	9	51	2334	3	w_ised
wisent	9	35	1634	3	w_isent
wiser	8	55	2280	3	w_iser
wises	8	56	3319	3	w_ises
wisest	9	50	1644	3	w_isest
wished	13	44	1751	3	w_ished
wisher	12	36	1706	3	w_isher
wishes	12	49	2095	3	w_ishes
wisp	9	71	2407	3	w_is_p
wisps	10	52	1418	3	w_isps
wispy	13	72	1097	3	w_ispy
wiss	7	56	3054	3	w_is_s
wists	8	67	2852	3	w_ists
wit	6	65	6377	3	w_i__t
with	10	57	3047	3	w_ith_
withe	11	52	2023	3	w_ithe
withy	14	48	1376	3	w_ithy
woosh	11	37	1073	3	woosh_
worset	9	67	2658	3	worset
worst	8	63	3013	3	wors_t
wost	7	65	4436	3	w_os_t
wrest	8	49	2543	3	wres_t
wriest	9	44	1971	3	wriest
wrights	14	31	899	3	wrights
wrists	9	54	1564	3	wrists
wristy	12	50	970	3	wristy
writ	7	55	3791	3	wri__t
writhe	12	53	1070	3	writhe
wurst	8	51	2299	3	wurs_t
wushu	11	3	699	3	w_ushu

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	258	5.093	22131.6
3	Display Results	258	258	0.063	4095.2
	(SQL Overall)	178691	258	5.296	33740.7