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

Here are the results of your fuzzy-string dictionary search for “holdout” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

91 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
holdout	11	5	1090	(None)
foldout	11	4	953	1	foldout
holdouts	12	4	549	1	holdouts
foldouts	12	4	479	2	foldouts
handout	11	3	1410	2	handout
holdup	12	4	518	2	hold_up
holibut	12	9	748	2	holibut
rollout	7	8	1194	2	rollout
blowout	12	4	840	3	blowout
boldest	10	26	1306	3	boldest
clout	7	53	3046	3	_cl_out
coldest	10	25	1476	3	coldest
colour	8	59	1509	3	col_our
cookout	13	4	1015	3	cookout
copout	10	4	1878	3	co_pout
dolour	7	57	1013	3	dol_our
eelpout	9	4	778	3	eelpout
fallout	10	3	1350	3	fallout
flout	8	62	2620	3	_fl_out
foldboat	14	4	524	3	foldboat
foldup	12	3	381	3	fold_up
folious	10	37	1073	3	folious
glout	6	59	2581	3	_gl_out
goldbug	12	4	210	3	goldbug
goldest	9	24	1117	3	goldest
halibut	12	8	905	3	halibut
hallot	9	54	2678	3	hallo_t
handouts	12	3	823	3	handouts
hangout	11	4	1139	3	hangout
helot	8	53	3268	3	hel_o_t
hideout	11	7	979	3	hideout
hindgut	12	4	501	3	hindgut
hoedown	14	12	575	3	hoedown
hognut	10	3	941	3	ho_gnut
hold	8	62	3506	3	hold___
holdall	11	4	547	3	holdall
holddown	16	4	290	3	holddown
holden	10	41	1395	3	hold_en
holder	10	46	1965	3	hold_er
holders	11	37	1590	3	holders
holdfast	15	5	370	3	holdfast
holding	12	35	1428	3	holding
holdover	15	4	408	3	holdover
holds	9	46	2324	3	hold__s
holdups	13	3	359	3	holdups
holibuts	13	6	395	3	holibuts
holiest	10	43	1962	3	holiest
holist	9	47	2321	3	hol_ist
hollo	8	48	2216	3	hollo__
holloa	9	49	1482	3	hollo_a
holloas	10	38	1494	3	holloas
holloed	11	38	1275	3	holloed
holloes	10	38	1819	3	holloes
holloo	9	44	1525	3	hollo_o
holloos	10	40	1358	3	holloos
hollos	9	53	2063	3	hollo_s
hollow	12	42	1266	3	hollo_w
hollows	13	44	1233	3	hollows
holmium	14	4	544	3	holmium
holt	7	78	5258	3	hol___t
honour	9	47	1086	3	ho_nour
hoodlum	13	4	382	3	hoodlum
hoodoo	10	10	998	3	hoodo_o
hoodoos	11	10	929	3	hoodoos
hoot	7	57	5210	3	ho__o_t
hornpout	13	5	670	3	hornpout
hotdog	11	3	480	3	hotdo_g
hotdogs	12	3	445	3	hotdogs
hotfoot	13	4	705	3	hotfoot
iodous	7	3	1150	3	io_dous
lockout	13	5	933	3	lockout
lookout	11	4	803	3	lookout
lout	4	59	5214	3	__l_out
nodous	7	7	1133	3	no_dous
odour	6	47	1049	3	_o_dour
oldest	7	21	1409	3	_oldest
pullout	9	3	1059	3	pullout
readout	8	6	1551	3	readout
redout	7	18	2025	3	_redout
rollouts	8	13	673	3	rollouts
sellout	7	3	1358	3	sellout
shootout	11	4	662	3	shootout
soldo	6	71	1656	3	soldo__
vodou	9	3	934	3	vo_dou_
vodoun	10	3	623	3	vo_doun
vodous	10	3	860	3	vo_dous
volost	9	4	1264	3	vol_ost
voudoun	11	4	360	3	voudoun
walkout	14	4	793	3	walkout
woodcut	13	4	469	3	woodcut
workout	14	4	839	3	workout

Search took 8 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	134027	0.406	440125.6
2	DLD Change Limit	134027	91	6.593	20328.7
3	Display Results	91	91	0.033	2757.6
	(SQL Overall)	178691	91	7.032	25411.1