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

260 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
scabble1316865(None) 
scabbled15156301scabbled
scabbles14167981scabbles
scrabble14196991scrabble
babble94017112_babble
brabble10349972brabble
cabbie122913352_cabbie
cable95329912_ca_ble
cobble123615262_cobble
dabble114515192_dabble
drabble12238882drabble
gabble113815722_gabble
grabble12339642grabble
rabble103818242_rabble
sable74732162s_a_ble
scabbed14408222scabbed
scabbier1435132scabbier
scabbily1763942scabbily
scabby1535502scabb_y
scalable121710232scalable
scale74629142sca__le
scrabbled16154972scrabbled
scrabbler15195202scrabbler
scrabbles15206282scrabbles
scrabbly17164622scrabbly
scramble14177252scramble
scribble14175432scribble
scumble1337012scumble
shamble14149262shamble
squabble2143882squabble
stabile9312062stabile
stable83921642sta_ble
stubble1136842stubble
suable83920552sua_ble
swabbie1484332swabbie
wabble133714842_wabble
abbe87627193__abb_e
abele76323253__abele
able66340533__a_ble
abubble1044523abubble
actable11313473actable
amble95924643__amble
arable81821003ara_ble
babbled113612863_babbled
babbler104012823_babbler
babbles104416323_babbles
bauble103813213_bauble
bedabble1243703bedabble
bobble94115143_bobble
brabbled12337633brabbled
brabbler11397373brabbler
brabbles11349753brabbles
bramble133710033bramble
bubble94016593_bubble
cabal95222153_cabal_
cabala103516913_cabala
cabals104020153_cabals
cabbage1446983_cabbage
cabbala1367183_cabbala
cabbed135416263_cabbed
cabbies133115163_cabbies
cabby145314563_cabb_y
cabled114819873_ca_bled
cabler104519173_ca_bler
cables104527553_ca_bles
cablet104429463_ca_blet
cackle143416923_cackle
cajole154011183_cajole
candle94321483_candle
cantle84522153_cantle
capable13313363_capable
carle74535703_ca_rle
cascable141510623casca_ble
castle84918963_castle
cattle85118903_cattle
caudle93912913_caudle
cobbled143411633_cobbled
cobbler133311823_cobbler
cobbles133814823_cobbles
coble94823173_c_oble
dabbled133712073_dabbled
dabbler124012153_dabbler
dabbles124514773_dabbles
dibble114013843_dibble
doable93115243doa_ble
drabbled14367053drabbled
drabbles13308523drabbles
dribble12368603dribble
dyable12308983dya_ble
enable83318483ena_ble
escapable1544983escapable
escarole1045743escarole
fable105824753_fa_ble
fribble14287783fribble
gabbled134112453_gabbled
gabbler124013303_gabbler
gabbles124415413_gabbles
gable85325523_ga_ble
gamble115417183_gamble
garble94118453_garble
gobble113512983_gobble
grabbled14327373grabbled
grabbler13377693grabbler
grabbles13339893grabbles
gribble12297273gribble
habile11515213_habile
hobble133913433_hobble
kibble143910953_kibble
labile8315223_labile
liable81415813lia_ble
marble104219103_marble
nibble103713283_nibble
nobble103814313_nobble
nubble103813713_nubble
pebble1238003_pebble
quibble2034713quibble
rabbled123514423_rabbled
rabbler113514093_rabbler
rabbles113517973_rabbles
ramble104519973_ramble
rubble104315673_rubble
sabal75422483s_abal_
sabals84618863s_abals
sabbat10314713s_abbat
sabbed114518083s_abbed
sabe66140573s_a_b_e
sabine84020393s_abine
sables85026693s_a_bles
sabre74821503s_a_bre
saccule1136743saccule
saddle83915493s_addle
salable91415463salable
sale44959703s_a__le
sample104215013s_ample
savable121711863savable
sayable121411613sayable
scab85926713sca_b__
scabbard1544203scabbard
scabbiest1534913scabbiest
scabbing15277193scabbing
scabbling1634863scabbling
scabies11613333scabies
scablike1635553scablike
scabs94818643sca_b_s
scalably15166703scalably
scalade10359263scalade
scalage103110533scalage
scalare93311833scalare
scald84818123sca__ld
scaled94822443sca__led
scalene9310773scalene
scaler84321603sca__ler
scales84529313sca__les
scall74420373sca__ll
scalls84218203sca_lls
scalp95217983sca__lp
scalpel11377713scalpel
scaly104718723sca__ly
scannable1345643scannable
scantly12419553scantly
scape96921843sca__pe
scapose1147753scapose
scapula1136343scapula
scapulae1255433scapulae
scarce104013633sca_rce
scare75334463sca__re
scarily12311703scarily
scarlet91516943sca_rlet
scathe114414993sca_the
scrabblers16213813scrabblers
scrabblier1642773scrabblier
scrambled16164813scrambled
scrambler15165043scrambler
scrambles15146383scrambles
scrapple1434683scrapple
scribbled16174033scribbled
scribbler15164223scribbler
scribbles15184953scribbles
scribbly17143623scribbly
scribe104613533scrib_e
scruple1137193scruple
scuffle15266893scuffle
scumbled1535053scumbled
scumbles1447023scumbles
scuttle936463scuttle
sealable101512693sealable
seeable91113943seeable
sewable121911173sewable
shabbier1535183shabbier
shabbily1873903shabbily
shabby1635803shabb_y
shackle16409543shackle
shakable17177683shakable
shale85332833sha__le
shamable15168803shamable
shambled16156153shambled
shambles15159043shambles
shapable15197803shapable
sharable131910693sharable
shavable16177273shavable
sizable1839893sizable
skatole1135693skatole
skiable1338883skiable
slabbed12409503slabbed
slabber113311393slabber
slakable14177553slakable
slayable13157563slayable
snaffle13216253snaffle
sociable1239503sociable
soluble966103soluble
sorbable1239303sorbable
sowable121610753sowable
spackle15369573spackle
spale74929213spa__le
spangle1038403spangle
sparable121611983sparable
sparkle133710213sparkle
spatzle1834583spatzle
squabbled2342563squabbled
squabbler2242733squabbler
squabbles2243633squabbles
stabbed123510373stabbed
stabber113610153stabber
stabiles10311403stabiles
stabled103514953sta_bled
stabler94014933sta_bler
stables93219073sta_bles
stably113314123sta_bly
staddle9288093staddle
stale55637103sta__le
staple84415823sta_ple
startle72511123startle
statable10310703statable
stubbled1385073stubbled
stubbles1236843stubbles
stubbly1444473stubbly
stumble1147553stumble
suably112814533sua_bly
subtle82113433s_ubtle
swabbed15367403swabbed
swabber14297963swabber
swabbies15115713swabbies
swabby1634353swabb_y
swaddle12276743swaddle
swale85221593swa__le
swayable16135533swayable
table75429603_ta_ble
unable83819223una_ble
usable84012553usa_ble
useable9911063usea_ble
viable111613773via_ble
vocable14189673voca_ble
wabbled153311443_wabbled
wabbler143511923_wabbler
wabbles144013993_wabbles
wabbly16348363_wabbly
wamble134415753_wamble
warble113516603_warble
wobble133212313_wobble
yabbie13308663_yabbie

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272607.18618651.1
3Display Results2602600.0962708.3
 (SQL Overall)1786912607.68823242.8
 
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.