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

126 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
grandams123712(None) 
grandads1136551grandads
grandam1139391grandam_
grandame1247111grandame
grandames1346711grandames
granddams1443481granddams
grandmas1236921grandmas
grahams1335332gra_hams
grandad1038452granda_d
granddads1343462granddads
granddam1344692granddam_
grandees103211282grandees
grandma1136912grand_ma
grandmama1592382grandmama
grandmamas1672192grandmamas
grandpas1236002grandpas
grands84218242grand__s
randans8313212_randans
randoms102112432_randoms
trangams1147202trangams
bandas95120543_banda_s
bantams1149063_bantams
branders114313093branders
brandies11714563brandies
brands95118943brand__s
craniums1297913craniums
crawdads1542653crawdads
fandoms13229473_fandoms
ganders93521703g_anders
ganjahs18104003g_anjahs
ganjas14149113g_anja_s
gaydars1235803g_aydars
geranials1045913geranials
geraniums1245253geraniums
glanders103811503glanders
glandes95413833gland_es
glands85314403gland__s
goannas836223goanna_s
goddams1233983g_oddams
graals74112913gra__als
gradate9511233gra_date
gradates10510783gra_dates
graders94716013gra_ders
grades84926313gra_d_es
gradins93416233gra_dins
grads75625753gra_d__s
graduals1046203graduals
gradus84411223gra_d_us
graham1237853gra_ham_
gramas94317203gra_ma_s
grammars13345943grammars
grammas12499773gramma_s
grampas12399253grampa_s
grams85327313gr___ams
grana65722093gran_a__
granary1157793gran_ary
grand75122693grand___
grandaddy1652113grandaddy
grandaunt1144703grandaunt
grandaunts1252943grandaunts
grandbaby1851733grandbaby
granddad1244253granddad
grandee93115513grand_ee
grander93315873grand_er
grandest10311573grandest
grandeur10305673grandeur
grandeurs11335113grandeurs
grandiose1145793grandiose
grandioso1143913grandioso
grandkid1543643grandkid
grandkids1643143grandkids
grandly1238743grand_ly
grandness1138303grandness
grandpa1135413grand_pa
grandpapa1552023grandpapa
grandpapas1651953grandpapas
grandsir1044313grandsir
grandsirs1144553grandsirs
grandson1055413grandson
grandsons1145123grandsons
grangers103011973grangers
granges93516523gran_ges
granitas92610223granitas
granites92116363granites
grannies9312613grannies
granolas938053granolas
grans64832543gran___s
grantees92510973grantees
granters93614143granters
grantors93810353grantors
grants73722473gran__ts
granules939933granules
granum9310913gran_um_
grappas12357103grappa_s
gravidas13285803gravida_s
gravlaks1642423gravlaks
graylags1372983graylags
grenades1038433grenades
grinders103410423grinders
grinds84511843grind__s
gringas938043gringa_s
grograms1246023grograms
guanays1134953guan_ays
landaus8310343_landaus
madams11310943_ma_dams
mandamus1345523_mandamus
pandas95521963_panda_s
praams10459643pra__ams
radars71314673_ra_dars
randan7315253_randa_n
randies84225663_randies
random92513553_random_
rands65930453_rand__s
ransoms92410163_ransoms
sandals82715203_sandals
scandals1136993scandals
tandems1037633_tandems
trangam1039353trangam_
transoms1048933transoms
uranias72113813urania_s
uranisms1099973uranisms
uraniums10117163uraniums
vandals113211663_vandals
vandas103915993_vanda_s
verandahs1642293verandahs
verandas1246233veranda_s

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621266.37622923.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.84226116.8
 
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.