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

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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
gnarls7421077(None) 
gnarl65115571gnarl_
gnarly104610381gnarly
gnarrs7407661gnarrs
gnars66718851gnar_s
snarls64016871snarls
agnails837002agnails
carls77037422_carls
earls56127512_earls
farls85731112_farls
galls64729322g_alls
gals57946502g_a_ls
gaols66717572g_aols
garbs86321412g_arbs
gars55750742g_ar_s
gears64628692gear_s
girls64518392g_irls
glares75518862glares
gnar56021382gnar__
gnarled9287722gnarled
gnarr64810692gnar_r
gnats65217712gna_ts
gnaws96311142gna_ws
goals65521292goa_ls
gorals76917652gorals
graals74112912graals
grails77518782grails
guards84611572guards
guars65021052guar_s
harls85634502_harls
inarms8410092inarms
jarls126120962_jarls
knars94416112knar_s
knurls10396242knurls
marls75535162_marls
nails55730402_nails
narcs76122022_narcs
nards65928462_nards
nares55544152_nares
naris55735292_naris
narks96026032_narks
nurls55519682_nurls
pearls84715392pearls
snails64816652snails
snares65329032snares
snarfs95113422snarfs
snarks104815732snarks
snarl54921082snarl_
snarly93815002snarly
unarms839242unarms

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551502.32635490.5
3Display Results50500.0163125.0
 (SQL Overall)178691502.45272875.6
 
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.