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

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

108 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
whiny	14	49	1557	(None)
shiny	11	51	2214	1	shiny
whin	10	52	2569	1	whin_
whine	11	60	2281	1	whine
whiney	15	50	1264	1	whiney
whinny	15	58	749	1	whinny
whins	11	49	2233	1	whins
whity	14	55	1347	1	whity
winy	10	70	3432	1	w_iny
ahing	9	89	2834	2	ahing
briny	10	47	1966	2	briny
chin	9	69	3474	2	chin_
china	10	50	2247	2	china
chine	10	52	3172	2	chine
chink	14	53	2159	2	chink
chinky	18	56	1054	2	chinky
chino	10	58	2331	2	chino
chins	10	56	3146	2	chins
chivy	16	48	1036	2	chivy
hin	6	75	5956	2	_hin_
hind	8	55	2975	2	_hind
hinky	15	56	1875	2	_hinky
hinny	11	56	1667	2	_hinny
hins	7	64	4799	2	_hins
hint	7	74	5574	2	_hint
liny	7	81	4132	2	_liny
meiny	10	40	1540	2	meiny
ohing	9	60	1880	2	ohing
phony	13	67	1544	2	phony
piny	9	118	3835	2	_piny
rainy	8	59	2108	2	rainy
rhino	8	46	1432	2	rhino
shily	11	52	2201	2	shily
shin	7	56	3430	2	shin_
shindy	13	44	932	2	shindy
shine	8	55	3309	2	shine
shinny	12	48	1078	2	shinny
shins	8	51	3104	2	shins
spiny	10	49	2130	2	spiny
thin	7	67	3238	2	thin_
thine	8	50	2685	2	thine
thing	9	66	2296	2	thing
think	12	50	1879	2	think
thinly	12	3	866	2	thinly
thins	8	58	2632	2	thins
tiny	7	61	3463	2	_tiny
twiny	11	60	1281	2	twiny
veiny	11	54	1436	2	veiny
viny	10	60	2595	2	_viny
wahine	12	38	1301	2	wahine
wain	7	58	4019	2	wain_
wains	8	69	3086	2	wains
wany	10	64	3235	2	w_any
weeny	11	53	1616	2	weeny
wenny	11	44	1246	2	wenny
whang	12	48	1338	2	whang
when	10	57	2304	2	when_
whens	11	46	1876	2	whens
whey	13	50	1871	2	wh_ey
which	16	39	1008	2	which
whid	11	54	1887	2	whi_d
whids	12	54	1398	2	whids
whiff	17	3	1005	2	whiff
whig	11	55	1642	2	whi_g
whigs	12	56	1264	2	whigs
while	11	54	1869	2	while
whim	12	62	2052	2	whi_m
whims	13	45	1533	2	whims
whimsy	17	37	522	2	whimsy
whined	13	47	1520	2	whined
whiner	12	45	1663	2	whiner
whines	12	51	2010	2	whines
whinge	13	43	1153	2	whinge
whip	12	55	2184	2	whi_p
whippy	19	38	584	2	whippy
whips	13	49	1708	2	whips
whipt	13	53	1742	2	whipt
whir	10	55	1928	2	whi_r
whirl	11	49	1382	2	whirl
whirly	15	44	886	2	whirly
whirr	11	46	1119	2	whirr
whirry	15	47	706	2	whirry
whirs	11	52	1809	2	whirs
whish	14	45	1292	2	whish
whisk	15	45	1014	2	whisk
whisky	19	45	590	2	whisky
whist	11	53	2295	2	whist
whit	10	48	3417	2	whi_t
white	11	49	2030	2	white
whitey	15	49	1188	2	whitey
whits	11	59	2382	2	whits
whiz	19	59	1994	2	whi_z
whizz	19	42	1032	2	whizz
whizzy	23	27	407	2	whizzy
why	12	69	2001	2	wh__y
wily	10	64	2881	2	w_ily
win	6	64	5629	2	w_in_
wind	8	55	3385	2	w_ind
windy	12	61	1810	2	w_indy
wine	7	49	5342	2	w_ine
winey	11	53	2543	2	w_iney
wing	8	63	3922	2	w_ing
wingy	12	65	2103	2	w_ingy
wink	11	64	3502	2	w_ink
wino	7	59	3361	2	w_ino
wins	7	59	4917	2	w_ins
wiry	10	64	2283	2	w_iry
wring	9	59	2071	2	wring

Search took 4 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.186	960704.3
2	DLD Change Limit	53800	108	3.190	16865.2
3	Display Results	108	108	0.060	1800.0
	(SQL Overall)	178691	108	3.436	52005.5