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

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

103 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
hoising	11	34	1441	(None)
hoisting	12	36	1090	1	hoisting
horsing	11	32	1558	1	horsing
hosing	10	34	2110	1	ho_sing
housing	11	33	1652	1	housing
noising	8	36	1517	1	noising
poising	10	36	1710	1	poising
arising	8	36	1997	2	arising
boiling	10	38	1967	2	boiling
bossing	10	37	1460	2	bossing
bousing	10	37	1804	2	bousing
bowsing	13	40	1250	2	bowsing
choiring	14	27	979	2	choiring
choosing	14	20	1013	2	choosing
chousing	14	25	942	2	chousing
chowsing	17	21	734	2	chowsing
coifing	13	32	1389	2	coifing
coiling	10	37	2345	2	coiling
coining	10	39	2054	2	coining
dosing	8	39	2027	2	do_sing
dossing	9	33	1327	2	dossing
dousing	9	33	1576	2	dousing
dowsing	12	34	1112	2	dowsing
foiling	11	33	1765	2	foiling
foining	11	30	1345	2	foining
foisting	12	29	1050	2	foisting
goosing	9	33	1408	2	goosing
guising	9	35	1141	2	guising
hailing	11	38	2069	2	hailing
heiling	11	36	1636	2	heiling
heiring	11	33	1290	2	heiring
heisting	12	34	1104	2	heisting
hiding	11	43	1933	2	h_iding
hieing	10	42	1662	2	h_ieing
hiking	14	36	1710	2	h_iking
hiring	10	44	2160	2	h_iring
hissing	11	42	1314	2	hissing
histing	11	37	2037	2	h_isting
hiving	13	41	1552	2	h_iving
hoaxing	18	30	776	2	hoaxing
hobbing	15	28	1112	2	hobbing
hoboing	13	30	945	2	hoboing
hocking	17	34	1724	2	hocking
hocusing	14	4	658	2	hocusing
hoeing	10	41	1702	2	ho_eing
hogging	13	31	1280	2	hogging
hoicking	18	3	605	2	hoicking
hoking	14	44	1951	2	ho_king
holding	12	35	1428	2	holding
holing	10	40	2507	2	ho_ling
holking	15	35	1231	2	holking
homing	12	37	1838	2	ho_ming
honing	10	34	2150	2	ho_ning
honking	15	34	1479	2	honking
hooding	12	38	1520	2	hooding
hoofing	14	39	1255	2	hoofing
hooking	15	37	1669	2	hooking
hooping	13	36	1570	2	hooping
hooting	11	39	1988	2	hooting
hoping	12	37	1974	2	ho_ping
hopping	15	41	1527	2	hopping
hording	12	35	1705	2	hording
horning	11	30	1500	2	horning
hosting	11	43	1838	2	hosting
hotting	11	31	1652	2	hotting
housings	12	30	748	2	housings
howking	18	36	1031	2	howking
howling	14	34	1316	2	howling
iodising	10	3	756	2	iodising
ionising	9	3	1022	2	ionising
irising	8	36	1442	2	irising
joining	15	30	1148	2	joining
joisting	16	32	850	2	joisting
loiding	9	33	1340	2	loiding
loosing	8	35	1596	2	loosing
losing	7	40	2287	2	lo_sing
lousing	8	38	1773	2	lousing
moiling	10	34	1766	2	moiling
mossing	10	39	1542	2	mossing
mousing	10	38	1627	2	mousing
noosing	8	33	1505	2	noosing
nosing	7	34	1984	2	no_sing
oiling	7	49	2531	2	_oiling
peising	10	34	1676	2	peising
posing	9	39	2264	2	po_sing
prising	10	33	2145	2	prising
raising	8	32	2053	2	raising
rising	7	40	2588	2	_rising
roiling	8	32	2045	2	roiling
roosing	8	40	1813	2	roosing
rosing	7	39	2559	2	ro_sing
rousing	8	39	2055	2	rousing
seising	8	40	1886	2	seising
soiling	8	34	2232	2	soiling
sousing	8	35	1782	2	sousing
toiling	8	32	1902	2	toiling
toiting	8	32	1709	2	toiting
tossing	8	36	1256	2	tossing
tousing	8	29	1699	2	tousing
vising	10	39	1587	2	_vising
voicing	13	27	908	2	voicing
voiding	12	29	1036	2	voiding
wising	10	33	1822	2	_wising

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	107671	0.126	1418182.5
2	DLD Change Limit	107671	103	3.280	32826.5
3	Display Results	103	103	0.033	3121.2
	(SQL Overall)	178691	103	3.439	51960.2