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

204 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
grandad103845(None) 
grandads1136551grandads
grandam1139391grandam
granddad1244251granddad
branded114414102branded
crawdad1443112crawdad
graded94919552gra_ded
grana65722092gran_a_
grand75122692gran__d
grandaddy1652112grandaddy
grandame1247112grandame
grandams1237122grandams
granddads1343462granddads
granddam1344692granddam
grandee93115512grandee
grander93315872grander
grandkid1543642grandkid
grandly1238742grandly
grandma1136912grandma
grandmas1236922grandmas
grandpa1135412grandpa
grandpas1236002grandpas
grands84218242grand_s
granted94715102granted
grinded104210632grinded
randan7315252_randan
araneid8310803araneid
audad71511393__audad
banda85223103_banda_
bandaid11310483_bandaid
bandas95120543_bandas
banded105223173_banded
bradded12388713bradded
braided114013213braided
brand85124493bran__d
brander103915823brander
brandied1259113brandied
brands95118943brand_s
brandy124712063brand_y
branned104311693branned
brinded115112053brinded
candid104517853_candid
caudad10157673_caudad
craned96121653cran_ed
crania82418433crania_
cranial92114683cranial
cranked143812843cranked
crawdads1542653crawdads
franked153610053franked
fronded12388863fronded
gadded103913173g_added
gadid85517383g_a_did
gander84322763g_ander
ganged94619193g_anged
ganja131410003g_anja_
ganjah17145503g_anjah
ganjas14149113g_anjas
ganoid8314443g_anoid
garda7316763g_arda_
gardai839663g_ardai
garlanded1244693garlanded
gaydar1135503g_aydar
geranial949283geranial
gladded11357453gladded
glanced11439233glanced
gland75217713glan__d
glandes95413833glandes
glands85314403gland_s
goaded94913713goa_ded
goanna736653goanna_
goannas836223goannas
gonad75216053g_on_ad
gonadal956523gonadal
graal64316503gra__al
grabbed13368643grabbed
graced105217903gra_ced
grad66829863gr___ad
gradate9511233gra_date
gradated1157433gra_dated
grade75126093gra_d_e
grader84919693gra_der
grades84926313gra_des
gradin83517483gra_din
grads75625753gra_d_s
gradual936943gradual
graduand1143893graduand
gradus84411223gra_dus
grafted124110223grafted
graham1237853gra_ham
grained93814273grained
grama85620283gra_ma_
gramas94317203gra_mas
gramma11499803gramma_
grammar12406893grammar
grammas12499773grammas
grampa115010173grampa_
grampas12399253grampas
gran56335013gran___
granary1157793granary
grandames1346713grandames
grandaunt1144703grandaunt
grandbaby1851733grandbaby
granddaddy1851333granddaddy
granddams1443483granddams
grandees103211283grandees
grandest10311573grandest
grandeur10305673grandeur
grandkids1643143grandkids
grandmama1592383grandmama
grandpapa1552023grandpapa
grandsir1044313grandsir
grandson1055413grandson
grandstand1353173grandstand
grange83716203gran_ge
granger93514213granger
granges93516523granges
granita82111303granita
granitas92610223granitas
granite82017083granite
grannie8310353grannie
granny104311163gran_ny
granola837913granola
granolas938053granolas
grans64832543gran__s
grant64840023gran__t
grantee83217133grantee
granter84117133granter
grantor84010933grantor
grants73722473gran_ts
granular946893granular
granule839473granule
granum9310913gran_um
graphed1498473graphed
grappa11396443grappa_
grappas12357103grappas
grasped11409063grasped
grassed93812793grassed
grated84523923gra_ted
graved114818813gra_ved
gravid113710983gra_vid
gravida12366563gravida_
gravidae13324793gravidae
gravidas13285803gravidas
gravlax1842643gravlax
grayed115415643gra_yed
graylag1283113graylag
grazed174115913gra_zed
grenade938413grenade
gridded11387583gridded
grided95117043gr_ided
grind75917563grin__d
grinder93312393grinder
grinds84511843grind_s
gringa838553gringa_
gringas938043gringas
grinned9378553grinned
groaned9259973groan_ed
grounded1136573grounded
grunted9339283grunted
guanay1037913guan_ay
guarded1036153guarded
handax1749583_handax
handed114919983_handed
landau7310613_landau
landed84619243_landed
panda85022613_panda_
pandas95521963_pandas
pranced123714043pranced
prandial1149643prandial
pranged114512553pranged
pranked143712093pranked
radar61316723_ra_dar
radded94716493_radded
raided85017703_raided
rancid9513863_rancid
rand55839573_ran__d
randans8313213_randans
random92513553_random
rands65930453_rand_s
randy95022083_rand_y
ranged84824313_ranged
ranid66429333_ran_id
ranked114620743_ranked
ranted74324703_ranted
rended84524103_rended
rinded84418983_rinded
sandal73317283_sandal
sanded84920613_sanded
scandal1038673scandal
standard1046253standard
stranded102710813stranded
traded85717683tra_ded
tranced104414173tranced
trangam1039353trangam
trended94011763trended
urania62516123urania_
uranias72113813uranias
vanda94515923_vanda_
vandal103713833_vandal
vandas103915993_vandas
veranda1156323veranda_
verandaed1443143verandaed
verandah1543623verandah
verandas1246233verandas

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272047.36018210.2
3Display Results2042040.0802550.0
 (SQL Overall)1786912047.59323533.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.