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

284 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
shamble1414926(None) 
shamable15168801shamable
shambled16156151shambled
shambles15159041shambles
amble95924642__amble
bramble133710032bramble
gamble115417182_gamble
humble133615052_humble
ramble104519972_ramble
sable74732162s_a_ble
sample104215012s_ample
scabble13168652scabble
scramble14177252scramble
scumble1337012scumble
shackle16409542shackle
shakable17177682shakable
shale85332832sha__le
shamably18165802shamably
shame105726702sham__e
shameable1645572shameable
shapable15197802shapable
sharable131910692sharable
shavable16177272shavable
stable83921642sta_ble
stumble1147552stumble
suable83920552sua_ble
thimble1435872thimble
wamble134415752_wamble
able66340533__a_ble
ambled115116373__ambled
ambler104916453__ambler
ambles105121863__ambles
amole75724593__amole
ample94720303__ample
arable81821003ara_ble
assemble1254823assemble
babble94017113_babble
bauble103813213_bauble
blamable1436693blamable
brabble10349973brabble
brambled15316733brambled
brambles14308973brambles
brambly16296253brambly
bumble124216893_bumble
cable95329913_ca_ble
cashable15159793casha_ble
chamade15138453chamade
chamber164011063chamber
chamise143612853chamise
chasuble1543063chasuble
chimbley2063133chimbley
chimbly1974593chimbly
crambe1239073cramb_e
crumble133410403crumble
dabble114515193_dabble
doable93115243doa_ble
drabble12238883drabble
drumble12337893drumble
dyable12308983dya_ble
enable83318483ena_ble
example1844283example
fable105824753_fa_ble
fimble133611753_fimble
fishable1637593fisha_ble
flambe13489153flamb_e
flambee144210013flambee
foamable1537043foamable
framable1537573framable
fumble133214263_fumble
gabble113815723_gabble
gable85325523_ga_ble
gambe106219213_gamb_e
gambled134112163_gambled
gambler123612683_gambler
gambles124016203_gambles
garble94118453_garble
grabble12339643grabble
grumble12349233grumble
habile11515213_habile
hackle154916813_hackle
haggle113511983_haggle
hale76052833_ha__le
hamal104623113_hamal_
hamals114816823_hamals
hamate113319833_hamate
hambone1439313_hambone
hame97043133_ham__e
hamlet113722793_ham_let
hamuli1137063_hamuli
handle104219293_handle
hantle94318203_hantle
haole84820083_ha_ole
hassle93711593_hassle
hatable121713963_hatable
hobble133913433_hobble
hombre13309303_hombre
humbled153711813_humbled
humbler143411943_humbler
humbles143215803_humbles
humbly164010523_humbly
jambe165314753_jamb_e
jumble174012653_jumble
lambie103213673_lambie
liable81415813lia_ble
marble104219103_marble
mumble123614343_mumble
namable11312343_namable
nimble103412943_nimble
preamble1436383preamble
rabble103818243_rabble
rambla103510933_rambla
rambled123913523_rambled
rambler113313263_rambler
rambles113118313_rambles
rumble103718813_rumble
sabe66140573s_a_b_e
sables85026693s_a_bles
sabre74821503s_a_bre
saddle83915493s_addle
salable91415463salable
sale44959703s_a__le
samba95618773s_amb_a
sambaed1238303s_ambaed
sambal105215183s_ambal
sambals115213483s_ambals
sambar103914163s_ambar
sambas104219263s_ambas
sambo95118013s_amb_o
sambos104315193s_ambos
sambuke1544203s_ambuke
sambur10469503s_ambur
same65245643s_am__e
samiel8313333s_amiel
samite83020603s_amite
samlet84126563s_am_let
sampled123410793s_ampled
sampler113212013s_ampler
samples112815453s_amples
savable121711863savable
sayable121411613sayable
scabbled15156303scabbled
scabbles14167983scabbles
scalable121710233scalable
scale74629143sca__le
scrabble14196993scrabble
scrambled16164813scrambled
scrambler15165043scrambler
scrambles15146383scrambles
scumbled1535053scumbled
scumbles1447023scumbles
sealable101512693sealable
seeable91113943seeable
semple103212753s_emple
sewable121911173sewable
shabbier1535183shabbier
shabbily1873903shabbily
shabby1635803sha_bby
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
shadblow1742313shadblow
shade95125583sha__de
shadfly1733783shadfly
shadily1437723shadily
shake124726403sha__ke
shakeable1844943shakeable
shakily1736903shakily
shaled105023953sha__led
shales94731253sha__les
shaley123714993sha__ley
shall85024053sha__ll
shalt85534493sha__lt
shaly114322863sha__ly
sham96436363sham___
shaman113314283sham_an
shamans123610903shamans
shamas113717943sham_as
shambling1735593shambling
shambolic1843113shambolic
shameably1943873shameably
shamed125120213sham_ed
shameless1435923shameless
shames114726223sham_es
shaming133016743shaming
shamisen1344273shamisen
shammas14358723shammas
shammed153911423shammed
shammer144613143shammer
shammes144312833shammes
shammied16265543shammied
shammies15259683shammies
shammos14307203shammos
shammy16388503sham_my
shamois123210423shamois
shamos114216983sham_os
shamoy14379913sham_oy
shamoyed1744043shamoyed
shamoys15367283shamoys
shampoo1435373shampoo
shams105829413sham__s
shamus114112813sham_us
shamuses1336153shamuses
shape105125113sha__pe
shapeable1645743shapeable
shapely1536893shapely
share86437083sha__re
shareable1436733shareable
sharpie1238393sharpie
sharply15406833sharply
shaul85418103sha_ul_
shauled1148793sha_uled
shauls94913113sha_uls
shave114425893sha__ve
shavie124312423sha_vie
shawl116217573sha_wl_
shawled1437773sha_wled
shawls125411973sha_wls
shedable1437423shedable
shingle117711283shingle
showable1636583showable
shuffle16276923shuffle
shuttle1046103shuttle
siamese936503siamese
simile83115633s_imile
simple104315173s_imple
sizable1839893sizable
sjambok2242303sjambok
skatole1135693skatole
skiable1338883skiable
slakable14177553slakable
slayable13157563slayable
smile74823923s__mile
snaffle13216253snaffle
soluble966103soluble
sombre10729473s_ombre
sowable121610753sowable
spackle15369573spackle
spale74929213spa__le
spambot1345913spambot
spangle1038403spangle
sparable121611983sparable
sparkle133710213sparkle
spatzle1834583spatzle
squabble2143883squabble
stabile9312063stabile
stabled103514953sta_bled
stabler94014933sta_bler
stables93219073sta_bles
stably113314123sta_bly
staddle9288093staddle
stale55637103sta__le
stammel11607533stammel
staple84415823sta_ple
startle72511123startle
statable10310703statable
stubble1136843stubble
stumbled1335623stumbled
stumbler1235813stumbler
stumbles1237493stumbles
suably112814533sua_bly
summable1436903summable
swabbie1484333swabbie
swaddle12276743swaddle
swale85221593swa__le
swayable16135533swayable
table75429603_ta_ble
tamable11312853_tamable
tamale83717403_tamale
thimbles1536023thimbles
trample11299703trample
tremble1138003tremble
tumble103215643_tumble
unable83819223una_ble
usable84012553usa_ble
useable9911063usea_ble
viable111613773via_ble
wabble133714843_wabble
wambled153610753_wambled
wambles143714023_wambles
wambly16388663_wambly
warble113516603_warble
washable16138043washa_ble
whale115517433wha__le
wimble133211923_wimble

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.1561145455.1
2DLD Change Limit1340272847.40618097.1
3Display Results2842840.310916.1
 (SQL Overall)1786912847.87222699.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.