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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
grandpas123600(None) 
grandmas1236921grandmas
grandpa1135411grandpa_
grampas12399252gra_mpas
grandad1038452grand_ad
grandads1136552grandads
grandam1139392grand_am
grandams1237122grandams
granddad1244252granddad
granddads1343462granddads
granddam1344692granddam
granddams1443482granddams
grandees103211282grandees
grandma1136912grandma_
grandpapa1552022grandpapa
grandpapas1651952grandpapas
grands84218242grand__s
granitas92610222granitas
granolas938052granolas
grappas12357102gra_ppas
bandas95120543_band_as
branders114313093branders
brandies11714563brandies
brands95118943brand__s
ganders93521703g_anders
ganjas14149113g_an_jas
gerardias1144403gerardias
giardias1045023giardias
girandolas1252243girandolas
glanders103811503glanders
glandes95413833gland_es
glands85314403gland__s
goannas836223goan_nas
graders94716013gra_ders
grades84926313gra_d_es
gradins93416233gra_dins
grads75625753gra_d__s
gradual936943gra_dual
graduals1046203gra_duals
gradus84411223gra_d_us
gramas94317203gra__mas
grammas12499773gra_mmas
grampa115010173gra_mpa_
gramps114114273gra_mp_s
grampus12356313gra_mpus
grana65722093gran__a_
grand75122693grand___
grandame1247113grandame
grandames1346713grandames
grandbaby1851733grandbaby
grandee93115513grand_ee
grander93315873grand_er
grandest10311573grandest
grandeur10305673grandeur
grandeurs11335113grandeurs
grandiose1145793grandiose
grandioso1143913grandioso
grandkid1543643grandkid
grandkids1643143grandkids
grandly1238743grand_ly
grandmama1592383grandmama
grandmamas1672193grandmamas
grandness1138303grandness
grandsir1044313grandsir
grandsirs1144553grandsirs
grandson1055413grandson
grandsons1145123grandsons
grangers103011973grangers
granges93516523gran_ges
granita82111303granita_
granites92116363granites
grannies9312613grannies
granola837913granola_
grans64832543gran___s
grantees92510973grantees
granters93614143granters
grantors93810363grantors
grants73722473gran__ts
granular946893granular
granules939933granules
grapes95123123gra__pes
graphs124510153gra__phs
grappa11396443gra_ppa_
grasps9489253gra_sp_s
gravidas13285803gravidas
gravitas12316013gravitas
grinders103410423grinders
grinds84511843grind__s
gringas938043grin_gas
pandas95521963_pand_as
prandial1149643prandial
randan7315253_rand_an
randans8313213_randans
randies84225663_randies
randoms102112433_randoms
rands65930453_rand__s
ranulas7311773_ranulas
scandias1137863scandias
sraddhas1342623sraddhas
sradhas1176153sra_dhas
standpat1145723standpat
uranias72113813uran_ias
vandas103915993_vand_as
verandas1246233verand_as

Search took 8 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 Filter1786911461620.500357382.0
2DLD Change Limit1461621047.26620115.9
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.81222873.9
 
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.