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

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

129 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
whiled	13	45	1413	(None)
wailed	10	48	2359	1	wailed
whaled	13	46	1203	1	whaled
while	11	54	1869	1	while_
whiles	12	44	1801	1	whiles
whined	13	47	1520	1	whined
whirled	14	36	804	1	whirled
whited	13	48	1408	1	whited
wiled	9	52	3155	1	w_iled
ailed	6	62	4028	2	_ailed
ariled	7	56	2032	2	ariled
awhile	12	5	779	2	awhile_
bailed	9	47	2665	2	bailed
boiled	9	50	2095	2	boiled
ceiled	9	41	1495	2	ceiled
chided	13	51	1396	2	chided
chield	12	46	1021	2	chield
child	11	45	1622	2	chil_d
childe	12	47	1121	2	childe
chile	10	56	2689	2	chile_
chiles	11	54	2530	2	chiles
chilled	13	33	1093	2	chilled
chimed	14	58	1483	2	chimed
chined	12	56	2006	2	chined
coiled	9	51	2394	2	coiled
doiled	8	48	1729	2	doiled
exiled	14	47	1246	2	exiled
failed	10	54	2160	2	failed
filed	9	53	3190	2	_filed
foiled	10	46	1840	2	foiled
guiled	8	43	1538	2	guiled
hailed	10	41	2274	2	hailed
haled	9	53	3582	2	_haled
heiled	10	44	1561	2	heiled
hided	10	52	2244	2	_hided
hied	8	54	3404	2	_hi_ed
hiked	13	59	1920	2	_hiked
hilled	10	40	2222	2	_hilled
hilted	10	40	1604	2	_hilted
hired	9	52	2626	2	_hired
hived	12	52	1791	2	_hived
holed	9	56	3413	2	_holed
jailed	14	49	1742	2	jailed
mailed	9	53	2675	2	mailed
moiled	9	43	1886	2	moiled
nailed	7	40	2149	2	nailed
oiled	6	44	2947	2	_oiled
piled	8	52	3299	2	_piled
railed	7	47	2754	2	railed
riled	6	58	3325	2	_riled
roiled	7	43	2005	2	roiled
sailed	7	43	2776	2	sailed
shaled	10	50	2395	2	shaled
shied	9	61	2549	2	shi_ed
shield	10	62	1297	2	shield
shilled	11	33	1362	2	shilled
shined	10	46	2078	2	shined
smiled	9	37	1643	2	smiled
soiled	7	38	2247	2	soiled
spiled	9	46	2199	2	spiled
tailed	7	44	2466	2	tailed
thirled	11	32	809	2	thirled
tholed	10	51	1387	2	tholed
tiled	6	48	3294	2	_tiled
toiled	7	44	2032	2	toiled
vailed	10	46	1929	2	vailed
veiled	10	37	1454	2	veiled
waifed	13	40	1103	2	waifed
wailer	9	37	2032	2	wailer
waired	10	60	1583	2	waired
waited	10	38	1977	2	waited
waived	13	45	1128	2	waived
waled	9	43	3099	2	w_aled
walled	10	40	2129	2	walled
wauled	10	47	1396	2	wauled
wawled	13	38	1170	2	wawled
welled	10	38	2021	2	welled
whale	11	55	1743	2	whale_
whaler	12	46	1197	2	whaler
whales	12	47	1694	2	whales
wheeled	14	31	846	2	wheeled
whelmed	16	37	515	2	whelmed
whelped	16	35	563	2	whelped
whid	11	54	1887	2	whi__d
whidded	16	3	442	2	whidded
whiffed	20	6	447	2	whiffed
whiffled	21	3	304	2	whiffled
whilom	14	3	613	2	whilom
whilst	12	3	914	2	whilst
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
whirler	13	30	760	2	whirler
whirred	14	38	693	2	whirred
whished	17	42	802	2	whished
whisked	18	33	691	2	whisked
whisted	14	40	1001	2	whisted
whistled	15	9	578	2	whistled
white	11	49	2030	2	white_
whiten	12	41	1192	2	whiten
whiter	12	43	1639	2	whiter
whites	12	39	1988	2	whites
whitey	15	49	1188	2	whitey
whittled	15	9	491	2	whittled
whizzed	22	3	406	2	whizzed
whole	11	44	1809	2	whole_
wholes	12	46	1677	2	wholes
whored	13	55	1212	2	whored
whorled	14	36	690	2	whorled
wield	9	52	1391	2	w_ield
wifed	12	51	1774	2	w_ifed
wild	8	51	2651	2	w_il_d
wilded	11	37	1450	2	w_ilded
wile	7	59	4437	2	w_ile_
wiles	8	54	3787	2	w_iles
willed	10	47	2245	2	willed
wilted	10	39	1571	2	w_ilted
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
wited	9	47	2714	2	w_ited
wived	12	51	2150	2	w_ived
wooled	10	37	1550	2	wooled
wried	9	55	1856	2	wri_ed
wyled	12	46	1184	2	w_yled

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	129	2.093	39441.5
3	Display Results	129	129	0.033	3909.1
	(SQL Overall)	178691	129	2.469	72373.8