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

125 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
grandads113655(None) 
grandad1038451grandad_
grandams1237121grandams
granddads1343461granddads
crawdads1542652crawdads
grandaddy1652112grandaddy
grandam1139392granda_m
grandame1247112grandame
grandames1346712grandames
granddad1244252granddad
granddam1344692granddam
granddams1443482granddams
grandees103211282grandees
grandkids1643142grandkids
grandmas1236922grandmas
grandpas1236002grandpas
grands84218242gran__ds
randans8313212_randans
araneids947743araneids
audads8167103__audads
bandas95120543_banda_s
branded114414103branded_
branders114313093branders
brandies11714563brandies
brands95118943bran__ds
candids113812693_candids
crawdad1443113crawdad_
gadids95611823g_a_dids
ganders93521703g_anders
ganjahs18104003g_anjahs
ganjas14149113g_anja_s
ganoids939333g_anoids
gaydars1235803g_aydars
geranials1045913geranials
glanders103811503glanders
glandes95413833gland_es
glands85314403glan__ds
goannas836223goanna_s
gonads84511733g_on_ads
graals74112913gra__als
gradate9511233gra_date
gradates10510783gra_dates
graded94919553gra_ded_
graders94716013gra_ders
grades84926313gra_d_es
gradins93416233gra_dins
grads75625753gr___ads
graduals1046203graduals
graduands1243583graduands
gradus84411223gra_d_us
grahams1335333gra_hams
gramas94317203gra_ma_s
grammars13345943grammars
grammas12499773gramma_s
grampas12399253grampa_s
grana65722093gran_a__
granary1157793gran_ary
grand75122693gran__d_
grandaddies1552303grandaddies
grandaunt1144703grandaunt
grandaunts1252943grandaunts
grandbaby1851733grandbaby
granddaddy1851333granddaddy
grandee93115513grand_ee
grander93315873grand_er
grandest10311573grandest
grandeur10305673grandeur
grandeurs11335113grandeurs
grandiose1145793grandiose
grandioso1143913grandioso
grandkid1543643grandkid
grandly1238743grand_ly
grandma1136913grand_ma
grandmama1592383grandmama
grandmamas1672193grandmamas
grandness1138303grandness
grandpa1135413grand_pa
grandpapa1552023grandpapa
grandpapas1651953grandpapas
grandsir1044313grandsir
grandsirs1144553grandsirs
grandson1055413grandson
grandsons1145123grandsons
grandstands1452643grandstands
grangers103011973grangers
granges93516523gran_ges
granitas92610223granitas
granites92116363granites
grannies9312613grannies
granolas938053granolas
grans64832543gran___s
granted94715103granted_
grantees92510973grantees
granters93614143granters
grantors93810353grantors
grants73722473gran__ts
granules939933granules
grappas12357103grappa_s
gravidas13285803gravida_s
gravlaks1642423gravlaks
graylags1372983graylags
grenade938413gren_ade
grenades1038433grenades
grinded104210633grinded_
grinders103410423grinders
grinds84511843grin__ds
gringas938043gringa_s
guanays1134953guan_ays
landaus8310343_landaus
pandas95521963_panda_s
radars71314673_ra_dars
randan7315253_randa_n
randies84225663_randies
randoms102112433_randoms
rands65930453_ran__ds
ranids75118703_ran_ids
sandals82715203_sandals
scandals1136993scandals
standards1145203standards
trangams1147203trangams
uranias72113813urania_s
vandals113211663_vandals
vandas103915993_vanda_s
verandahs1642293verandahs
verandas1246233veranda_s

Search took 9 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.470380193.6
2DLD Change Limit1461621257.54619369.5
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.06222164.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.