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

212 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
scads8541996(None) 
cads76144521_cads
scabs94818641scabs
scad75725771scad_
scags85520971scags
scalds94813691scalds
scams94423971scams
scans74625101scans
scars75433531scars
scats75930601scats
scuds85116241scuds
shads95124481shads
acids87121002acids
ads49755732__ads
bads77048862_bads
beads85429502beads
brads85528292brads
cabs86739422_cabs
cad67456362_cad_
cade76443912_cade
cades85440732_cades
cadi75732182_cadi
cadis84428502_cadis
caids85226422_caids
cams87047282_cams
cans65050852_cans
caps87147892_caps
cards85137932_cards
cars67364762_cars
cats66356342_cats
caws96036112_caws
cays95437672_cays
chads116122232chads
clads85722732clads
cods76848102_cods
cuds76730472_cuds
cycads14476212cycads
dads67442772_dads
deads75726912deads
duads76515342duads
dyads10549972dyads
egads74610922egads
escars83913132escars
fads86939872_fads
gads67843382_gads
glads75620612glads
goads77022852goads
grads75625752grads
heads95127112heads
lads56549132_lads
leads66028492leads
loads65323372loads
mads76845372_mads
meads85425322meads
nicads938332nicads
ocas66729632oca_s
octads987332octads
pads76742952_pads
quads154515842quads
rads56046602_rads
reads64835272reads
roads66523622roads
sabs66643742s_abs
sacks114228872sacks
sacs65739072s_acs
sad47459202s_ad_
sade55544472s_ade
sades65239892s_ades
sadi55834642s_adi
sadis64930852s_adis
sags55948402s_ags
saids65328852saids
salads75316962salads
sals46851672s_als
sands65228582sands
sans45153362s_ans
saps65346372s_aps
sards64736182sards
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scab85926712sca_b
scag76626892sca_g
scald84818122scald
scale74629142scale
scales84529312scales
scall74420372scall
scalls84218202scalls
scalp95217982scalp
scalps104315232scalps
scaly104718722scaly
scam85932352sca_m
scamp115717312scamp
scamps125014172scamps
scan65530452sca_n
scant79735072scant
scants85219722scants
scape96921842scape
scapes105122262scapes
scar66434202sca_r
scare75334462scare
scares85033002scares
scarf105427142scarf
scarfs114714682scarfs
scarp95724102scarp
scarps104718602scarps
scart76139772scart
scarts85321492scarts
scary105222592scary
scat65848372sca_t
scatt76030092scatt
scatts85914662scatts
scaup95515992scaup
scaups105411932scaups
scaur75814902scaur
scaurs85512052scaurs
scends95213002scends
schavs1436492schavs
scolds95011232scolds
scops95820192scops
scots74025912scots
scows106617802scows
scrags95713802scrags
scrams105216622scrams
scraps106017242scraps
scrods94111612scrods
scud76221282scud_
scudi85112162scudi
scudo85412212scudo
scums95017422scums
scups95316652scups
scuts74522522scuts
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
seeds64330062seeds
sends65528242sends
shad86230912shad_
shade95125582shade
shades105924532shades
shady125416512shady
shags95123862shags
shahs115919512shahs
shams105829412shams
shards104319172shards
shaws116226262shaws
shays116021432shays
sheds96122702sheds
sials54227242sials
silds65520522silds
skags104316072skags
skalds11437832skalds
skas85325712ska_s
skats94621542skats
skids104615332skids
slabs75322642slabs
slags66525902slags
slams74927902slams
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
sleds64418852sleds
snags64421312snags
snaps74719562snaps
snaws86116362snaws
sneds65715352sneds
soaks95220292soaks
soaps75120712soaps
soars54732512soars
socas74026182soca_s
sodas64123542sodas
sods54940212s_ods
sords64527802sords
spade84423322spade
spades94222582spades
spado83713702spado
spaes76029972spaes
spams94922192spams
spans74528732spans
spars75431542spars
spas67036722spa_s
spats75031382spats
spays105520512spays
spuds85113672spuds
squads164410292squads
stabs76221382stabs
stade64825302stade
stades74626242stades
stags66226742stags
stands75118052stands
stars55836572stars
stats55933362stats
stays86022022stays
steads74116222steads
studs64415872studs
sudds75513592sudds
suds56135292s_uds
surds65624662surds
swabs105817272swabs
swags94921252swags
swans84625012swans
swaps104819202swaps
swards105415132swards
swats85726862swats
sways115518462sways
tads57143942_tads
toads65621072toads
wads87343142_wads
woads94818442woads

Search took 3 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 Limit538002121.64332745.0
3Display Results2122120.0434930.2
 (SQL Overall)1786912121.99989390.2
 
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.