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 “gnawinh” with Change Limit: [1] [2] [3] [4]

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

99 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
gnawing12377901gnawing
gnawings13263772gnawings
gnawn9517782gnaw_n_
snawing113612482snawing
awing96827323__awing
blawing134012753blawing
cawing124322613_cawing
chawing164813033chawing
clawing133812673clawing
dawing114819823_dawing
drawing123812053drawing
enamine91214313enamine
entwine1039143entwine
enwind10298083en_wind
flawing143812563flawing
gaeing84617223g_aeing
gaging94718403g_aging
gain56042163g_a_in_
gains65729513g_a_ins
gamin84423003g_amin_
gamine94620153g_amine
gaming104622043g_aming
gamins94420053g_amins
ganging103216193ganging
gaping105618923g_aping
garish104516923g_arish
gating84826953g_ating
gawking16398823g_awking
gawkish1835833g_awkish
gawping14418463g_awping
gazing174717173g_azing
gearing92818843gearing
glaring93714883glaring
glazing183611003glazing
glowing123211793glowing
gnarling10217603gnarling
gnarring10225973gnarring
gnash9449833gna__sh
gnashing1336423gnashing
gnaw86515743gnaw___
gnawed11427833gnaw_ed
gnawer10386953gnaw_er
gnawers11356393gnawers
gnawingly1763933gnawingly
gnaws96311143gnaw__s
gnomish1345563gnomish
goading103112853goading
goaling93515333goaling
goatish1139563goatish
gracing113216443gracing
gradin83517483gradin_
gradine93317033gradine
grading103918713grading
gradins93416233gradins
grain65126253gra_in_
grains74223093gra_ins
grainy103914213gra_iny
gratin74520583gratin_
gratine84719193gratine
grating93923183grating
gratins84119183gratins
graving123114563graving
graying124115883graying
grayish1437813grayish
grazing183514553grazing
growing123512473growing
guanin7610803guanin_
guanine8810543guanine
guanins8810013guanins
gwine95513663g__wine
hawing134322353_hawing
intwine1038513intwine
inwind10268413in_wind
jawing174414963_jawing
knavish1743993knavish
knowing15287683knowing
lawine93316463_lawine
lawing104625283_lawing
mawing124020803_mawing
naming93917893_naming
narine63422553_narine
newish1237903_newish
pawing124519553_pawing
rawin85521473_rawin_
rawins95617623_rawins
rawish123012913_rawish
sawing104323813_sawing
shawing143514883shawing
snaking123915303snaking
snaring83920953snaring
snowing113913453snowing
tawing104521553_tawing
thawing14378683thawing
unaging9510933unaging
unakin10310963unakin_
untwine1038623untwine
unwind102610543un_wind
unwish1239093un_wish
yawing134215613_yawing

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027996.47020715.1
3Display Results99990.0303300.0
 (SQL Overall)178691996.90625874.7
 
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.