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

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

50 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
listings	9	33	1004	(None)
lastings	9	42	1442	1	lastings
listing	8	40	2059	1	listing_
bastings	11	42	1469	2	bastings
biestings	12	26	603	2	biestings
bittings	11	33	929	2	bittings
blastings	12	34	791	2	blastings
castings	11	36	1405	2	castings
dustings	10	41	903	2	dustings
eastings	9	34	1295	2	eastings
fastings	12	40	1194	2	fastings
fishings	15	30	769	2	fishings
fisting	11	38	1812	2	fisting_
fittings	12	31	820	2	fittings
hissings	12	55	675	2	hissings
histing	11	37	2037	2	histing_
hustings	12	37	868	2	hustings
jestings	16	36	802	2	jestings
kiltings	13	32	708	2	kiltings
lashings	12	44	1225	2	lashings
lasting	8	47	2524	2	lasting_
lickings	15	29	814	2	lickings
lifting	11	33	1327	2	lifting_
lightings	14	27	772	2	lightings
likings	12	53	941	2	li_kings
lilting	8	35	1538	2	lilting_
linings	8	43	1307	2	li_nings
linting	8	38	2098	2	linting_
lippings	13	29	609	2	lippings
lisping	10	34	1275	2	lisping_
listens	7	40	1413	2	listen_s
livings	11	40	892	2	li_vings
losings	8	28	1062	2	los_ings
lusting	8	36	1932	2	lusting_
lustrings	10	24	555	2	lustrings
lutings	8	33	1105	2	l_utings
misting	10	36	2338	2	misting_
pittings	11	34	912	2	pittings
postings	11	29	1230	2	postings
risings	8	32	1189	2	ris_ings
siftings	12	23	658	2	siftings
sittings	9	33	973	2	sittings
stings	7	62	2018	2	__stings
tintings	9	28	871	2	tintings
twistings	13	26	435	2	twistings
vestings	12	35	914	2	vestings
waistings	13	527	1076	2	waistings
westings	12	42	980	2	westings
wisting	11	35	1974	2	wisting_
wittings	12	32	873	2	wittings

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	121059	0.140	1276364.3
2	DLD Change Limit	121059	50	3.406	35542.9
3	Display Results	50	50	0.016	3125.0
	(SQL Overall)	178691	50	3.562	50165.9