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

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

56 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
yawners	13	36	718	(None)
fawners	13	38	849	1	fawners
pawners	12	43	1107	1	pawners
yarners	10	43	1220	1	yarners
yawner	12	42	847	1	yawner_
yawpers	15	34	685	1	yawpers
banners	9	40	1871	2	banners
bawlers	12	44	1273	2	bawlers
caners	8	46	2920	2	ca_ners
canners	9	38	2266	2	canners
damners	10	41	1211	2	damners
darners	8	38	1577	2	darners
downers	11	39	1277	2	downers
earners	7	40	1645	2	earners
fanners	10	39	1465	2	fanners
fawner	12	59	1046	2	fawner_
gainers	8	42	1459	2	gainers
garners	8	38	1598	2	garners
gawkers	15	34	745	2	gawkers
gawpers	13	44	831	2	gawpers
hawkers	17	42	1033	2	hawkers
hawsers	13	40	948	2	hawsers
lanners	7	36	1833	2	lanners
lawyers	13	37	715	2	lawyers
manners	9	34	1783	2	manners
owners	9	42	1070	2	_owners
panners	9	36	2127	2	panners
pawers	11	48	1878	2	paw_ers
pawnees	12	29	817	2	pawnees
pawner	11	42	1292	2	pawner_
pawnors	12	29	720	2	pawnors
prawners	13	4	600	2	prawners
rawness	10	3	815	2	rawness
sawers	9	46	2016	2	saw_ers
sawneys	13	27	464	2	sawneys
sawyers	13	31	753	2	sawyers
spawners	13	39	649	2	spawners
tanners	7	40	1839	2	tanners
tawers	9	41	1860	2	taw_ers
tawneys	13	32	477	2	tawneys
vanners	10	36	1284	2	vanners
warners	10	33	1556	2	warners
yabbers	14	38	935	2	yabbers
yagers	10	51	1453	2	ya_gers
yakkers	13	30	427	2	yakkers
yammers	14	34	1032	2	yammers
yappers	14	40	1225	2	yappers
yarders	11	32	1159	2	yarders
yarner	9	33	1306	2	yarner_
yatters	10	39	1462	2	yatters
yaupers	12	33	766	2	yaupers
yawned	13	50	984	2	yawne_d
yawns	11	42	1327	2	yawn__s
yawper	14	43	795	2	yawper_
yearners	11	34	637	2	yearners
yowlers	13	32	892	2	yowlers

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.376	475242.0
2	DLD Change Limit	107671	56	3.390	31761.4
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	3.796	47073.5