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

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

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.

92 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
loafer	9	36	1094	(None)
loader	7	43	1631	1	loader
loafed	10	40	1115	1	loafed
loafers	10	34	946	1	loafers
loaner	6	44	1650	1	loaner
bloater	9	40	1342	2	bloater
boater	8	46	2209	2	boater
chafer	14	47	1457	2	chafer
coaler	8	41	2171	2	coaler
coater	8	43	2957	2	coater
coaxer	15	39	1279	2	coaxer
coffer	14	41	1286	2	coffer
confer	11	40	1868	2	confer
deafer	10	41	1481	2	deafer
doffer	13	39	1135	2	doffer
floater	10	44	1335	2	floater
foamer	11	47	1431	2	foamer
gloater	8	37	1101	2	gloater
gofer	9	48	1428	2	go_fer
goffer	13	40	951	2	goffer
golfer	10	44	1118	2	golfer
hoaxer	16	34	856	2	hoaxer
hoofer	12	40	1495	2	hoofer
laager	7	43	1278	2	laager
lacer	7	58	3375	2	l_acer
lader	6	56	3372	2	l_ader
lager	6	51	3286	2	l_ager
laker	9	54	3287	2	l_aker
lamer	7	52	3370	2	l_amer
laser	5	46	3332	2	l_aser
later	5	48	4392	2	l_ater
laver	8	50	3179	2	l_aver
laxer	12	54	2033	2	l_axer
layer	8	46	2647	2	l_ayer
leader	7	48	2465	2	leader
leafed	10	57	1387	2	leafed
leafier	10	32	983	2	leafier
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
liefer	9	52	957	2	liefer
lifer	8	58	2215	2	l_ifer
loaded	8	46	1687	2	loaded
loaders	8	34	1343	2	loaders
loaf	7	67	3490	2	loaf__
loafs	8	56	1699	2	loaf_s
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
lodger	8	65	1769	2	lodger
lofter	9	46	1472	2	lofter
logger	8	64	2000	2	logger
logier	7	50	1573	2	logier
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
loser	5	47	2867	2	lo_ser
lotter	6	40	2560	2	lotter
louder	7	44	1460	2	louder
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
oater	5	54	3373	2	_oater
offer	11	43	1138	2	_offer
roamer	8	47	1516	2	roamer
roarer	6	39	1433	2	roarer
rolfer	9	44	1227	2	rolfer
roofer	9	44	1528	2	roofer
safer	8	47	2181	2	_safer
soaker	10	57	1753	2	soaker
soaper	8	45	1787	2	soaper
soarer	6	45	2224	2	soarer
wafer	11	44	1764	2	_wafer
wolfer	12	42	998	2	wolfer
woofer	12	44	1136	2	woofer

Search took 6 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	1.173	152336.7
2	DLD Change Limit	82551	92	4.266	19350.9
3	Display Results	92	92	0.016	5750.0
	(SQL Overall)	178691	92	5.455	32757.3