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

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

104 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
whose	11	49	1453	(None)
chose	10	59	2540	1	chose
hose	7	65	4724	1	_hose
those	8	52	1814	1	those
whole	11	44	1809	1	whole
whore	11	60	1804	1	whore
whoso	11	50	922	1	whoso
ahorse	9	3	1151	2	ahorse
arose	5	58	3208	2	arose
brose	7	52	2703	2	brose
chase	10	51	2712	2	chase
choke	14	51	1802	2	choke
choose	11	51	1614	2	choose
chore	10	51	2676	2	chore
chosen	11	60	1413	2	chosen
choses	11	58	2513	2	choses
chouse	11	60	1756	2	chouse
chowse	14	47	1175	2	chowse
close	7	64	2522	2	close
dhole	9	52	1536	2	dhole
dose	5	64	4243	2	_dose
erose	5	57	2727	2	erose
ghost	9	63	1876	2	ghost
goose	6	59	2590	2	goose
hoe	6	75	6272	2	_ho_e
hoes	7	57	5573	2	_hoes
hoise	8	52	2477	2	_hoise
hoke	11	59	3593	2	_hoke
hole	7	75	5339	2	_hole
home	9	80	4244	2	_home
hone	7	75	4932	2	_hone
hope	9	66	3967	2	_hope
horse	8	61	3265	2	_horse
hos	6	83	6419	2	_hos_
hosed	9	58	3098	2	_hosed
hosel	8	60	2481	2	_hosel
hosen	8	56	2388	2	_hosen
hoser	8	115	2976	2	_hoser
hoses	8	54	4317	2	_hoses
hosey	11	61	2702	2	_hosey
host	7	78	5283	2	_host
house	8	91	3142	2	_house
hove	10	71	3222	2	_hove
howe	10	67	3410	2	_howe
loose	5	66	2768	2	loose
lose	4	51	4458	2	_lose
mhos	9	55	1777	2	mhos_
moose	7	63	2719	2	moose
noose	5	56	2406	2	noose
nose	4	67	3936	2	_nose
ose	3	81	4734	2	__ose
phase	10	46	1721	2	phase
phone	10	56	2193	2	phone
pose	6	64	4173	2	_pose
prose	7	58	3512	2	prose
rhos	7	63	1906	2	rhos_
roose	5	61	2709	2	roose
rose	4	61	4890	2	_rose
shoe	7	59	3344	2	sho_e
shoes	8	54	2966	2	shoes
shone	8	37	2598	2	shone
shore	8	54	3265	2	shore
shote	8	55	2610	2	shote
shove	11	44	2104	2	shove
these	8	65	1901	2	these
thole	8	56	2084	2	thole
whale	11	55	1743	2	whale
whee	10	54	2959	2	wh_ee
where	11	70	1942	2	where
while	11	54	1869	2	while
whine	11	60	2281	2	whine
whish	14	45	1292	2	whish
whisk	15	45	1014	2	whisk
whist	11	53	2295	2	whist
white	11	49	2030	2	white
who	9	55	2677	2	who__
whoa	10	66	1520	2	who_a
wholes	12	46	1677	2	wholes
whom	12	70	1818	2	who_m
whomp	15	50	1132	2	whomp
whomso	14	3	413	2	whomso
whoof	14	46	1269	2	whoof
whoop	13	42	1144	2	whoop
whoosh	15	24	435	2	whoosh
whop	12	55	2092	2	who_p
whops	13	50	1393	2	whops
whored	13	55	1212	2	whored
whores	12	56	1710	2	whores
whorl	11	46	1245	2	whorl
whort	11	46	2369	2	whort
whosis	12	3	717	2	whosis
whys	13	70	1166	2	whys_
wise	7	57	3734	2	w_ise
woe	6	66	5124	2	w_o_e
woes	7	64	4066	2	w_oes
woke	11	55	2796	2	w_oke
woos	7	62	3880	2	woos_
woosh	11	37	1073	2	woosh
wore	7	71	4467	2	w_ore
worse	8	65	2526	2	worse
wos	6	69	5353	2	w_os_
wost	7	65	4436	2	w_ost
wove	10	56	2431	2	w_ove
wrote	8	47	1748	2	wrote

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	53800	0.313	570897.8
2	DLD Change Limit	53800	104	1.576	34137.1
3	Display Results	104	104	0.033	3151.5
	(SQL Overall)	178691	104	1.922	92971.4