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

120 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
grandmas123692(None) 
grandams1237121grandams
grandma1136911grandma_
grandpas1236001grandpas
gramas94317202gra__mas
grammas12499772gra_mmas
grandad1038452grand_ad
grandads1136552grandads
grandam1139392grand_am
grandame1247112grandame
grandames1346712grandames
granddad1244252granddad
granddads1343462granddads
granddam1344692granddam
granddams1443482granddams
grandees103211282grandees
grandmama1592382grandmama
grandmamas1672192grandmamas
grandpa1135412grandpa_
grands84218242grand__s
granitas92610222granitas
granolas938052granolas
animas84418723__animas
bandas95120543_band_as
brahmas1436733bra_hmas
branders114313093branders
brandies11714563brandies
brands95118943brand__s
drachmas1644863drachmas
dramas95814663dra__mas
gamas85431363g_a__mas
gammas115714693g_a_mmas
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
grahams1335333graham_s
grama85620283gra__ma_
gramma11499803gra_mma_
grammar12406893gra_mmar
grammars13345943gra_mmars
grammes123611323gra_mmes
grampas12399253gra_mpas
gramps114114273gra__mps
grams85327313gra__m_s
grana65722093gran__a_
grand75122693grand___
grandbaby1851733grandbaby
grandee93115513grand_ee
grander93315873grand_er
grandest10311573grandest
grandeur10305673grandeur
grandeurs11335113grandeurs
grandiose1145793grandiose
grandioso1143913grandioso
grandkid1543643grandkid
grandkids1643143grandkids
grandly1238743grand_ly
grandness1138303grandness
grandpapa1552023grandpapa
grandpapas1651953grandpapas
grandsir1044313grandsir
grandsirs1144553grandsirs
grandson1055413grandson
grandsons1145123grandsons
grangers103011973grangers
granges93516523gran_ges
granita82111303granita_
granites92116363granites
grannies9312613grannies
granola837913granola_
grans64832543gran___s
grantees92510973grantees
granters93614143granters
grantors93810363grantors
grants73722473gran__ts
grantsman1265053grantsman
granular946893granular
granules939933granules
granulomas1352113granulomas
granum9310913granum__
grappas12357103gra_ppas
gravidas13285803gravidas
gravitas12316013gravitas
grinders103410423grinders
grinds84511843grind__s
gringas938043grin_gas
groundmass1451933groundmass
landman1038923_landman
landmass1144423_landmass
panamas113112763_panamas
pandas95521963_pand_as
prandial1149643prandial
randan7315253_rand_an
randans8313213_randans
randies84225663_randies
randoms102112433_randoms
rands65930453_rand__s
ranulas7311773_ranulas
sandman10310173_sandman
scandias1137863scandias
sraddhas1342623sraddhas
sradhas1176153sra_dhas
trangams1147203trangams
traumas938593tra_umas
uranias72113813uran_ias
vandas103915993_vand_as
verandas1246233verand_as

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.403443402.0
2DLD Change Limit1461621206.48622535.0
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.93525766.5
 
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.