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

237 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
scabbles1416798(None) 
scabble13168651scabble_
scabbled15156301scabbled
scrabbles15206281scrabbles
babbles104416322_babbles
brabbles11349752brabbles
cabbies133115162_cabbies
cables104527552_ca_bles
cobbles133814822_cobbles
dabbles124514772_dabbles
drabbles13308522drabbles
gabbles124415412_gabbles
grabbles13339892grabbles
rabbles113517972_rabbles
sables85026692s_a_bles
scabbed14408222scabb_ed
scabbier1435132scabbier
scabbiest1534912scabbiest
scabies11613332sca_bies
scales84529312sca__les
scrabble14196992scrabble_
scrabbled16154972scrabbled
scrabbler15195202scrabbler
scrabblers16213812scrabblers
scrambles15146382scrambles
scribbles15184952scribbles
scumbles1447022scumbles
shambles15159042shambles
squabbles2243632squabbles
stabiles10311402stabiles
stables93219072sta_bles
stubbles1236842stubbles
swabbies15115712swabbies
wabbles144013992_wabbles
abbes96723523__abb_es
abeles84719393__abeles
ables75935543__a_bles
ambles105121863__ambles
arables91814973ara_bles
babble94017113_babble_
babbled113612863_babbled
babbler104012823_babbler
babblers113510353_babblers
baubles113611863_baubles
bedabbles1343043bedabbles
bobbles104514913_bobbles
brabble10349973brabble_
brabbled12337633brabbled
brabbler11397373brabbler
brabblers12335563brabblers
brambles14308973brambles
bubbles104315963_bubbles
cabalas113516003_cabalas
cabals104020153_cabal_s
cabbages1537203_cabbages
cabbalas1467373_cabbalas
cabbed135416263_cabb_ed
cabbie122913353_cabbie_
cable95329913_ca_ble_
cabled114819873_ca_bled
cabler104519173_ca_bler
cablers114416713_ca_blers
cablet104429463_ca_blet
cablets114216343_ca_blets
cackles153717203_cackles
cajoles163712103_cajoles
candles104422343_candles
cantles94721413_cantles
carles85435083_ca_rles
cascables15165773casca_bles
castles94917733_castles
caudles103912813_caudles
caules85927253_ca_ules
cobble123615263_cobble_
cobbled143411633_cobbled
cobbler133311823_cobbler
cobblers14359593_cobblers
cobles104622883_c_obles
cubbies133312883_cubbies
dabble114515193_dabble_
dabbled133712073_dabbled
dabbler124012153_dabbler
dabblers13379363_dabblers
dibbles124013333_dibbles
drabble12238883drabble_
drabbled14367053drabbled
dribbles13348393dribbles
enables92813123ena_bles
escaroles1145273escaroles
fables114921673_fa_bles
fribbles15287713fribbles
gabble113815723_gabble_
gabbled134112453_gabbled
gabbler124013303_gabbler
gabblers134110083_gabblers
gables94222333_ga_bles
gambles124016203_gambles
garbles104016923_garbles
gobbles123512583_gobbles
grabble12339643grabble_
grabbled14327373grabbled
grabbler13377693grabbler
grabblers14345513grabblers
gribbles13307363gribbles
hobbles143313783_hobbles
kibbles153510253_kibbles
marbles114516653_marbles
nibbles114011693_nibbles
nobbles114014523_nobbles
nubbles113412433_nubbles
pebbles1337573_pebbles
quibbles2134223quibbles
rabbies113416053_rabbies
rabble103818243_rabble_
rabbled123514423_rabbled
rabbler113514093_rabbler
rabblers123810853_rabblers
rambles113118313_rambles
rubbles113715113_rubbles
sabals84618863s_abal_s
sabbats1138633s_abbats
sabbed114518083s_abb_ed
sabes76437463s_a_b_es
sabines94318483s_abines
sable74732163s_a_ble_
sabres85520863s_a_bres
saccules1237033saccules
saddles95415743s_addles
sales56055593s_a__les
samples112815453s_amples
scabbard1544203scabbard
scabbards1643763scabbards
scabbily1763943scabbily
scabbing15277193scabbing
scabbling1634863scabbling
scabby1535503scabb__y
scabious1246593scabious
scabrous1245993scabrous
scabs94818643sca_b__s
scalable121710233scalable_
scalades11258803scalades
scalages113010253scalages
scalares103210983scalares
scalds94813693sca__lds
scale74629143sca__le_
scaled94822443sca__led
scaleless1135513scaleless
scaler84321603sca__ler
scalers93817263sca__lers
scalls84218203sca__lls
scalpels12345883scalpels
scalps104315233sca__lps
scampies1439323scampies
scanties103215423scanties
scapes105122263sca__pes
scapulas1246133scapulas
scares85033003sca__res
scarless10189053sca_rless
scarlet91516943sca_rlet
scarlets10178573sca_rlets
scarves124511623sca_rves
scathes124515713sca_thes
scrabblier1642773scrabblier
scrabbliest1742483scrabbliest
scrabbly17164623scrabbl_y
scramble14177253scramble_
scrambled16164813scrambled
scrambler15165043scrambler
scramblers16183543scramblers
scrapples1534793scrapples
scribble14175433scribble_
scribbled16174033scribbled
scribbler15164223scribbler
scribblers16183103scribblers
scribes113713203scrib_es
scruples1237433scruples
scuffles16287863scuffles
scumble1337013scumble_
scumbled1535053scumbled
scuttles1056503scuttles
shabbier1535183shabbier
shabbiest1635323shabbiest
shackles173010593shackles
shales94731253sha__les
shamble14149263shamble_
shambled16156153shambled
skatoles1236143skatoles
slabbed12409503slabb_ed
slabber113311393slabb_er
slabbers123610123slabbers
snaffles14246043snaffles
sociables1344963sociables
solubles1065893solubles
spackles16319953spackles
spales84728103spa__les
spangles1138893spangles
sparables13167163sparables
sparkles143210493sparkles
spatzles1935303spatzles
squabble2143883squabble_
squabbled2342563squabbled
squabbler2242733squabbler
squabblers2341843squabblers
stabbed123510373stabb_ed
stabber113610153stabb_er
stabbers12268733stabbers
stabile9312063stabile_
stable83921643sta_ble_
stabled103514953sta_bled
stabler94014933sta_bler
stablers103611153sta_blers
stablest103312943sta_blest
staddles10258693staddles
stales65538293sta__les
staples93617213sta_ples
startles82111963startles
stubble1136843stubble_
stubbled1385073stubbled
stumbles1237493stumbles
suable83920553sua_ble_
swabbed15367403swabb_ed
swabber14297963swabb_er
swabbers15316743swabbers
swabbie1484333swabbie_
swaddles13296453swaddles
swales93920763swa__les
tabbies112913503_tabbies
tables84524893_ta_bles
vocables15145733voca_bles
wabble133714843_wabble_
wabbled153311443_wabbled
wabbler143511923_wabbler
wabblers15398993_wabblers
wambles143714023_wambles
warbles123215563_warbles
wobbles143412433_wobbles
yabbies14279643_yabbies

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 Limit1461622377.03320782.3
3Display Results2372370.0932548.4
 (SQL Overall)1786912377.29624491.6
 
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.