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

244 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
backup164661(None) 
backups1736171backups
back125535762back__
backed155725722backed
backer144525522backer
backout15612952backout
backs135729622back_s
cockup1635712cockup
crackup1743562crackup
faceup1334892faceup
fuckup1733962fuckup
kickup1354132kickup
lockup1434762lockup
markup1436902markup
mockup1634072mockup
pickup1655632pickup
stackup1533742stackup
walkup1534192walkup
aback134816173aback__
abacus10349763abac_us
ackee115825363_ackee
ankus91410683_ankus
baaskap1542513baaskap
babka137812913babk_a
babkas146010143babkas
babu85829233ba_bu_
babul96317713ba_bul
babus95620333ba_bus
bacca111012183bac_ca
baccae12119703baccae
bach116131393bac__h
bached145519893bached
baches135426943baches
backbit17129103backbit
backdrop19114253backdrop
backers153821883backers
backfit18108213backfit
backflip2143093backflip
backhaul1945133backhaul
backhoe1847153backhoe
backing165523443backing
backlit15911903backlit
backlog1635773backlog
backouts1698643backouts
backrush1944103backrush
backsaw1836203backsaw
backset15314193backset
backslap1844993backslap
backspin1845423backspin
backstop1845563backstop
backwrap2144073backwrap
bacon95620593bac_on
bacons104917583bacons
bacula103112673bacula
baculum1345703baculum
bagful1237213bagful
bake105637513ba_k_e
baked126130773ba_ked
baker115629543ba_ker
bakes117035373ba_kes
balk105132223balk__
balked135219413balked
balker124519163balker
balks114926293balk_s
balky145418243balk_y
bank105835753bank__
banked135021443banked
banker124222733banker
bankit123617043bankit
bankrupt1643243bankrupt
banks115527903bank_s
bap76455843ba___p
barbut104617003barbut
barhop13319643barhop
barium10313513barium
bark106242153bark__
barked135027313barked
barkeep1536363barkeep
barker124822863barker
barks115735813bark_s
barky145721613bark_y
barque17239553barque
bask105131423bask__
basked135218603basked
basket125722913basket
basks115621763bask_s
basque17259083basque
battu75216613battu_
battue84311003battue
baud74928423ba__ud
bayou10512363bayou_
bayous11411153bayous
beaucoup1442193beaucoup
becap114315053bec_ap
beck126226573beck__
becked155417763becked
becket144619883becket
beckon14309383beckon
becks135522013beck_s
bicep115413543bic_ep
bicker144819173bicker
black134719073black__
blackcap2043073blackcap
blacked163613373blacked
blacken15439793blacken
blacker154513513blacker
blackgum1942513blackgum
blackly1835253blackly
blackout1647413blackout
blacks144914953black_s
blacktop1842973blacktop
blowup1335063blowup
bock126032513bock__
bocks134526573bock_s
bracken15409813bracken
bracket154117233bracket
breakup1543463breakup
buck125129903buck__
bucked155121063bucked
bucker145420463bucker
bucket144620733bucket
buckle144815193buckle
bucko134614023buck_o
buckos143710893buckos
buckra1436753buckra
bucks134824293buck_s
bunkum1435983bunkum
bupkus14385683bupkus
cackle143416923cackle
cactus104912233cactus
catchup1644793catchup
catsup1036433catsup
checkup2043323checkup
cockups1735223cockups
coup86729793__coup
crackups1843123crackups
cup76738243__c_up
dacker134920753dacker
fuckups1832923fuckups
hack135134543hack__
hackbut1845713hackbut
hacked164923513hacked
hackee154921833hackee
hacker154822693hacker
hackie154615623hackie
hackle154916813hackle
hackly18298733hackly
hacks144928713hack_s
haiku126113693haiku_
haikus13538293haikus
haku116923893ha_ku_
hakus125114113ha_kus
hangup1277293hangup
hiccup1554393hiccup
hookup1534423hookup
jack175224863jack__
jackal1937613jackal
jacked204817523jacked
jacker194417583jacker
jacket194720673jacket
jacks185219833jack_s
jacky215412343jack_y
jaup135316423ja__up
kickups1443503kickups
lack105837683lack__
lacked135324653lacked
lacker125325623lacker
lackey154813353lackey
lacks116129203lack_s
larrup835713larrup
layup1037723la_yup
linkup1245123linkup
lockups1534243lockups
lookup1233453lookup
mack125733653mack__
mackle143716433mackle
macks135127603mack_s
makeup1434863makeup
markups1534963markups
matchup1643513matchup
mockups1733343mockups
oakum1177313oa_kum
pack125535443pack__
packed154822603packed
packer144223403packer
packet144726503packet
packly17228333packly
packs135528933pack_s
pickups1754253pickups
rack106234883rack__
racked134526083racked
racker124824553racker
racket125229423racket
rackful1645873rackful
rackle123917293rackle
racks115028853rack_s
raku85423773ra_ku_
rakus94413673ra_kus
recoup10810373recoup
ruckus12407793ruckus
sacbut10811943sacbut
sack105337313sack__
sackbut1545943sackbut
sacked135525213sacked
sacker125124843sacker
sackful1645353sackful
sacks114228873sack_s
sacque17107113sacque
sacrum103910143sacrum
sannup836563sannup
scaup95515993_scaup
scup84822383_sc_up
stackups1643313stackups
stickup1533853stickup
tack106536293tack__
tacked134723943tacked
tacker124224503tacker
tacket124627493tacket
tackey154613083tackey
tackle123815733tackle
tacks115430133tack_s
tacky145617443tack_y
takeup1234583takeup
teacup1036253teac_up
vacua10510463vac_ua
vacuum1334833vacuum
wack135330913wack__
wacke145918623wack_e
wacker154920123wacker
wackes154717713wackes
wacko145514383wack_o
wackos155210993wackos
wacks146626283wack_s
wacky174714933wack_y
walkups1633013walkups
warmup1335343warmup
washup1435323washup
wickiup18172673wickiup
wickyup21171883wickyup
workup1534323workup
yack135425973yack__
yacked164516793yacked
yacks144419813yack_s
yaup96618483ya__up

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162445.06322262.7
3Display Results2442440.0763210.5
 (SQL Overall)1786912445.27933849.4
 
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.