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

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

113 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
whited	13	48	1408	(None)
waited	10	38	1977	1	waited
whiled	13	45	1413	1	whiled
whined	13	47	1520	1	whined
whisted	14	40	1001	1	whisted
white	11	49	2030	1	white_
whiten	12	41	1192	1	whiten
whiter	12	43	1639	1	whiter
whites	12	39	1988	1	whites
whitey	15	49	1188	1	whitey
wited	9	47	2714	1	w_ited
awaited	11	4	696	2	awaited
baited	9	53	1924	2	baited
chided	13	51	1396	2	chided
chimed	14	58	1483	2	chimed
chined	12	56	2006	2	chined
chuted	12	46	1184	2	chuted
cited	8	44	2195	2	_cited
doited	8	50	1663	2	doited
edited	8	39	1367	2	edited
evited	10	40	1314	2	evited
exited	14	47	1252	2	exited
flited	10	46	1658	2	flited
gaited	8	44	1692	2	gaited
hated	9	57	3402	2	_hated
hided	10	52	2244	2	_hided
hied	8	54	3404	2	_hi_ed
hiked	13	59	1920	2	_hiked
hilted	10	40	1604	2	_hilted
hinted	10	43	1832	2	_hinted
hired	9	52	2626	2	_hired
histed	10	44	2024	2	_histed
hived	12	52	1791	2	_hived
kited	10	51	2009	2	_kited
shied	9	61	2549	2	shi_ed
shifted	14	35	998	2	shifted
shined	10	46	2078	2	shined
shitted	11	42	1205	2	shitted
shuted	10	39	1317	2	shuted
sited	6	51	3074	2	_sited
skited	11	43	1348	2	skited
spited	9	48	2044	2	spited
suited	7	40	1942	2	suited
toited	7	40	1675	2	toited
united	7	44	2154	2	united
wafted	13	40	1214	2	wafted
waifed	13	40	1103	2	waifed
wailed	10	48	2359	2	wailed
waired	10	60	1583	2	waired
waisted	11	42	1094	2	waisted
waiter	9	43	2125	2	waiter
waived	13	45	1128	2	waived
wanted	10	43	1972	2	wanted
warted	10	42	2323	2	warted
wasted	10	44	2302	2	wasted
weeted	10	39	1379	2	weeted
welted	10	37	1582	2	welted
wetted	10	37	1702	2	wetted
whaled	13	46	1203	2	whaled
whetted	14	25	669	2	whetted
whid	11	54	1887	2	whi__d
whidded	16	3	442	2	whidded
whiffed	20	6	447	2	whiffed
while	11	54	1869	2	while_
whiles	12	44	1801	2	whiles
whine	11	60	2281	2	whine_
whiner	12	45	1663	2	whiner
whines	12	51	2010	2	whines
whiney	15	50	1264	2	whiney
whinged	15	40	915	2	whinged
whipped	18	37	933	2	whipped
whirled	14	36	804	2	whirled
whirred	14	38	693	2	whirred
whished	17	42	802	2	whished
whishted	18	4	315	2	whishted
whisked	18	33	691	2	whisked
whistled	15	9	578	2	whistled
whit	10	48	3417	2	whit__
whitely	16	34	647	2	whitely
whitened	15	3	517	2	whitened
whitens	13	42	873	2	whitens
whitest	13	37	1011	2	whitest
whiteys	16	39	615	2	whiteys
whither	16	35	1025	2	whither
whitier	13	33	1106	2	whitier
whities	13	31	1325	2	whities
whits	11	59	2382	2	whit_s
whitter	13	91	1089	2	whitter
whittled	15	9	491	2	whittled
whity	14	55	1347	2	whit_y
whizzed	22	3	406	2	whizzed
whored	13	55	1212	2	whored
wifed	12	51	1774	2	w_ifed
wiled	9	52	3155	2	w_iled
wilted	10	39	1571	2	wilted
wined	9	44	3418	2	w_ined
wiped	11	47	2208	2	w_iped
wired	9	53	2764	2	w_ired
wised	9	51	2334	2	w_ised
wisted	10	41	2027	2	wisted
wite	7	54	4327	2	w_ite_
wites	8	55	3696	2	w_ites
withed	13	44	1623	2	w_ithed
witted	10	42	1681	2	witted
wived	12	51	2150	2	w_ived
wonted	10	32	1328	2	wonted
wotted	10	41	1571	2	wotted
wried	9	55	1856	2	wri_ed
write	8	55	2283	2	write_
writer	9	44	1651	2	writer
writes	9	44	2033	2	writes
writhed	14	38	962	2	writhed
wyted	12	52	947	2	w_yted

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	113	2.453	33653.1
3	Display Results	113	113	0.030	3766.7
	(SQL Overall)	178691	113	2.826	63231.1