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

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

131 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
logier	7	50	1573	(None)
logger	8	64	2000	1	logger
loggier	9	38	1114	1	loggier
blogger	11	44	831	2	blogger
blowier	12	4	894	2	blowier
boggier	11	37	1158	2	boggier
bogie	8	95	2410	2	bogie_
bogies	9	47	2431	2	bogies
bonier	8	43	2199	2	bonier
boxier	15	43	1174	2	boxier
cagier	9	37	1593	2	cagier
clogger	11	43	880	2	clogger
cloggier	12	4	425	2	cloggier
copier	10	37	2289	2	copier
cosier	8	44	2375	2	cosier
cowier	11	36	1616	2	cowier
cozier	17	33	1514	2	cozier
dodgier	10	38	824	2	dodgier
dogger	9	52	1678	2	dogger
doggier	10	38	1094	2	doggier
dogie	7	52	2279	2	dogie_
dogies	8	50	2225	2	dogies
dopier	9	35	1592	2	dopier
dotier	7	39	1703	2	dotier
dozier	16	36	1163	2	dozier
edgier	8	46	972	2	edgier
flogger	12	44	945	2	flogger
fogger	11	44	1477	2	fogger
foggier	12	34	991	2	foggier
fogie	9	67	1900	2	fogie_
fogies	10	41	1806	2	fogies
foxier	16	39	1003	2	foxier
fozier	18	37	1066	2	fozier
gooier	7	35	1621	2	gooier
gorier	7	37	1937	2	gorier
hogger	11	46	1508	2	hogger
hokier	13	42	1403	2	hokier
holier	9	49	2162	2	holier
homier	11	64	1699	2	homier
hosier	9	42	1961	2	hosier
jogger	15	47	1316	2	jogger
jokier	17	61	875	2	jokier
lacier	8	40	2009	2	lacier
lager	6	51	3286	2	lag_er
lagger	8	59	1983	2	lagger
lakier	10	47	1627	2	lakier
lazier	15	42	1461	2	lazier
ledgier	9	45	849	2	ledgier
leger	6	57	2150	2	leg_er
leggier	9	36	823	2	leggier
levier	9	40	1387	2	levier
lier	4	59	4246	2	l__ier
liger	6	50	2446	2	lig_er
limier	8	35	1871	2	limier
lingier	8	41	1337	2	lingier
linier	6	44	2378	2	linier
livier	9	75	1459	2	livier
loader	7	43	1630	2	loader
loafer	9	36	1094	2	loafer
loamier	9	34	916	2	loamier
loaner	6	44	1650	2	loaner
lobber	10	40	1659	2	lobber
locker	12	40	1942	2	locker
lodger	8	65	1768	2	lodger
lofter	9	46	1472	2	lofter
loftier	10	3	776	2	loftier
loge	5	68	3719	2	log_e_
loges	6	65	3420	2	log_es
logged	9	66	2294	2	logged
loggers	9	46	1613	2	loggers
loggie	8	40	1199	2	loggie_
logia	6	81	1660	2	logi_a
logic	8	82	1783	2	logi_c
logics	9	57	1112	2	logics
logiest	8	25	1554	2	logiest
logily	10	3	983	2	logily
login	6	60	2500	2	logi_n
logins	7	78	2064	2	logins
logion	7	60	1372	2	logion
loiter	6	46	1917	2	loiter
loller	6	33	1528	2	loller
loner	5	54	3103	2	lo_ner
longer	7	58	2319	2	longer
longies	8	29	1655	2	longies
looie	5	56	2424	2	looie_
looies	6	50	2583	2	looies
looker	10	48	1695	2	looker
loonier	7	33	1267	2	loonier
looper	8	38	1711	2	looper
loopier	9	37	1119	2	loopier
looser	6	52	1994	2	looser
looter	6	42	2232	2	looter
loper	7	51	2923	2	lo_per
lopper	10	37	1720	2	lopper
loppier	11	36	972	2	loppier
lories	6	49	3304	2	lories
lorimer	9	3	775	2	lorimer
loriner	7	5	1188	2	loriner
loser	5	47	2867	2	lo_ser
lotter	6	40	2560	2	lotter
louder	7	44	1460	2	louder
louie	5	50	2351	2	louie_
louies	6	45	2510	2	louies
lousier	7	24	1162	2	lousier
louver	9	41	1039	2	louver
lover	8	55	2645	2	lo_ver
lower	8	58	3041	2	lo_wer
lowlier	10	33	890	2	lowlier
luger	6	53	2208	2	lug_er
lugger	8	39	1655	2	lugger
lunier	6	46	1760	2	lunier
mopier	10	39	1478	2	mopier
nosier	6	37	1632	2	nosier
ogler	6	59	1744	2	_ogler
ologies	8	6	1502	2	ologies
oozier	15	36	1025	2	oozier
osier	5	35	1801	2	_osier
podgier	11	33	872	2	podgier
pogies	9	41	2354	2	pogies
pokier	12	49	1463	2	pokier
poxier	15	38	1211	2	poxier
roger	6	45	2141	2	rog_er
ropier	8	41	1880	2	ropier
rosier	6	42	2126	2	rosier
sagier	7	37	1716	2	sagier
slogger	9	43	1048	2	slogger
soggier	9	34	1088	2	soggier
tonier	6	55	2071	2	tonier
vogie	9	51	1666	2	vogie_
voguer	10	46	840	2	voguer
zooier	15	34	1123	2	zooier

Search took 7 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	131	6.643	12426.8
3	Display Results	131	131	0.123	1065.0
	(SQL Overall)	178691	131	6.876	25987.6