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

Here are the results of your fuzzy-string dictionary search for “whim” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

137 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
whim	12	62	2053	(None)
him	8	62	4766	1	_him
shim	9	58	2786	1	shim
wham	12	53	2169	1	wham
whid	11	54	1887	1	whid
whig	11	55	1642	1	whig
whims	13	45	1533	1	whims
whin	10	52	2569	1	whin
whip	12	55	2184	1	whip
whir	10	55	1928	1	whir
whit	10	48	3417	1	whit
whiz	19	59	1994	1	whiz
whom	12	70	1818	1	whom
ahem	9	72	2536	2	ahem
ahi	6	80	4023	2	ahi_
ahis	7	61	3538	2	ahis
aim	5	78	5821	2	_aim
brim	8	56	2937	2	brim
cham	11	55	3231	2	cham
chi	8	62	2865	2	chi_
chia	9	60	2662	2	chia
chic	11	59	2520	2	chic
chid	10	66	2640	2	chid
chimb	14	48	1356	2	chimb
chime	12	53	2259	2	chime
chimp	14	52	1647	2	chimp
chin	9	69	3474	2	chin
chip	11	67	2642	2	chip
chirm	12	53	1706	2	chirm
chis	9	59	3331	2	chis
chit	9	69	3746	2	chit
chum	11	63	1800	2	chum
dim	6	81	4649	2	_dim
ghi	7	70	1988	2	ghi_
ghis	8	50	2016	2	ghis
glim	7	60	2635	2	glim
grim	7	69	2942	2	grim
ham	8	63	6328	2	_ham
hem	8	61	4873	2	_hem
hi	5	79	4758	2	_hi_
hic	8	65	4056	2	_hic
hid	7	62	4838	2	_hid
hie	6	76	5270	2	_hie
hims	9	52	3097	2	_hims
hin	6	75	5956	2	_hin
hip	8	67	5043	2	_hip
his	6	63	5950	2	_his
hit	6	65	6919	2	_hit
hm	7	81	2673	2	_h_m
hmm	10	62	1899	2	_hmm
hum	8	55	4293	2	_hum
khi	10	63	1830	2	khi_
khis	11	70	1798	2	khis
maim	8	58	3149	2	maim
mim	7	60	4842	2	_mim
nim	5	71	4295	2	_nim
ohia	7	57	1936	2	ohia
ohm	8	65	2301	2	oh_m
oxim	13	11	1405	2	oxim
phi	8	65	2420	2	phi_
phis	9	57	2490	2	phis
phiz	18	67	1884	2	phiz
prim	8	51	3220	2	prim
rim	5	60	5227	2	_rim
sham	9	64	3636	2	sham
shims	10	44	2255	2	shims
shin	7	56	3431	2	shin
ship	9	52	2824	2	ship
shit	7	67	4594	2	shit
shiv	10	57	2117	2	shiv
sim	5	65	5314	2	_sim
skim	10	53	2251	2	skim
slim	6	66	3196	2	slim
swim	9	62	2140	2	swim
them	9	74	2704	2	them
thin	7	67	3239	2	thin
thio	7	72	2541	2	thio
thir	7	64	2054	2	thir
this	7	60	2738	2	this
trim	6	53	2952	2	trim
vim	8	74	3702	2	_vim
waif	10	58	3675	2	waif
wail	7	52	3882	2	wail
wain	7	58	4020	2	wain
wair	7	58	3005	2	wair
wait	7	55	5369	2	wait
warm	9	59	3567	2	warm
weir	7	60	1992	2	weir
wha	9	64	2207	2	wh_a
whamo	13	55	1126	2	whamo
whams	13	55	1564	2	whams
whap	12	51	1964	2	whap
what	10	54	3407	2	what
whee	10	54	2959	2	whee
whelm	13	46	1198	2	whelm
when	10	57	2304	2	when
whet	10	51	3378	2	whet
whew	13	76	1878	2	whew
whey	13	50	1871	2	whey
which	16	39	1008	2	which
whids	12	54	1398	2	whids
whiff	17	3	1006	2	whiff
whigs	12	56	1264	2	whigs
while	11	54	1869	2	while
whilom	14	3	613	2	whilom
whimsy	17	37	522	2	whimsy
whine	11	60	2281	2	whine
whins	11	49	2233	2	whins
whiny	14	49	1557	2	whiny
whips	13	49	1708	2	whips
whipt	13	53	1742	2	whipt
whirl	11	49	1382	2	whirl
whirr	11	46	1119	2	whirr
whirs	11	52	1809	2	whirs
whish	14	45	1292	2	whish
whisk	15	45	1014	2	whisk
whist	11	53	2295	2	whist
white	11	49	2030	2	white
whits	11	59	2382	2	whits
whity	14	55	1347	2	whity
whizz	19	42	1032	2	whizz
who	9	55	2677	2	wh_o
whoa	10	66	1520	2	whoa
whomp	15	50	1132	2	whomp
whop	12	55	2092	2	whop
whump	15	49	1004	2	whump
whup	12	57	1416	2	whup
why	12	69	2001	2	wh_y
whys	13	70	1166	2	whys
wig	7	67	4038	2	w_ig
wimp	11	55	2152	2	w_imp
win	6	64	5629	2	w_in
wis	6	65	5233	2	w_is
wit	6	65	6377	2	w_it
wiz	15	64	3415	2	w_iz
worm	9	61	2949	2	worm
writ	7	55	3791	2	writ

Search took 2 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	29872	0.283	631417.0
2	DLD Change Limit	29872	137	0.826	36164.6
3	Display Results	137	137	0.030	4566.7
	(SQL Overall)	178691	137	1.139	156884.1