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

258 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
shambles1515904(None) 
shamble14149261shamble_
shambled16156151shambled
ambles105121852__ambles
brambles14308972brambles
gambles124016202_gambles
humbles143215802_humbles
rambles113118312_rambles
sables85026692s_a_bles
samples112815452s_amples
scabbles14167982scabbles
scrambles15146382scrambles
scumbles1447022scumbles
shackles173010592shackles
shales94731252sha__les
shamable15168792shamable_
shameless1435922shameless
shames114726222sham__es
shammes144312832sham_mes
shammies15259672shammies
shamuses1336152shamuses
stables93219072sta_bles
stumbles1237492stumbles
thimbles1536012thimbles
wambles143714022_wambles
ables75935543__a_bles
amble95924633__amble_
ambled115116353__ambled
ambler104916443__ambler
amblers115213563__amblers
amoles84122193__amoles
arables91814973ara_bles
assembles1354303assembles
babbles104416323_babbles
baubles113611863_baubles
brabbles11349753brabbles
bramble133710033bramble_
brambled15316723brambled
bumbles134016843_bumbles
cables104527553_ca_bles
chablis14368553cha_blis
chamades16138633chamades
chamber164011053chamb_er
chambers173410613chambers
chamises153513313chamises
chammies172910153chammies
chasubles1642303chasubles
chimbley2063133chimbley
chimbleys2162233chimbleys
chimblies1845023chimblies
crambes1339953cramb_es
cramboes1436543cramboes
crumbles14329683crumbles
dabbles124514773_dabbles
drabbles13308523drabbles
drumbles13277723drumbles
enables92813123ena_bles
examples1944313examples
fables114921673_fa_bles
fimbles143510653_fimbles
flambes14419503flamb_es
fumbles143514413_fumbles
gabbles124415413_gabbles
gables94222333_ga_bles
gambes116318313_gamb_es
gamble115417183_gamble_
gambled134112163_gambled
gambler123612683_gambler
gamblers13369733_gamblers
garbles104016923_garbles
grabbles13339893grabbles
grumbles13288873grumbles
hackles162917063_hackles
haggles123312483_haggles
hales85449843_ha__les
hamals114816813_hamal_s
hamates122917673_hamates
hambones1539673_hambones
hames106138703_ham__es
hamlet113722793_ham_let
hamlets123211403_ham_lets
hamulus1235323_hamulus
handles114020653_handles
hantles104117513_hantles
haoles94919803_ha_oles
hassles103411693_hassles
hobbles143313783_hobbles
hombres14369873_hombres
humble133615053_humble_
humbled153711813_humbled
humbler143411943_humbler
humblers15379803_humblers
humblest15288283_humblest
jambes175914053_jamb_es
jumbles183013323_jumbles
lambies113015103_lambies
mamboes135011823_mamboes
marbles114516653_marbles
mumbles133014433_mumbles
nombles113212343_nombles
numbles113814273_numbles
preambles1545323preambles
rabbles113517973_rabbles
ramblas112710263_ramblas
ramble104519973_ramble_
rambled123913513_rambled
rambler113313263_rambler
ramblers124010373_ramblers
rumbles114018393_rumbles
sabes76437463s_a_b_es
sable74732163s_a_ble_
sabres85520863s_a_bres
saddles95415743s_addles
sales56055593s_a__les
sambaed1238303s_ambaed
sambals115213483s_ambals
sambars115113843s_ambars
sambas104219263s_amb_as
sambos104315193s_amb_os
sambukes1644193s_ambukes
samburs11369343s_amburs
samiels939763s_amiels
samites93118713s_amites
samlet84126563s_am_let
samlets93813553s_am_lets
sample104215013s_ample_
sampled123410783s_ampled
sampler113212013s_ampler
samplers12299403s_amplers
scabble13168653scabble_
scabbled15156303scabbled
scabies11613333sca_bies
scales84529313sca__les
scampies1439323scampies
scrabbles15206283scrabbles
scramble14177253scramble_
scrambled16164813scrambled
scrambler15165043scrambler
scramblers16183543scramblers
scumble1337013scumble_
scumbled1535053scumbled
seamless10238723seam_less
shabbier1535183shabbier
shabbiest1635323shabbiest
shackle16409543shackle_
shackled18277593shackled
shackler17317973shackler
shacklers18336033shacklers
shackoes17367853shackoes
shadblow1742313shadblow
shadblows1842473shadblows
shadeless1335733shadeless
shades105924533sha__des
shadflies1643823shadflies
shakable17177683shakable_
shakes135024593sha__kes
shakoes144510013sha_koes
shale85332833sha__le_
shaled105023953sha__led
shaley123714993sha__ley
shamably18165793shamabl_y
shamans123610893sham_ans
shamas113717933sham__as
shambling1735593shambling
shambolic1843113shambolic
shame105726703sham__e_
shameable1645573shameable_
shamed125120213sham__ed
shamisen1344273shamisen
shamisens1442603shamisens
shammas14358713sham_mas
shammed153911423sham_med
shammer144613143sham_mer
shammers153710833shammers
shammied16265543shammied
shammos14307203sham_mos
shamois123210403sham_ois
shamos114216983sham__os
shamoyed1744043shamoyed
shamoys15367283sham_oys
shampoos1544603shampoos
shams105829413sham___s
shamus114112813sham__us
shandies122714103shandies
shannies113411253shannies
shanties113116573shanties
shapable15197803shapable_
shapeless1435563shapeless
shapes115124943sha__pes
sharable131910693sharable_
shares95236413sha__res
sharpies13411223sharpies
shauled1148793sha_uled
shauls94913113sha_ul_s
shavable16177273shavable_
shaves125224933sha__ves
shavies134213203sha_vies
shawled1437773sha_wled
shawls125411973sha_wl_s
shimmies15287803shimmies
shingles123111103shingles
shmoes114612093sh_m_oes
shuffles17297773shuffles
shuttles1136543shuttles
siameses1036403siameses
similes92915233s_imiles
simples113014943s_imples
sjamboks2342233sjamboks
skatoles1236143skatoles
smiles84522293s__miles
snaffles14246033snaffles
solubles1065893solubles
spackles16319943spackles
spales84728103spa__les
spambots1443313spambots
spangles1138893spangles
sparables13167153sparables
sparkles143210483sparkles
spatzles1935303spatzles
squabbles2243633squabbles
stabiles10311403stabiles
stable83921643sta_ble_
stabled103514953sta_bled
stabler94014933sta_bler
stablers103611143sta_blers
stablest103312943sta_blest
staddles10258693staddles
stales65538293sta__les
stammels12495563stammels
stampless1334543stampless
staples93617213sta_ples
startles82111963startles
stubbles1236843stubbles
stumble1147553stumble_
stumbled1335623stumbled
stumbler1235813stumbler
stumblers1334373stumblers
suable83920553sua_ble_
swabbies15115713swabbies
swaddles13296453swaddles
swales93920763swa__les
swamies123712063swam_ies
tables84524883_ta_bles
tamales93216143_tamales
thimble1435863thimble_
thumbless1643423thumbless
tramples122610203tramples
trembles1237353trembles
tumbles113816023_tumbles
umbles103817483__umbles
wabbles144013993_wabbles
wamble134415753_wamble_
wambled153610753_wambled
warbles123215563_warbles
washables17144743washa_bles
whales124716943wha__les
whammies18265503whammies
wimbles143010843_wimbles

Search took 9 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 Limit1461622588.56317069.0
3Display Results2582580.0932774.2
 (SQL Overall)1786912588.82620246.0
 
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.