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

137 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
scrabble1419699(None) 
scabble13168651sc_abble
scrabbled16154971scrabbled
scrabbler15195201scrabbler
scrabbles15206281scrabbles
scrabbly17164621scrabbly
scramble14177251scramble
scribble14175431scribble
brabble10349972_brabble
drabble12238882_drabble
grabble12339642_grabble
rabble103818242__rabble
scabbled15156302sc_abbled
scabbles14167982sc_abbles
scrabblers16213812scrabblers
scrabblier1642772scrabblier
scrambled16164812scrambled
scrambler15165042scrambler
scrambles15146382scrambles
scrapple1434682scrapple
scribbled16174032scribbled
scribbler15164222scribbler
scribbles15184952scribbles
scribbly17143622scribbly
sorbable1239302sorbable
squabble2143882squabble
actable11313473acta_ble
arable81821003_ara_ble
ascribable1643483ascribable
babble94017113__babble
bedabble1243703bedabble
brabbled12337633_brabbled
brabbler11397373_brabbler
brabbles11349753_brabbles
bramble133710033_bramble
cabbie122913343_c_abbie
cable95329913_c_a_ble
cobble123615263_c_obble
crabbed14388873_crabbed
crabber133810733_crabber
crabbier14326803_crabbier
crabbily1744343_crabbily
crabby15346753_crabb_y
crackle153611253_crackle
cradle93313163_cra_dle
crambe1239073_cramb_e
crankle133610063_crankle
cribbled15305803_cribbled
crumble133410403_crumble
curable112414513cura_ble
curbable1447663curbable
dabble114515193__dabble
drabbled14367053_drabbled
drabbles13308523_drabbles
dribble12368603_dribble
durable102312723dura_ble
errable9312183erra_ble
fribble14287783_fribble
gabble113815723__gabble
grabbled14327373_grabbled
grabbler13377693_grabbler
grabbles13339893_grabbles
gribble12297273_gribble
hirable121612313hira_ble
parable111819773para_ble
rabbled123514423__rabbled
rabbler113514093__rabbler
rabbles113517973__rabbles
ramble104519973__ramble
rubble104315673__rubble
sable74732163s__a_ble
salable91415463sala_ble
savable121711863sava_ble
sayable121411613saya_ble
scabbed14408223sc_abbed
scabbier1435133sc_abbier
scabbily1763943sc_abbily
scabby1535503sc_abb_y
scalable121710233scalable
scale74629143sc_a__le
scrabbliest1742483scrabbliest
scrabbling1742853scrabbling
scraggly15294143scraggly
scramblers16183543scramblers
scrannel1044033scrannel
scrape105917573scra__pe
scrapie115010943scra_pie
scrapples1534793scrapples
scrawl11208083scra_wl_
scrawled1445903scra_wled
scrawler1345883scra_wler
scrawls12177273scra_wls
scrawly15197183scra_wly
screwable1644833screwable
scribal1137963scribal_
scribblers16183103scribblers
scribe104613523scr_ib_e
scrubbable1562113scrubbable
scrubbed1533853scrubbed
scrubber1434113scrubber
scrubbier1543333scrubbier
scrubbily1842313scrubbily
scrubby1642803scrubb_y
scruple1137193scr_uple
scrutable1346043scrutable
scumble1337013sc_umble
securable1347773secura_ble
seeable91113943seea_ble
servable13310083servable
sewable121911173sewa_ble
shamble14149263s_hamble
sharable131910693sharable
sizable1839893siza_ble
skiable1338883skia_ble
sociable1239503socia_ble
sortable10312483sortable
sowable121610753sowa_ble
sparable121611973sparable
spraddle12194163spraddle
sprattle1054763sprattle
squabbled2342563squabbled
squabbler2242733squabbler
squabbles2243633squabbles
stabile9312063s_tabile
stable83921643s_ta_ble
storable10310733stora_ble
straddle10186223straddle
straggle10359133straggle
strangle98411503strangle
strobile1047033strobile
stubble1136843s_tubble
suable83920553s_ua_ble
surfable1338443surfable
swabbie1484333s_wabbie
unscramble1652983unscramble
wabble133714843__wabble
wirable121610963wira_ble

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621376.86021306.4
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.09325192.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.