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

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

247 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
grads7562575(None) 
brads85528291brads
gads67843381g_ads
glads75620611glads
goads77022851goads
grabs85719691grabs
grad66829861grad_
grade75126091grade
grades84926311grades
gradus84411221gradus
grams85327311grams
grands84218241grands
grans64832541grans
grass66125201grass
grays95621331grays
grids75321391grids
rads56046601_rads
ads49755732__ads
araks94820882araks
bads77048862_bads
bards87139642bards
beads85429502beads
brad75234342brad_
braes75735052braes
brags85625102brags
braids95015692braids
brands95118942brands
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
breads95419202breads
broads94515152broads
cads76144522_cads
cards85137932cards
chads116122232chads
clads85722732clads
crabs95421392crabs
crags85622572crags
crams96229152crams
craps95328642craps
crass76328042crass
craws105723122craws
creds85418772creds
cruds85815852cruds
dads67442772_dads
deads75726912deads
drabs85119672drabs
drags75521112drags
drams86025832drams
drats66628372drats
draws95119372draws
drays95819772drays
dreads84115022dreads
dryads11436622dryads
duads76515342duads
dyads10549972dyads
egads74610922egads
eras45441502era_s
fads86939872_fads
farads104713272farads
fards96629842fards
frags96322172frags
fraps105620552fraps
frass85321122frass
frats86829672frats
frauds1036752frauds
frays116920102frays
gabs76740422g_abs
gad57556652g_ad_
gadi66329722g_adi
gadis74825292g_adis
gaes56348032g_aes
gags66441062g_ags
gals57946502g_als
gams76648882g_ams
gaps76042972g_aps
garbs86321412garbs
garda7316762garda
gars55750742g_ars
gas48870252g_a_s
gats56753442g_ats
gauds75717722gauds
gays87338022g_ays
gears64628692gears
geds66730812g_eds
gelds75118342gelds
gerahs1039412gerahs
ghats95818612ghats
gids65933742g_ids
gilds75417522gilds
girds74816992girds
glad65624012glad_
glade75121962glade
glades84820342glades
glady105413942glady
glams85822932glams
glands85314402glands
glans65125832glans
glass65518132glass
gleds75417892gleds
gnars66718852gnars
gnats65217712gnats
gnaws96311142gnaws
goad66830982goad_
goals65521292goals
goas55239942goa_s
goats65527302goats
gods65438042g_ods
golds75421312golds
gonads84511732gonads
goods75124482goods
gorals76917652gorals
gowds105814042gowds
graal64316502graal
graals74112912graals
grab75427612gra_b
grace85124542grace
graces94523492graces
graded94919552graded
grader84919692grader
graders94716012graders
gradin83517482gradin
gradins93416232gradins
graft95327202graft
grafts105013252grafts
grail64622872grail
grails77518782grails
grain65126252grain
grains74223092grains
gram77034582gra_m
grama85620282grama
gramas94317202gramas
gramp106218322gramp
gramps114114272gramps
gran56335012gra_n
grana65722092grana
grand75122692grand
grant64840022grant
grants73722472grants
grape84824662grape
grapes95123122grapes
graph115315612graph
graphs124510152graphs
grapy115416432grapy
grasp84814482grasp
grasps9489252grasps
grassy10619092grassy
grat55651282gra_t
grate64932882grate
grates75429892grates
gratis74819242gratis
grave94624872grave
graves104624002graves
gravy125512112gravy
gray85329892gra_y
graze155820052graze
grazes164519642grazes
greats76318392greats
greeds84314282greeds
grees65132472grees
greys96614852greys
grid65829612grid_
gride75223582gride
grides84422362grides
grigs75318192grigs
grinds84511842grinds
grins65427222grins
grips85520132grips
grits65529582grits
groans74815062groans
groats74816652groats
grody103412062grody
grogs76319412grogs
groks105716122groks
gross65421692gross
grots65025852grots
grows95523922grows
grubs86312602grubs
grues65721962grues
guans64419442guans
guards84611572guards
guars65021052guars
guids75516152guids
hards96435652hards
heads95127112heads
irade65618152irade
irades74517392irades
irids66417772irids
lads56549132_lads
lards65331862lards
leads66028492leads
loads65323372loads
mads76845372_mads
meads85425322meads
nards65928462nards
orad56031692orad_
orals55826482orals
oreads73915772oreads
pads76742952_pads
pards85634332pards
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
prods85523552prods
quads154515842quads
rad47662002_rad_
rags55448372_rags
raids65827512_raids
rais45252622_rais
rams65950772_rams
rands65930452_rands
raps66247732_raps
ras37575392_ra_s
rats46260372_rats
raws75238212_raws
rays77642352_rays
reads64835272reads
reds56042862_reds
rids56539552_rids
roads66523622roads
rods56442062_rods
sards64736182sards
scads85419962scads
shads95124482shads
tads57143942_tads
toads65621072toads
trad55630912trad_
trade65026042trade
trades75724502trades
trams75327672trams
trans54933042trans
traps75727482traps
trass56226472trass
trays85623432trays
treads74817922treads
triads74513532triads
urds55922432ur_ds
wads87343142_wads
wards97734402wards
woads94818442woads
wraps105617152wraps
yards95324612yards

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538002471.57634137.1
3Display Results2472470.0633920.6
 (SQL Overall)1786912471.95291542.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.