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

379 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
sambals11521348(None) 
sabals84618861sa_bals
sambal105215181sambal_
sambars115113841sambars
sambas104219261samba_s
cabals104020152ca_bals
cymbals16236142cymbals
gambas115817512gamba_s
gambols1238592gambols
gimbals12257822gimbals
hamals114816822ham_als
hammals14409222hammals
jumbals18106532jumbals
mambas125716242mamba_s
mammals10389272mammals
ramblas112710262ramblas
sabal75422482sa_bal_
sabbats1138632sabbats
sacrals93311792sacrals
salals65120082sa_lals
samba95618772samba__
sambaed1238302sambaed
sambar103914162samba_r
sambhars1544832sambhars
sambos104315192samb_os
samburs11369342samburs
samiels939762samiels
sampans112411002sampans
sandals82715202sandals
symbols1435522symbols
tamals84116632tam_als
tambacs13219362tambacs
tambaks15218152tambaks
tambala1138022tambala
tambalas1237032tambalas
timbals11239532timbals
tymbals14265722tymbals
aals49941143_a__als
abas68642083_a_ba_s
abbas95918643_abba_s
albas75925393_alba_s
amahs107819063_am_ahs
amas67746293_am_a_s
amass77119683_am_ass
ambage11510603_ambage
ambages1269623_ambages
ambari103012173_ambari
ambaris113112163_ambaris
ambary134010543_ambary
ambers104519583_ambers
ambits103713413_ambits
amble95924643_amb_le
ambles105121863_ambles
ambos95321253_amb_os
amebas10311453_ameba_s
amias75831473_amia_s
ampuls1098893_ampuls
amyls104512693_am_yls
annals66415923_annals
appals104812943_appals
argals75517713_argals
astrals75515243astrals
atabals938413atabals
baals76122703ba__als
babas96325733ba_ba_s
babels105216723ba_bels
babuls105413643ba_buls
bals66354043___bals
bamboos1348753bamboos
baobabs1044443baobabs
barbal104016663barbal_
barbels114514433barbels
bubals103513843_bubals
cabal95222153ca_bal_
cabala103516913ca_bala
cabalas113516003ca_balas
cabbala1367183cabbala
cabbalas1467373cabbalas
camails11311753camails
camas96333523cam_a_s
camass104114183cam_ass
cambers134017443cambers
cambial134010763cambial_
camels105217083cam_els
canals84421663ca_nals
cantals93919573cantals
carpals113414623carpals
casbahs1436463casbahs
casuals91410523casuals
causals91411183causals
cembali13156043cembali
cembalo13145533cembalo
cembalos14135163cembalos
combats13311683combats
cymbal15236913cymbal_
damans94715983dam_ans
damars93814993dam_ars
dammars12308193dammars
damsels10126703damsels
darbars10510093darbars
embalm1236653_embalm
embalms1335333_embalms
embars103812883_embars
embays131408333_embays
facials123310743facials
falbala1235873falbala
falbalas1345473falbalas
fallals103310193fallals
farfals13268503farfals
faucals12326563faucals
gamas85431363gam_a_s
gamays126310913gam_ays
gamba106018513gamba__
gambade1336383gambade
gambades1435863gambades
gambado1344973gambado
gambados1444153gambados
gambes116318313gamb_es
gambias125010733gambias
gambirs12359083gambirs
gambits12399723gambits
gamble115417183gamb_le
gambles124016203gambles
gambol1138223gambol_
gambrels1334213gambrels
gambs105721123gamb__s
gammas115714693gamma_s
gasbags1135473gasbags
gavials1136603gavials
gayals1039513ga_yals
gimbal11228813gimbal_
gimmals12225823gimmals
gumball1266833gumball
gumballs1345313gumballs
halals95018313ha_lals
hamal104623113ham_al_
hamauls12387813hamauls
hammal134512063hammal_
hammams13386443hammams
hamzahs24134373hamzahs
hamzas20119013hamza_s
hartals10313023hartals
herbals122710603herbals
hymnals1543523hymnals
iambics13425643iambics
iambs95815063iamb__s
iambus10468903iamb_us
imbalm1246323_imbalm
imbalms1334553_imbalms
jacals1539873ja_cals
jackals2036893jackals
jambes175914053jamb_es
jambs166014623jamb__s
jumbal1758463jumbal_
kababs14409773ka_babs
kabala124011553ka_bala
kabalas133911063ka_balas
kabars124513953ka_bars
kabbala1584613kabbala
kabbalas1674353kabbalas
kamala12339963kam_ala
kamalas13339123kam_alas
kanbans1337723kanbans
kasbahs1634363kasbahs
labels84515683la_bels
labials9299873labials
lamas75532793lam_a_s
lambada1245643lambada
lambadas1354873lambadas
lambast11129893lambast
lambasts12145623lambasts
lambdas1246243lambdas
lambers113817113lambers
lambies113015113lambies
lambs95921413lamb__s
lamias85020613lamia_s
laminals10339303laminals
lampads12477623lampads
lampas106615953lampa_s
limbas105313203limba_s
lumbars11289763lumbars
mamas95930773mam_a_s
mamba116317523mamba__
mamboes135011823mamboes
mambos125414493mamb_os
mammal95112753mammal_
mammas94616403mamma_s
manuals9311213manuals
meals75933373__meals
mimbars1397383mimbars
namable11312343namable
narwals1036983narwals
nasals63312463na_sals
numbats1137673numbats
oatmeals1043843oatmeals
pampas124913993pampa_s
parrals94414573parrals
pascals11610013pascals
pibals103813083_pibals
qabala17399193qa_bala
qabalas18289503qa_balas
rabats83116223ra_bats
radials83614633radials
ragbags1135113ragbags
ramal74622243ram_al_
rambla103510933ramb_la
ramble104519973ramb_le
rambles113118313rambles
ramtils938413ramtils
rascals959663rascals
ratals64219583ra_tals
ratbags1035763ratbags
rumbas102512013rumba_s
sabbat10314713sabba_t
sabbath1445393sabbath
sabbaths1543973sabbaths
sabers85224733sa_bers
sabes76437463sa_b_es
sabins85521983sa_bins
sabirs85414633sa_birs
sable74732163sa_b_le
sables85026693sa_bles
sabots8314703sa_bots
sabras85116363sa_bras
sabres85520863sa_bres
sabs66643743sa_b__s
sacbuts1166473sacbuts
sacral83414413sacral_
safrols1036863safrols
sagas66025883sa_ga_s
sagbuts1065223sagbuts
saggars93610683saggars
sahiwals1443643sahiwals
saigas74114293saiga_s
sails55738103sa__ils
salaams997703salaams
salable91415463salable
salably121610743salably
salads75316963sa_lads
salal55425703sa_lal_
salols64017873sa_lols
salpas85116923salpa_s
sals46851673s___als
salsas65316133salsa_s
samara8313853sam_ara
samaras9312913samaras
sambaing1337113sambaing
sambhar1444853sambhar
sambhur1453083sambhur
sambhurs1543183sambhurs
sambo95118013samb__o
sambuca1344343sambuca
sambucas1444163sambucas
sambuke1544203sambuke
sambukes1644193sambukes
sambur10469503samb_ur
samechs14285353samechs
samekhs16303923samekhs
sameks12409323sam_eks
samiel8313333samiel_
samites93118713samites
samlets93813553samlets
samosas939293samosas
samovars1343703samovars
sampan102511893sampa_n
sample104215013sam_ple
samples112815453samples
samps96124673sam__ps
samsara936913samsara
samsaras1045873samsaras
samshus12125353samshus
samurais1046143samurais
sandal73317283sandal_
sandbags1296373sandbags
sandbars11108783sandbars
sangars83116253sangars
sangas75222653sanga_s
sanjaks1834963sanjaks
sansars73313913sansars
santols73513323santols
sarans64224433sa_rans
sardars83112903sardars
sarsars73512143sarsars
sashays1336333sashays
satays94411683sa_tays
satraps95011643satraps
sauls55128123sa__uls
saunas63915433sauna_s
saurels749303saurels
savable121711863savable
sawbill1255293sawbill
sawbills1344763sawbills
sawmills1343693sawmills
sayable121411613sayable
scandals1136993scandals
scubas103710223scuba_s
scumbags1543203scumbags
seabags1037483seabags
seals54839693s__eals
semibald1344563semibald
sendals81912263sendals
sepals85217373s_epals
serials73919743serials
servals103410743servals
shamable15168803shamable
shamably18165803shamably
shamans123610903sham_ans
shamas113717943sham_a_s
shamble14149263shamb_le
shambles15159043shambles
shammas14358723shamma_s
sheals94420643s_heals
shibahs15275643shibahs
shmears1277073shmears
shoals94215793s_hoals
sials54227243s__ials
sibyls1135303s_ibyls
signals8359163signals
simars84916933sim_ars
simas75727553sim_a_s
simians959203simians
simnels976103simnels
sisals63013573s_isals
sjamboks2342233sjamboks
skoals10438243s_koals
small74016263s_m_all
smalls84514123s_malls
smalt74729333s_m_alt
smalts85214893s_m_alts
smears84714433s_mears
smells83914743s_mells
sobas74424253s_oba_s
socials999633socials
somans84619303som_ans
somas76030373som_a_s
spambots1443313spambots
spinals93911863spinals
spirals93212513spirals
spitals93011593spitals
squeals1636513squeals
stammels12495563stammels
steals64020063s_teals
subahs114512383s_ubahs
subas74724073s_uba_s
subbass1138033subbass
sumacs105512103sum_acs
summas104313163summa_s
symbol1336083symbol_
tablas83716163ta_blas
tamable11312853tamable
tamal73522623tam_al_
tamale83717403tam_ale
tamales93216153tam_ales
tambac122210243tamba_c
tambak14249263tamba_k
tamburs11288613tamburs
tampala1136613tampala
tampalas1245473tampalas
tampans113310983tampans
tarsals72512603tarsals
timbal102510753timbal_
timbale11248803timbale
timbales12227843timbales
tombacs13248443tombacs
tombaks15246863tombaks
tombal102311023tombal_
tribals9610753tribals
tymbal13236823tymbal_
umbels104510593_umbels
vandals113211663vandals
vassals1057953vassals
verbals121910743verbals
wadmaals1442413wadmaals
wadmals1335513wadmals
wamble134415753wamb_le
wambles143714023wambles
wambly16388663wamb_ly
wombats1435893wombats
zamias174212923zamia_s

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 Limit1340273798.50315762.3
3Display Results3793790.1402707.1
 (SQL Overall)1786913798.79620315.0
 
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.