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

318 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
ramblas11271026(None) 
rambla103510931rambla_
rambles113118311rambles
ambles105121852_ambles
brambles14308972brambles
gambas115817512gamb_as
gambias125010722gambias
gambles124016202gambles
kamalas13339122kamalas
lambdas1246242lambdas
mambas125716242mamb_as
rabbles113517972rabbles
radulas839582radulas
ramadas1039302ramadas
ramble104519972rambl_e
rambled123913512rambled
rambler113313262rambler
ramblers124010372ramblers
ramonas9311092ramonas
ranulas7311772ranulas
rumbas102512012rumb_as
rumbles114018392rumbles
sambals115213482sambals
sambas104219262samb_as
tablas83716162ta_blas
tambalas1237032tambalas
wambles143714022wambles
abas68642083_a_b_as
abbas95918643_a_bbas
ables75935543_a_bles
akelas10311193_akelas
alas46358123_a__las
albas75925393_alb_as
amas67746293_am__as
ambers104519563_ambers
ambits103713393_ambits
amble95924633_ambl_e
ambled115116353_ambled
ambler104916443_ambler
amblers115213563_amblers
ambos95321243_amb_os
amebas10311453_amebas
amias75831463_am_ias
amigas95912163_amigas
amoles84122193_amoles
amylase1237013_amylase
amyls104512683_amyl_s
anlas55626933_a_nlas
arables91814973arables
areolas71013863areolas
argalas84011083argalas
armadas1038173armadas
armillas1046663armillas
atlas55821583_a_tlas
babas96325733ba_b_as
babbles104416323babbles
babkas146010143ba_bkas
balas76937213ba__las
balboas113710073balboas
bamboos1348753bamboos
baubles113611863baubles
brabbles11349753brabbles
bramble133710033brambl_e
brambled15316723brambled
brambly16296253brambl_y
bumbles134016843bumbles
cabalas113516003cabalas
cabals104020153ca_bals
cabbalas1467373cabbalas
cables104527553ca_bles
callas84526753ca_llas
camas96333523cam__as
cambers134017433cambers
cambia124913143cambia_
cambial134010753cambial
camelias12510293camelias
camels105217083camel_s
cameras11313343cameras
camisas113411923camisas
canolas9313993canolas
canulas9312853canulas
carambolas1643363carambolas
crambes1339953cramb_es
cramboes1436543cramboes
crambos1336783cramb_os
crapolas1247403crapolas
crumbles14329683crumbles
cumbias13338953cumbias
cymbals16236143cymbals
dabbles124514773dabbles
doblas93812293_doblas
drabbles13308523drabbles
dramas95814653dram__as
drumbles13277723drumbles
fables114921673fa_bles
falbalas1345473falbalas
famulus1235043famulus
favelas1337023favelas
fimbles143510653fimbles
fumbles143514413fumbles
gabbles124415413gabbles
gables94222333ga_bles
galas65731643ga__las
gamas85431353gam__as
gamba106018513gamb_a_
gambes116318313gamb_es
gambia115912233gambia_
gambirs12359073gambirs
gambits12399713gambits
gamble115417183gambl_e
gambled134112163gambled
gambler123612683gambler
gamblers13369733gamblers
gambols1238593gambols
gambs105721123gamb__s
gamelan10106643gamelan
gamelans11115843gamelans
gammas115714693gam_mas
garbles104016923garbles
gimbals12257813gimbals
grabbles13339893grabbles
gramas94317203gram__as
grammas12499773gram_mas
grampas12399253gram_pas
granolas938053granolas
grumbles13288873grumbles
halalas104214083halalas
hamadas1339663hamadas
hamals114816813hamal_s
hammals14409213hammals
hamular1236973hamular
hamulus1235323hamulus
hamzas20119013ham_zas
hawalas13348353hawalas
humbles143215803humbles
iambics13425623iambics
iambs95815053iamb__s
iambus10468893iamb_us
jambeau1843773jambeau
jambes175914053jamb_es
jambs166014623jamb__s
jumbals18106533jumbals
jumbles183013323jumbles
kabalas133911063kabalas
kabbalas1674353kabbalas
kamala12339963kamala_
kiblas1239323_kiblas
lamas75532793lam__as
lambadas1354873lambadas
lambast11129893lamb_ast
lambda1146113lambda_
lambers113817103lambers
lambies113015103lambies
lambs95921413lamb__s
lamellas1098153lamellas
lamias85020613lam_ias
laminas93615873laminas
lampas106615953lam_pas
limbas105313193limb_as
maculas113114013maculas
mamas95930773mam__as
mamba116317513mamb_a_
mamboes135011823mamboes
mambos125414493mamb_os
mammals10389273mammals
mammas94616403mam_mas
manilas93915873manilas
marbles114516653marbles
masalas9312053masalas
molas75132093__molas
mumbles133014433mumbles
nalas55528363na__las
nombles113212343nombles
numbles113814273numbles
paellas9411413paellas
pampas124913993pam_pas
payolas12148973payolas
preambles1545323preambles
primulas1246123primulas
qabalas18289503qabalas
rabat72832223ra_b_at
rabats83116223ra_bats
rabbets11279423rabbets
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613153ra_bbis
rabbits11299863rabbits
rabble103818243rabbl_e
rabbled123514423rabbled
rabbler113514093rabbler
rabblers123810853rabblers
rabies85226013ra_bies
raddles93615703raddles
radials83614633radials
radula749313radula_
radulae837963radulae
radular837833radular
raffias13237713raffias
raffles133611843raffles
ragas65326063ra__gas
ragbag1045463ragb_ag
ragbags1135113ragbags
raggles93813283raggles
raglan73711503ra_glan
raglans82410133ra_glans
raias54631123ra__ias
railbus934413railbus
rails55937403ra_il_s
raitas64417673ra_itas
rajas127317723ra__jas
rales54947493ra__les
ramada9310183ramada_
ramal74622243ram__al
rambling131810773rambling
rambutan1243403rambutan
rambutans1343103rambutans
ramees84620893ram_ees
ramets83517393ram_ets
ramies84630463ram_ies
ramilie9310283ramilie
ramilies10311833ramilies
ramjets1635163ramjets
rammers113715043rammers
ramona8412413ramona_
ramous8417103ram_ous
rampoles1238893rampoles
ramps96224633ram__ps
ramrods1036583ramrods
rams65950773ram___s
ramsons939563ramsons
ramtillas1174193ramtillas
ramtils938413ramtils
ramulose1044313ramulose
ramulous1045883ramulous
ramus76418283ram__us
rankles113114543rankles
ranula6311813ranula_
ranular739433ranular
raphias123511083raphias
rasboras1045893rasboras
rascals959663rascals
rassles73513923rassles
ratables10159723ratables
ratals64219583ratal_s
ratbag956563ratb_ag
ratbags1035763ratbags
ratels64518213ratel_s
rattles73217303rattles
ravels94717073ravel_s
rayas85922053ra__yas
remelts93511493remelts
remolds10299703remolds
remoras9314073remoras
remudas1035833remudas
rhumbas14305163rhumb_as
rimples113114223rimples
robles85321693r_obles
roubles93413503roubles
rubbles113715113rubbles
rubles83921703r_ubles
rugolas836373rugolas
rumba93612513rumb_a_
rumble103718813rumbl_e
rumbled124514593rumbled
rumbler113514113rumbler
rumblers123610743rumblers
rumbly134412163rumbl_y
rumples113313133rumples
sabals84618863sa_bals
sables85026693sa_bles
sabras85116363sa_bras
samaras9312913samaras
samba95618773samb_a_
sambal105215183samb_al
sambar103914163samb_ar
sambars115113843sambars
sambhar1444853sambhar
sambhars1544833sambhars
sambos104315193samb_os
sambucas1444163sambucas
samburs11369343samburs
samosas939293samosas
samples112815453samples
scrambles15146383scrambles
shambles15159043shambles
tabla73318363ta_bla_
tables84524883ta_bles
talas55935893ta__las
tamales93216143tamales
tamals84116623tamal_s
tambac122210243tamb_ac
tambacs13219363tambacs
tambak14249263tamb_ak
tambaks15218153tambaks
tambala1138023tambala
tamburas12316043tamburas
tamburs11288603tamburs
tampalas1245473tampalas
timbals11239523timbals
tombolas1245993tombolas
tramells10327833tramells
tramels93812493tramel_s
tramples122610203tramples
trembles1237353trembles
tumbles113816023tumbles
tymbals14265723tymbals
umbles103817483_umbles
umbras1038633_umbras
wabbles144013993wabbles
wallas95719393wa_llas
wamble134415753wambl_e
wambled153610753wambled
wambly16388663wambl_y
warbles123215563warbles
wimbles143010843wimbles
yamalkas1743103yamalkas
yamulkas1741793yamulkas
zamias174212923zam_ias

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273187.95616846.0
3Display Results3183180.1232585.4
 (SQL Overall)1786913188.23221706.9
 
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.