Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

47 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
gnawn951778(None) 
gnaw86515741gnaw_
gnaws96311141gnaws
awn68035912__awn
blawn106813702blawn
brawn106018562brawn
dawn85624202_dawn
drawn95614242drawn
fawn105321952_fawn
gaen57329602g_aen
gain56042162g_ain
gan48060132g_a_n
gaun56427712g_aun
gawk126716692g_awk
gawp107618632g_awp
gnar56021382gna_r
gnarl65115572gnarl
gnarr64810692gnarr
gnars66718852gnars
gnash9449832gnash
gnat56034432gna_t
gnats65217712gnats
gnawed11427832gnawed
gnawer10386952gnawer
gnawing12377902gnawing
gowan95415742gowan
gown85724072g_own
grain65126252grain
gran56335012gra_n
grown95317352grown
guan55325582gua_n
knawe12397882knawe
known12568342known
lawn75925632_lawn
mawn94424142_mawn
naan47621932_naan
nan37854882_na_n
naw66346492_naw_
pawn94625302_pawn
prawn105312432prawn
sawn75428162_sawn
shawn116417612shawn
snaw78923072snaw_
snaws86116362snaws
spawn107811712spawn
unsawn9317462unsawn
yawn106219092_yawn

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.313570897.8
2DLD Change Limit53800471.61033416.1
3Display Results47470.0133615.4
 (SQL Overall)178691471.93692299.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.