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 “gnaws” 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.

100 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
gnaws9631114(None) 
gnars66718851gnars
gnats65217711gnats
gnaw86515741gnaw_
gnawn9517781gnawn
snaws86116361snaws
anas46649862ana_s
blaws105620462blaws
braws106425192braws
caws96036112_caws
chaws135022462chaws
claws106020832claws
craws105723122craws
daws86638242_daws
draws95119372draws
enows85115492enows
flaws115920342flaws
gabs76740422g_abs
gads67843392g_ads
gaes56348032g_aes
gags66441062g_ags
gals57946502g_als
gams76648882g_ams
gangs76222582gangs
gaps76042972g_aps
gars55750742g_ars
gas48870252g_a_s
gats56753442g_ats
gawk126716692g_awk
gawks136811632g_awks
gawp107618632g_awp
gawps115911012g_awps
gawsy12459092g_awsy
gays87338022g_ays
gears64628692gears
ghats95818612ghats
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
glows95518032glows
gnar56021382gna_r
gnarl65115572gnarl
gnarls74210772gnarls
gnarr64810692gnarr
gnarrs7407662gnarrs
gnash9449832gnash
gnat56034432gna_t
gnawed11427832gnawed
gnawer10386952gnawer
gnawers11356392gnawers
gnus56518002gn_us
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
gonads84511732gonads
grabs85719692grabs
grads75625752grads
grams85327312grams
grans64832542grans
grass66125202grass
grays95621332grays
grows95523922grows
guans64419442guans
guars65021052guars
haws106439442_haws
jaws145027292_jaws
knaps115511172knaps
knars94416112knars
knawe12397882knawe
knawes13328392knawes
knows124912412knows
laws76441682_laws
maws96437142_maws
nabs66236192_nabs
nags55436022_nags
nans46139402_nans
naos47429732_naos
naps66238582_naps
naw66346492_naw_
nays75931592_nays
news76127372_news
nows75738232_nows
paws96038182_paws
raws75238212_raws
saws75839482_saws
shaws116226262shaws
slaws85222712slaws
snags64421312snags
snaps74719562snaps
snaw78923072snaw_
snows84719892snows
taws75641592_taws
thaws116515462thaws
unais53420772unais
unaus53216572unaus
vaws105527322_vaws
waws106834902_waws
yaws105531212_yaws

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.296603685.8
2DLD Change Limit538001001.58034050.6
3Display Results1001000.0137692.3
 (SQL Overall)1786911001.88994595.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.