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

476 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
sambars11511384(None) 
sambals115213481sambals
sambar103914161sambar_
sambas104219261samba_s
sambhars1544831sambhars
samburs11369341samburs
ambari103012172_ambari
ambaris113112162_ambaris
ambary134010542_ambary
ambers104519582_ambers
cambers134017442cambers
damars93814992dam_ars
dammars12308192dammars
darbars10510092darbars
embars103812882_embars
gambas115817512gamba_s
gambirs12359082gambirs
kabars124513952ka_bars
lambers113817112lambers
lumbars11289762lumbars
mambas125716242mamba_s
mimbars1397382mimbars
sabals84618862sa_bals
sabbats1138632sabbats
sabers85224732sa_bers
sabirs85414632sa_birs
sabras85116362sa_bras
saggars93610682saggars
samara8313852sam_ara
samaras9312912sam_aras
samba95618772samba__
sambaed1238302sambaed
sambal105215182samba_l
sambhar1444852sambhar_
sambhurs1543182sambhurs
sambos104315192samb_os
sambur10469502sambur_
samovars1343702samovars
sampans112411002sampans
samsara936912samsara
samsaras1045872samsaras
sandbars11108782sandbars
sangars83116252sangars
sansars73313912sansars
sardars83112902sardars
sarsars73512142sarsars
shmears1277072shmears
simars84916932sim_ars
smears84714432s_mears
tambacs13219362tambacs
tambaks15218152tambaks
tamburs11288612tamburs
abas68642083_a_ba_s
abbas95918643_abba_s
afars85716513_a_fars
agars66120643_a_gars
albas75925393_alba_s
altars64518153_altars
amahs107819063_am_ahs
amas67746293_am_a_s
amass77119683_am_ass
ambage11510603_ambage
ambages1269623_ambages
ambaries123312383_ambaries
ambeers11428923_ambeers
amber94523213_amber_
ambery133811133_ambery
ambits103713413_ambits
amblers115213563_amblers
ambles105121863_ambles
ambos95321253_amb_os
ambry123512103_amb_ry
amebas10311453_ameba_s
ameers84015573_ameers
amias75831473_amia_s
amirs75924923_am_irs
amours83512663_amours
anears63717183_anears
arbors84717883_arbors
ashlars10297063ashlars
attars64515313_attars
babas96325733ba_ba_s
bamboos1348753bamboos
baobabs1044443baobabs
barbers114317503barbers
bars66564093___bars
bazaars18275883bazaars
bazars174613113ba_zars
bombard1437333bombard
bombards1536493bombards
bombers134512593bombers
busbars1138153busbars
cabals104020153ca_bals
cabers105023923ca_bers
caesars9410733caesars
calcars11312653calcars
camas96333523cam_a_s
camass104114183cam_ass
camber124418483camber_
cameras11313363cameras
campers134220293campers
carbarn1139453carbarn
carbarns1238563carbarns
casbahs1436463casbahs
caviars1238623caviars
chambers173410623chambers
clambers144211293clambers
combats13311683combats
combers134516623combers
cumbers134515413cumbers
cymars13599153cym_ars
cymbals16236143cymbals
dabbers123813213dabbers
damans94715983dam_ans
damar84117733dam_ar_
dammar11438903dammar_
dammers123214273dammers
damners104112113damners
dampers123915693dampers
darbar959953darbar_
daubers104610423daubers
debars94218043_debars
disbars10310323disbars
drawbars1483103drawbars
durbars1077973durbars
embar94011603_embar_
embark14458523_embark
embarks15337353_embarks
embays131408333_embays
embers104116183_embers
eyebars1245333eyebars
gabbard1336553gabbard
gabbards1445753gabbards
gabbart1248883gabbart
gabbarts1344063gabbarts
gabbers124612833gabbers
gamas85431363gam_a_s
gamays126310913gam_ays
gamba106018513gamba__
gambade1336383gambade
gambades1435863gambades
gambado1344973gambado
gambados1444153gambados
gambes116318313gamb_es
gambias125010733gambias
gambiers13337073gambiers
gambir11509773gambir_
gambits12399723gambits
gamblers13369733gamblers
gambles124016203gambles
gambols1238593gambols
gambs105721123gamb__s
gamers94420833gam_ers
gammas115714693gamma_s
gammers123214563gammers
gasbags1135473gasbags
gaydars1235803gaydars
gazars164811553ga_zars
gimbals12257823gimbals
grammars13345943grammars
haars85620473ha__ars
hamals114816823ham_als
hamburg1544123hamburg
hamburgs1643473hamburgs
hammals14409223hammals
hammams13386443hammams
hammers144216063hammers
hampers143616953hampers
hamzahs24134373hamzahs
hamzas20119013hamza_s
hangars114313493hangars
harbors12412413harbors
iambics13425643iambics
iambs95815063iamb__s
iambus10468903iamb_us
imbark14347863_imbark
imbarks15326613_imbarks
isobars936593isobars
jabbers183610583jabbers
jaguars1535233jaguars
jambes175914053jamb_es
jambs166014623jamb__s
jammers183710703jammers
jumbals18106533jumbals
kababs14409773ka_babs
kabar114815553ka_bar_
kanbans1337723kanbans
kantars11310033kantars
kasbahs1634363kasbahs
kbars114612603__kbars
kebars124112493_kebars
labara83712893la_bara
labors84016413la_bors
lahars94013163la_hars
lamas75532793lam_a_s
lambada1245643lambada
lambadas1354873lambadas
lambast11129893lambast
lambasts12145623lambasts
lambdas1246243lambdas
lamber104418493lamber_
lambert113617113lambert
lamberts12348793lamberts
lambies113015113lambies
lambs95921413lamb__s
lamias85020613lamia_s
lampads12477623lampads
lampas106615953lampa_s
lampers113817333lampers
lascars979013lascars
lazars153812393la_zars
limbas105313203limba_s
limbers113614743limbers
lumbar103610593lumbar_
lumbers113815913lumbers
maars74621633__maars
makars124612633ma_kars
malars85020683ma_lars
mamas95930773mam_a_s
mamba116317523mamba__
mamboes135011823mamboes
mambos125414493mamb_os
mammals10389273mammals
mammary1335993mammary
mammas94616403mamma_s
mammers104615693mammers
mamzers20409163mamzers
mars66261873__m_ars
members13258603members
mimbar1297493mimbar_
nabbers113710463nabbers
namers84517333nam_ers
navars92810573na_vars
numbats1137673numbats
numbers113711243numbers
ombers104214403_ombers
pampas124913993pampa_s
pampers133615933pampers
rabats83116223ra_bats
radars71314673ra_dars
ragbags1135113ragbags
ramblas112710263ramblas
ramblers124010373ramblers
rambles113118313rambles
rammers113715043rammers
rampart11311993rampart
ramparts1245583ramparts
ratbags1035763ratbags
rebars84019833_rebars
rumbas102512013rumba_s
sabal75422483sa_ba_l
sabbat10314713sabba_t
sabbath1445393sabbath
sabbaths1543973sabbaths
saber75330243sa_ber_
sabes76437463sa_b_es
sabins85521983sa_bins
sabir75917003sa_bir_
sables85026693sa_bles
sabots8314703sa_bots
sabra75317853sa_b_ra
sabre74821503sa_b_re
sabres85520863sa_bres
sabs66643743sa_b__s
sacbuts1166473sacbuts
sackers133820223sackers
sacrals93311793sacrals
safari91110223sa_fari
safaris101110663sa_faris
sagas66025883sa_ga_s
sagbuts1065223sagbuts
saggar84010853saggar_
saggard10358953saggard
saggards11397493saggards
saggers94017083saggers
saguaro845513saguaro
saguaros944973saguaros
sahuaro1044233sahuaro
sahuaros1154283sahuaros
saigas74114293saiga_s
sailers73822323sailers
sailors73213723sailors
sakers104125433sa_kers
salaams997703salaams
salads75316963sa_lads
salals65120083sa_lals
salary9515213sa_lary
salpas85116923salpa_s
salsas65316133salsa_s
salters73622253salters
salvers103916003salvers
salvors103910913salvors
sambaing1337113sambaing
sambhur1453083sambhur
sambo95118013samb__o
sambuca1344343sambuca
sambucas1444163sambucas
sambuke1544203sambuke
sambukes1644193sambukes
samechs14285353samechs
samekhs16303923samekhs
sameks12409323sam_eks
samiels939763samiels
samites93118713samites
samlets93813553samlets
samosas939293samosas
samovar1244243samovar_
sampan102511893sampa_n
samplers12299403samplers
samples112815453samples
samps96124673sam__ps
samshus12125353samshus
samurai945923samurai
samurais1046143samurais
sandals82715203sandals
sandbags1296373sandbags
sandbar10108193sandbar_
sandburs11105623sandburs
sanders84025943sanders
sangar73617683sangar_
sangas75222653sanga_s
sangers84421943sangers
sanjaks1834963sanjaks
sansar63613393sansar_
santirs7312963santirs
santurs7310763santurs
sapors84118813sa_pors
sapours93610623sapours
sappers113518903sappers
sarans64224433sa_rans
sardar73013173sardar_
sarsar63011843sarsar_
sartors7314973sartors
sashays1336333sashays
satara6315533sa_tara
sataras7315063sa_taras
satays94411683sa_tays
satraps95011643satraps
satyrs937963sa_tyrs
saucers93712133saucers
saugers83914053saugers
saunas63915433sauna_s
savers93825923sa_vers
saviors1058993saviors
savors95616103sa_vors
savours10389343savours
sawers94620163sa_wers
sawyers13317533sawyers
sayers94221593sa_yers
scabbard1544203scabbard
scabbards1643763scabbards
scalars93711903scalars
scammers14339773scammers
scampers143611033scampers
scars75433533s__cars
schmears1584103schmears
scubas103710223scuba_s
scumbags1543203scumbags
seabags1037483seabags
seamark1336723seam_ark
seamarks1445303seam_arks
seamers94719433seam_ers
sears54744913s__ears
secpars1138413secpars
seggars9377783seggars
seminars1079043seminars
sewars94018633s_ewars
shagbark1843113shagbark
shagbarks1942853shagbarks
shamans123610903sham_ans
shamas113717943sham_a_s
shambles15159043shambles
shammas14358723shamma_s
shammers153710843shammers
shears93820903s_hears
shibahs15275643shibahs
shikars1436183shikars
shmear1176933shmear_
shofars1335833shofars
sidebars1146643sidebars
simar74920813sim_ar_
simas75727553sim_a_s
simians959203simians
simitars1046483simitars
simmers113314613simmers
simpers113014123simpers
simulars1047073simulars
sirdars8228213sirdars
sitars65417593s_itars
sizars154812623s_izars
sjamboks2342233sjamboks
slabbers123610123slabbers
slammers123511223slammers
slumbers123110273slumbers
smarm95517603s_m_arm
smarms105712533s_m_arms
smart75834093s_m_art
smarts86218003s_m_arts
smear74416393s_mear_
smeary114110803s_meary
soapbark1643253soapbark
soapbarks1743013soapbarks
soars54732513s__oars
sobas74424253s_oba_s
sobbers114114263sobbers
sobers85218863s_obers
sofars94712783s_ofars
somans84619303som_ans
somas76030373som_a_s
somber103714003somber_
sombre10729473somb_re
sonars64818973s_onars
soucars938423soucars
sowars94318013s_owars
sowcars1236013sowcars
spambots1443313spambots
spammers14378693spammers
spars75431543s__pars
spears84019473s_pears
stabbers12268733stabbers
stammers123611523stammers
stampers124211603stampers
stars55836573s__tars
subahs114512383s_ubahs
subas74724073s_uba_s
subbass1138033subbass
subers85722643s_ubers
sugars7312423s_ugars
sumacs105512103sum_acs
summary14297353summary
summas104313163summa_s
summers113616503summers
swabbers15316743swabbers
swampers15317473swampers
swears94114073s_wears
symbols1435523symbols
tabard9313333ta_bard
tabards10310383ta_bards
tabers84621573ta_bers
tabors84517113ta_bors
talars66021683ta_lars
tamals84116633tam_als
tamari8313403tam_ari
tamaris9413593tam_aris
tambac122210243tamba_c
tambak14249263tamba_k
tambala1138023tambala
tambalas1237033tambalas
tambours1255873tambours
tambur10358713tambur_
tambura11326463tambura
tamburas12316053tamburas
tamers84224033tam_ers
tampans113310983tampans
tampers113516743tampers
tanbark1337373tanbark
tanbarks1445563tanbarks
tartars73313403tartars
taskbars1452993taskbars
tatars64619793ta_tars
timbals11239533timbals
timbers113111853timbers
tombacs13248443tombacs
tombaks15246863tombaks
tramcars1245233tramcars
tymbals14265723tymbals
umbers104215213_umbers
umbras1038643_umbras
unbars82113033_unbars
vampers143111623vampers
wambles143714023wambles
wombats1435893wombats
yabbers14389353yabbers
yammers143410323yammers
zaffars22325233zaffars
zamias174212923zamia_s

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.420425454.8
2DLD Change Limit1340274767.19018640.8
3Display Results4764760.2032344.8
 (SQL Overall)1786914767.81322871.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.