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

252 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
scenery123656(None) 
celery1139622_celery
scene77220572scene__
scenes84520352scene_s
senary93716072s_enary
sentry92912052s_entry
sneery93610412sne_ery
venery123710662_venery
agentry11165753agentry
ascender1136733ascender_
ascenders1235693ascenders
beanery1237563beanery
beery105220123_be_ery
brewery15376963brewery
canary11314693_canary
caner75334773_caner_
caners84629203_caners
cannery123610013cannery
cedary12419603_cedary
ceder85322243_ceder_
ceders93817673_ceders
censer84516583_censer_
censers94313903_censers
center84421413_center_
centers94420603_centers
centra84113883_centra
centre84316643_centre
century1237193_century
cheery144913153_cheery
cindery13429193_cindery
coney105932883_cone_y
deanery1137613deanery
decenary1446273decenary
denary105316863_denary
eery76129623__e_ery
emery104814333__emery
enemy1059993__enemy
energy10137513__energy
entry82414263__entry
evener91010623evener_
eveners10109503eveners
every115215453__every
fernery1335813fernery
finery124512893_finery
genera71211713_genera
gentry103410443_gentry
greenery12265923greenery
gunnery11376373gunnery
hennery1335303hennery
henry114014473_hen_ry
iceberg1242293iceberg
joinery17366593joinery
keener104012843keener_
keeners113610783keeners
lechery15257643lechery
leery85919133_le_ery
lientery1134883lientery
nunnery10355303nunnery
obscenely1651913obscenely
obscener1244323obscener_
ochery14319443oc_hery
onery8414123__onery
opener83910993opener_
openers9339493openers
ornery938463_ornery
peery105719443_pe_ery
penury1148103_penury
pinery115214293_pinery
plenary1237543plenary
reentry1038033reentry
revery124014213_revery
sanely93114613s_anely
saner54334323s_aner_
sawney12387603sawne_y
scaler84321613scaler_
scalers93817263scalers
scanner94411813scanner_
scanners10379703scanners
scanter94215183scanter_
scantly12419553scantly
scanty114014663scan_ty
scarer84524613scarer_
scarers94618513scarers
scarey115016983scare_y
scarry116311183sc_arry
scary105222593sc__ary
scena74815783scen__a
scenario1044823scenario
scenas84114703scen_as
scend85516293scen__d
scended11329873scended
scends95213003scen_ds
sceneries1149403sceneries
scenic10510513scen_ic
scenics1137773scenics
scent75831623scen__t
scented102811893scented
scents85317023scen_ts
scepter1138373scepter_
scepters1237803scepters
sceptre1135053sceptre
schemer1477963schemer_
schemers1576713schemers
sclera838893sc_lera
scone74621833scone__
scones84521303scone_s
scorer84818263scorer_
scorers94115323scorers
scorner9259763scorner_
scorners10228493scorners
scoter83815483scoter_
scoters93313813scoters
screener1037573screener_
screeners1136743screeners
screwer124410073screwer_
screwers13358063screwers
screwy14659463sc_rewy
scry96017763sc___ry
scullery13296333scullery
scunner9358243scunner_
scunners10357303scunners
scurry11419593sc_urry
sealery104011053sealery
seceder10329573seceder_
seceders11277963seceders
secern81010223s_ecern
secrecy1444743secrecy
sectary1238273sectary
seder64826763s_eder_
seders74420283s_eders
seeder74320773seeder_
seeders83017113seeders
seedy94821533s_e_edy
seeker103615363seeker_
seekers113712333seekers
seely84522633s_e_ely
seemer84418043seemer_
seemers93814333seemers
seepy104717973s_e_epy
seer45547043s_e_er_
seers55136383s_e_ers
seiner64622483seiner_
seiners74219273seiners
sender73824413s_ender_
senders83022353s_enders
sene46848053s_ene__
seneca839793s_eneca
senega738173s_enega
senor53822803s_enor_
senora63216163s_enora
senors63620793s_enors
senryu934493s_en_ryu
sensory10329093s_ensory
serenely1147623serenely
serener73415763serener_
serer55935513s_erer_
serry84824123s_e_rry
sever85426053s_ever_
severe94016083s_evere
severs94121123s_evers
sewer84426223s_ewer_
sewers94719723s_ewers
sheeney13398933sheeney
sheeny124912193she_eny
sheer84726893she_er_
sheerly13337703she_erly
sheers94322403she_ers
sherry124510413she_rry
shewer124515113shewer_
shewers134312053shewers
shiner93820873shiner_
shiners104015943shiners
shinnery14305683shinnery
shivery16317023shivery
showery16437243showery
sickener1436603sickener_
sickeners1535733sickeners
sievert10613293sievert
signer74015633signer_
signers84714443signers
signory11427523signory
silvery13328093silvery
sinewy12667513s_inewy
sinner64320603sinner_
sinners74019023sinners
skene96118123skene__
skenes104616633skene_s
skerry13356103ske_rry
skewer13519613skewer_
skewers14498383skewers
slavery13407893slavery
sleeky13398963sle_eky
sleepy11479413sle_epy
sleety94112653sle_ety
slender83413603slender_
slenderly1343453slenderly
smeary114110803sme_ary
smeltery13274963smeltery
sneer54919953sne_er_
sneers64016173sne_ers
sneezy18345273sne_ezy
soever94412093soever_
sooner64220463sooner_
sooners73916643sooners
sorcery1237033sorcery
sorner64720393sorner_
sorners73416873sorners
speedy1218410793spe_edy
speer74623903spe_er_
speers85019953spe_ers
spencer113610973spencer_
spencers12269193spencers
spender103713693spender_
spenders113211743spenders
spendy124911143spen_dy
spewer115112153spewer_
spewers124210663spewers
sphery14318883s_phery
spicery14499013spicery
spidery13308203spidery
spinnery13416593spinnery
steely93612573ste_ely
steer55423863ste_er_
steers63820983ste_ers
stemmery15334693stemmery
stenchy15256213stenchy
stenoky1444253stenoky
sterner7411913sterner_
stoner65823203stoner_
stoners74817963stoners
stoney96217353stone_y
subentry1344693subentry
summery14329413summery
sundry1057943s_undry
surgery11319213surgery
swannery1433553swannery
sweeney13387003sweeney
sweeny12358843swe_eny
sweepy14447453swe_epy
sweer84918573swe_er_
sweltry1333413sweltry
synergy1442943s_ynergy
tannery10388663tannery
teener64717503teener_
teeners74415453teeners
turnery10357423turnery
veery115816253_ve_ery
vicenary1654973vicenary
vinery124912603_vinery
wiener94513543wiener_
wieners103212483wieners
winery125014283_winery

Search took 10 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 Filter1786911340271.110160982.9
2DLD Change Limit1340272528.34316064.6
3Display Results2522520.0932709.7
 (SQL Overall)1786912529.54618718.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.