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

103 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
scrambles1514638(None) 
scrabbles15206281scrabbles
scramble14177251scramble_
scrambled16164811scrambled
scrambler15165041scrambler
scramblers16183541scramblers
brambles14308972_brambles
crambes1339962_cramb_es
cramboes1436542_cramboes
crumbles14329682_crumbles
rambles113118312__rambles
scabbles14167982sc_abbles
scrabble14196992scrabble_
scrabbled16154972scrabbled
scrabbler15195202scrabbler
scrabblers16213812scrabblers
scrapples1534792scrapples
scribbles15184952scribbles
scumbles1447022sc_umbles
shambles15159042s_hambles
unscrambles1761702unscrambles
ambles105121863___ambles
arables91814973_ara_bles
brabbles11349753_brabbles
bramble133710033_bramble_
brambled15316733_brambled
cables104527553_c_a_bles
crackles164111273_crackles
cradles103114133_cra_dles
crambe1239073_cramb_e_
crambos1336783_cramb_os
crankles143510153_crankles
crimples14308963_crimples
crumble133410403_crumble_
crumbled15357443_crumbled
crumples14348813_crumples
drabbles13308523_drabbles
drumbles13277723_drumbles
durables11237013dura_bles
gambles124016203__gambles
grabbles13339893_grabbles
grumbles13288873_grumbles
parables121613563para_bles
preambles1545333preambles
rabbles113517973__rabbles
ramblas112710263__ramblas
ramble104519973__ramble_
rambled123913523__rambled
rambler113313263__rambler
ramblers124010373__ramblers
rumbles114018393__rumbles
sables85026693s__a_bles
samples112815453s__amples
scabble13168653sc_abble_
scabbled15156303sc_abbled
scabies11613333sc_a_bies
scales84529313sc_a__les
scampies1439323sc_ampies
scrabblier1642773scrabblier
scrabbliest1742483scrabbliest
scrabbly17164623scrabbl_y
scrambling1743473scrambling
scramjet1945033scram_jet
scramjets2052063scramjets
scrammed1555003scram_med
scrams105216623scram___s
scrannels1143513scrannels
scrapes116217663scra__pes
scrapies124612473scra_pies
scrapple1434683scrapple_
scratches1647323scratches
scrawled1445923scra_wled
scrawler1345893scra_wler
scrawlers1434753scra_wlers
scrawls12177283scra_wl_s
scribble14175433scribble_
scribbled16174033scribbled
scribbler15164223scribbler
scribblers16183103scribblers
scribes113713203scr_ib_es
scruples1237433scr_uples
scumble1337013sc_umble_
scumbled1535053sc_umbled
shamble14149263s_hamble_
shambled16156153s_hambled
sociables1344963socia_bles
sparables13167163sparables
spraddles13194283spraddles
sprattles1174883sprattles
squabbles2243633squabbles
stables93219073s_ta_bles
storables1146283stora_bles
straddles11216403straddles
straggles11328503straggles
strangles103011553strangles
stumbles1237493s_tumbles
tramples122610203_tramples
trembles1237353_trembles
unscramble1652983unscramble_
unscrambled1861713unscrambled
unscrambler1761453unscrambler
unscramblers1891003unscramblers
wambles143714023__wambles

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411037.07621006.4
3Display Results1031030.0303433.3
 (SQL Overall)1786911037.54623680.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.