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

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

105 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
waifed	13	40	1103	(None)
waffed	16	45	979	1	waffed
wailed	10	48	2359	1	wailed
waired	10	60	1583	1	waired
waited	10	38	1977	1	waited
waived	13	45	1128	1	waived
wifed	12	51	1774	1	w_ifed
aided	7	58	2893	2	_aided
ailed	6	62	4028	2	_ailed
aimed	8	56	2605	2	_aimed
aired	6	60	3292	2	_aired
awaited	11	4	696	2	awaited
baffed	15	48	1217	2	baffed
bailed	9	47	2665	2	bailed
baited	9	53	1924	2	baited
barfed	12	54	1638	2	barfed
coifed	12	41	1306	2	coifed
daffed	14	42	949	2	daffed
dwarfed	15	3	348	2	dwarfed
failed	10	54	2160	2	failed
faired	10	59	1577	2	faired
fifed	12	51	1597	2	_fifed
gaffed	14	42	1020	2	gaffed
gained	8	46	1746	2	gained
gaited	8	44	1692	2	gaited
hailed	10	41	2274	2	hailed
haired	10	51	1717	2	haired
jailed	14	49	1742	2	jailed
knifed	14	52	812	2	knifed
laired	7	52	1681	2	laired
mailed	9	53	2675	2	mailed
maimed	11	48	1266	2	maimed
malfed	12	36	975	2	malfed
naffed	13	40	833	2	naffed
nailed	7	40	2149	2	nailed
paiked	13	51	1343	2	paiked
pained	9	56	2285	2	pained
paired	9	50	1752	2	paired
raided	8	50	1770	2	raided
railed	7	47	2754	2	railed
rained	7	50	2460	2	rained
raised	7	61	2033	2	raised
sailed	7	43	2776	2	sailed
sained	7	54	2424	2	sained
tailed	7	44	2466	2	tailed
vailed	10	46	1929	2	vailed
wadded	12	40	1417	2	wadded
waded	10	60	2475	2	wa_ded
wafer	11	44	1764	2	wa_fer
waffled	17	35	752	2	waffled
wafted	13	40	1214	2	wafted
waged	10	48	2278	2	wa_ged
wagged	12	46	1612	2	wagged
waif	10	58	3675	2	waif__
waifs	11	57	1987	2	waif_s
wailer	9	37	2032	2	wailer
waisted	11	42	1094	2	waisted
waiter	9	43	2125	2	waiter
waive	11	42	1460	2	waive_
waiver	12	42	1271	2	waiver
waives	12	37	1418	2	waives
waked	13	56	2675	2	wa_ked
waled	9	43	3099	2	wa_led
walked	14	53	1378	2	walked
walled	10	40	2129	2	walled
waned	9	58	3178	2	wa_ned
wanked	14	45	1715	2	wanked
wanned	10	43	1801	2	wanned
wanted	10	43	1972	2	wanted
wapped	14	44	1647	2	wapped
warded	11	50	2104	2	warded
wared	9	63	3987	2	wa_red
warked	14	44	2121	2	warked
warmed	12	45	1689	2	warmed
warned	10	40	1891	2	warned
warped	12	48	1641	2	warped
warred	10	40	1984	2	warred
warted	10	42	2323	2	warted
washed	13	55	2150	2	washed
wasted	10	44	2302	2	wasted
wauked	14	42	1057	2	wauked
wauled	10	47	1396	2	wauled
waved	12	52	2358	2	wa_ved
wawled	13	38	1170	2	wawled
waxed	16	60	1848	2	wa_xed
webfed	15	3	503	2	webfed
wharfed	17	3	441	2	wharfed
whiffed	20	6	447	2	whiffed
whiled	13	45	1413	2	whiled
whined	13	47	1520	2	whined
whited	13	48	1408	2	whited
wife	10	52	2802	2	w_ife_
wifes	11	45	2256	2	w_ifes
wifey	14	49	1367	2	w_ifey
wiled	9	52	3155	2	w_iled
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
wolfed	13	42	801	2	wolfed
woofed	13	45	1120	2	woofed
wried	9	55	1856	2	wri_ed
yaffed	16	45	732	2	yaffed

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	82551	0.110	1624463.6
2	DLD Change Limit	82551	105	3.313	24917.3
3	Display Results	105	105	0.060	1750.0
	(SQL Overall)	178691	105	3.483	51303.8