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

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

74 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
foxhole	20	4	507	(None)
foxholes	21	4	469	1	foxholes
foveole	13	10	687	2	foveole
pothole	12	3	1217	2	pothole
airhole	10	4	827	3	airhole
armhole	12	3	694	3	armhole
asshole	10	4	679	3	asshole
blowhole	16	4	459	3	blowhole
bolthole	13	4	546	3	bolthole
borehole	13	4	762	3	borehole
coalhole	13	4	509	3	coalhole
condole	10	29	1495	3	condole
console	9	27	1598	3	console
dhole	9	52	1536	3	__dhole
exhale	16	3	687	3	_exhale
eyehole	13	4	600	3	eyehole
feedhole	15	4	387	3	feedhole
fishpole	16	4	405	3	fishpole
fixable	19	21	819	3	fixable
foghorn	14	4	543	3	foghorn
foible	11	4	1038	3	fo_ible
foliose	10	37	801	3	foliose
fondle	10	44	1294	3	fo_ndle
fool	7	53	3059	3	fo__ol_
fooled	10	43	1782	3	fo__oled
fools	8	68	2420	3	fo__ols
foothold	15	4	520	3	foothold
footle	9	39	1438	3	fo_otle
foozle	18	36	920	3	fo_ozle
forbode	13	25	796	3	forbode
forbore	12	24	967	3	forbore
fordone	11	4	938	3	fordone
forgone	11	3	934	3	forgone
formol	11	29	1033	3	formol_
formols	12	29	941	3	formols
foveola	13	11	501	3	foveola
foveolae	14	10	432	3	foveolae
foveoles	14	9	664	3	foveoles
foveolet	14	10	754	3	foveolet
foxfire	20	4	256	3	foxfire
foxglove	22	4	169	3	foxglove
foxhound	22	8	310	3	foxhound
foxhunt	20	4	317	3	foxhunt
foxily	19	4	725	3	fox_ily
foxlike	21	22	622	3	foxlike
frijole	17	3	458	3	frijole
hole	7	75	5339	3	___hole
keyhole	17	6	443	3	keyhole
knothole	15	4	407	3	knothole
loophole	13	5	863	3	loophole
manhole	12	3	1134	3	manhole
mudhole	13	4	491	3	mudhole
nonhome	12	4	883	3	nonhome
obole	7	59	1714	3	_o_bole
ochone	11	3	1129	3	_ochone
oilhole	10	4	626	3	oilhole
oriole	6	8	1429	3	_oriole
osmole	8	12	851	3	_osmole
piehole	12	18	855	3	piehole
pinhole	12	20	1043	3	pinhole
porthole	13	4	952	3	porthole
posole	8	3	1422	3	po_sole
posthole	13	3	953	3	posthole
potholed	14	4	839	3	potholed
potholes	13	3	1293	3	potholes
pozole	17	5	891	3	po_zole
rathole	10	3	1205	3	rathole
shothole	14	4	551	3	shothole
taphole	12	3	977	3	taphole
thole	8	56	2084	3	__thole
toehold	11	4	657	3	toehold
toluole	7	3	611	3	toluole
whole	11	44	1809	3	__whole
wormhole	16	4	466	3	wormhole

Search took 10 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	74	9.033	14837.5
3	Display Results	74	74	0.060	1233.3
	(SQL Overall)	178691	74	9.499	18811.6