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

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

146 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
loader	7	43	1631	(None)
lader	6	56	3372	1	l_ader
leader	7	48	2465	1	leader
loaded	8	46	1687	1	loaded
loaders	8	34	1343	1	loaders
loafer	9	36	1094	1	loafer
loaner	6	44	1650	1	loaner
louder	7	44	1460	1	louder
beader	9	46	2379	2	beader
blader	9	36	1858	2	blader
bloater	9	40	1342	2	bloater
blonder	10	40	1194	2	blonder
boarder	10	39	1032	2	boarder
boater	8	46	2209	2	boater
bolder	9	48	2093	2	bolder
bonder	9	53	2478	2	bonder
border	9	44	1997	2	border
broader	10	34	1261	2	broader
clowder	13	36	794	2	clowder
coaler	8	41	2171	2	coaler
coater	8	43	2957	2	coater
coaxer	15	39	1279	2	coaxer
codder	10	44	1634	2	codder
coder	8	61	3422	2	co_der
colder	9	51	2185	2	colder
corder	9	43	2288	2	corder
deader	8	42	2047	2	deader
dodder	9	47	1291	2	dodder
evader	10	3	681	2	evader
fader	9	44	2151	2	_fader
floater	10	44	1335	2	floater
flooder	11	25	846	2	flooder
foamer	11	47	1431	2	foamer
fodder	11	47	1211	2	fodder
folder	10	43	1754	2	folder
fonder	10	41	2006	2	fonder
gloater	8	37	1101	2	gloater
goaded	9	49	1371	2	goaded
golder	8	44	1760	2	golder
grader	8	49	1969	2	grader
header	10	44	2254	2	header
hoarder	11	32	923	2	hoarder
hoaxer	16	34	856	2	hoaxer
holder	10	46	1965	2	holder
laager	7	43	1278	2	laager
lacer	7	58	3375	2	l_acer
ladder	8	46	1762	2	ladder
lade	5	63	4598	2	l_ade_
laded	7	42	3261	2	l_aded
laden	6	50	2219	2	l_aden
laders	7	49	2776	2	l_aders
lades	6	51	4127	2	l_ades
ladler	7	43	1493	2	l_adler
lager	6	51	3286	2	l_ager
laker	9	54	3287	2	l_aker
lamer	7	52	3370	2	l_amer
lander	7	40	2848	2	lander
larder	7	37	2097	2	larder
laser	5	46	3332	2	l_aser
later	5	48	4392	2	l_ater
lauder	7	38	1501	2	lauder
laver	8	50	3179	2	l_aver
laxer	12	54	2033	2	l_axer
layer	8	46	2647	2	l_ayer
leaded	8	42	2154	2	leaded
leaden	7	45	1522	2	leaden
leaders	8	38	1960	2	leaders
leadier	8	32	1272	2	leadier
leaker	10	46	2007	2	leaker
leaner	6	40	2219	2	leaner
leaper	8	81	1894	2	leaper
leaser	6	53	2267	2	leaser
leaver	9	43	2151	2	leaver
lender	7	39	2127	2	lender
lewder	10	47	961	2	lewder
lieder	7	49	1232	2	lieder
load	5	67	3060	2	load__
loads	6	53	2337	2	load_s
loafed	10	40	1115	2	loafed
loafers	10	34	946	2	loafers
loamed	9	44	1461	2	loamed
loamier	9	34	916	2	loamier
loaned	7	38	1629	2	loaned
loaners	7	39	1362	2	loaners
loather	10	37	1100	2	loather
loaves	9	48	1385	2	loaves
lobber	10	40	1660	2	lobber
locater	9	31	1360	2	locater
locker	12	40	1942	2	locker
lode	5	62	4011	2	lo_de_
loden	6	66	2114	2	lo_den
lodes	6	64	3691	2	lo_des
lodger	8	65	1769	2	lodger
lofter	9	46	1472	2	lofter
logger	8	64	2000	2	logger
logier	7	50	1573	2	logier
loided	8	34	1402	2	loided
loiter	6	46	1917	2	loiter
loller	6	33	1528	2	loller
loner	5	54	3104	2	lo_ner
longer	7	58	2320	2	longer
looker	10	48	1695	2	looker
looper	8	38	1711	2	looper
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
lorded	8	49	1673	2	lorded
loser	5	47	2867	2	lo_ser
lotter	6	40	2560	2	lotter
louden	7	37	1179	2	louden
louver	9	41	1039	2	louver
lover	8	55	2645	2	lo_ver
lower	8	58	3041	2	lo_wer
loyaler	10	3	508	2	loyaler
moaner	8	44	1511	2	moaner
molder	9	38	1927	2	molder
nodder	8	48	1194	2	nodder
oater	5	54	3373	2	_oater
odder	7	45	1539	2	_odder
older	6	51	2117	2	_older
order	6	50	1936	2	_order
pleader	10	35	1175	2	pleader
plodder	11	4	600	2	plodder
polder	9	40	1925	2	polder
ponder	9	45	2169	2	ponder
powder	12	36	1190	2	powder
reader	7	36	2829	2	reader
reloader	9	3	791	2	reloader
roadeo	7	5	1032	2	roadeo
roamer	8	47	1516	2	roamer
roarer	6	39	1433	2	roarer
shader	10	42	1876	2	shader
soaker	10	57	1753	2	soaker
soaper	8	45	1787	2	soaper
soarer	6	45	2224	2	soarer
solder	7	39	2134	2	solder
sonder	7	36	2352	2	sonder
spader	9	43	1713	2	spader
trader	7	52	1876	2	trader
unloader	9	3	664	2	unloader
voider	10	36	1155	2	voider
wader	9	53	2536	2	_wader
woaded	11	52	1160	2	woaded
wonder	10	36	1781	2	wonder
yonder	10	32	1413	2	yonder

Search took 3 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.343	520965.0
2	DLD Change Limit	82551	146	2.453	33653.1
3	Display Results	146	146	0.046	3173.9
	(SQL Overall)	178691	146	2.842	62875.1