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

488 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
sataras731505(None) 
samaras9312911samaras
satara6315531satara_
daturas838762daturas
haftaras14136072haftaras
patacas11311002patacas
sabras85116362sa_bras
safaris101110662safaris
samara8313852samara_
samsaras1045872samsaras
santeras8311052santeras
satangs8479712satangs
satays94411682sata_ys
satires72617572satires
satoris7317232satoris
satrap86212552sat_rap
satraps95011642satraps
satyrs937962satyr_s
sitars65417592sitar_s
stares66038752s_tares
stars55836572s_tar_s
starts65423122s_tarts
sutras64818582sut_ras
tantaras8269532tantaras
tatars64619792tatar_s
tuataras844852tuataras
abacas104414723_abacas
abakas123911743_abakas
abayas114011703_abayas
acarus8312193_acarus
afars85716513_afar_s
agamas97413443_agamas
agars66120643_agar_s
agoras7613343_agoras
alarms85913053_alarms
altars64518153altar_s
anabas8314083_anabas
arras55626133_a_rras
asanas6514113_asanas
ascaris93613323ascaris
asramas938303asramas
astasias8410143astasias
asterias8317003asterias
asters65631603aster_s
asthmas12117363asthmas
astral66919283ast_ral
astrals75515243astrals
astray95615543ast_ray
atabal839743_atabal
atabals938413_atabals
ataman81013063_ataman
atamans9710433_atamans
ataps76414833_ata_ps
ataraxy1743983_ataraxy
ataxias14189343_ataxias
atlas55821583_at_las
atmas75721013_at_mas
attars64515313attar_s
auras55932553_a_uras
avatars1036443avatar_s
awards107113453_awards
baccaras1446913baccaras
balatas9311833balatas
bananas93312223bananas
bastards113310313bastards
bayards13379683bayards
bazaars18275883bazaars
bazars174613113bazar_s
cabalas113516003cabalas
cabanas112413033cabanas
cameras11313343cameras
canards10311203canards
cantalas104013523cantalas
cantatas103410083cantatas
casabas1139983casabas
casavas1237813casavas
cascaras1237693cascaras
catalase1039213catalase
catalos9414163catalos
catalpas1246733catalpas
cataract1249413cataract
cataracts1345583cataracts
catarrh1245003catarrh
catarrhs1344333catarrhs
catawbas1544093catawbas
catenas9313103catenas
cateran9313763cateran
caterans10313203caterans
caters85336493cater_s
charas114223593_charas
citharas13156703citharas
curaras93911943curaras
damars93814993damar_s
dastards10278083dastards
database1143533database
dataries9314033dataries
datary10310243datar_y
datchas1347423datchas
daters74827363dater_s
datura738023datura_
dotards937253dotards
eaters65535943eater_s
extras13310223ext_ras
fatwas1249053fat_was
gaters74728633gater_s
gators74115823gator_s
gazars164811553gazar_s
haars85620473ha_ar_s
haftara13136093haftara_
haftarah17124173haftarah
haftarahs18133273haftarahs
halalas104214083halalas
hamadas1339663hamadas
haphtaras1753443haphtaras
haters94930393hater_s
hawalas13348353hawalas
hazards2037463hazards
hetaeras1146723hetaeras
hetairas1145603hetairas
jacanas1638263jacanas
jagras1438463ja_gras
kabakas12367403kabakas
kabalas133911063kabalas
kabars124513953kabar_s
kabayas16316803kabayas
kamalas13339123kamalas
kanakas10327213kanakas
kantars11310033kantar_s
katas95922093kat__as
katsuras1243653katsuras
kinaras1159093kinaras
kitharas15165403kitharas
labara83712893labara_
lahars94013163lahar_s
lantanas838263lantanas
latakias1245583latakias
laterad8310833laterad
lateral7313563lateral
laterals8312743laterals
latinas74416463latinas
latrias71913213latrias
lauras63414333la_uras
lazars153812393lazar_s
maars74621633ma_ar_s
madras94316423ma_dras
makars124612633makar_s
malarias10313753malarias
malars85020683malar_s
mananas93414733mananas
mantras93815863mantras
maracas11313773maracas
maras75443283__maras
masalas9312053masalas
mascaras1237693mascaras
mastabas1246803mastabas
maters85032383mater_s
matrass939393matrass
matres84522233mat_res
mattrass1045853mattrass
matures9314303matures
matzas1749703mat_zas
mazards1937703mazards
naganas847983naganas
nairas6312773na_iras
natural739513natural
naturals847903naturals
natures7311963natures
navars92810573navar_s
oaters65029783oater_s
osetras737323oset_ras
ottars64112223ottar_s
ottavas1093483ottavas
pajamas18278153pajamas
pakoras1337473pakoras
palabras1267353palabras
palapas11311493palapas
panadas103312213panadas
panamas113112753panamas
papayas1437273papayas
paras76143043__paras
paruras9310533paruras
pataca10311193pataca_
patamar1147093patamar
patamars1246843patamars
paters84935823pater_s
patinas96318523patinas
petards104311153petards
picaras11311273picaras
pitayas1286263pitayas
qabalas18289503qabalas
radars71314663radar_s
ramadas1039303ramadas
ratafias1145323ratafias
ratals64219583rata_ls
ratans63819373rata_ns
ratatat7412263ratatat
ratatats846063ratatats
raters63936573rater_s
rattrap945263rattrap
rattraps1044813rattraps
retards85015003retards
ritards8439943ritards
sabals84618863saba_ls
sabers85224733saber_s
sabirs85414623sabir_s
sabra75317853sa_bra_
sabres85520863sa_bres
sacra74516993sa_cra_
sacral83414413sa_cral
sacrals93311793sacrals
safari91110223safar_i
sagaman10117553sagaman
saganash1243063saganash
sagas66025883s__agas
saggards11397493saggards
saggars93610683saggar_s
saguaros944963saguaros
sahuaros1154283sahuaros
saigas74114293sa_igas
sakers104125433saker_s
salaam8711013sala_am
salaams997703salaams
salads75316963sala_ds
salals65120083sala_ls
salamis9313513salamis
salariat8416303salariat
salariats947823salariats
salaries8319573salaries
salary9515213salar_y
salinas73116093salinas
salivas10309603salivas
salpas85116923sa_lpas
salsas65316133sa_lsas
salterns8388893salterns
salters73622253salter_s
saltires83112423saltires
salvias10279933salvias
sambars115113843sambar_s
sambas104219263sa_mbas
samosas939293samosas
samsara936913samsara_
samurai945923samurai
samurais1046133samurais
sandarac1145833sandarac
sandaracs1244703sandaracs
sangars83116253sangar_s
sangas75222653sa_ngas
sangrias938373sangrias
sansars73313913sansar_s
santera7311303santera_
santerias9311833santerias
santeros8311193santeros
santirs7312963santir_s
santurs7310763santur_s
sapors84118813sapor_s
sapotas939603sapotas
saran53730303s__aran
sarans64224433sara_ns
sarapes94617743sarapes
sardanas937813sardanas
sardars83112903sardar_s
sards64736183s__ards
saris54544953s__aris
sarks96632463s__arks
saros55238063s__aros
sarsars73512143sarsar_s
sartors7314953sartor_s
sassafras1251803sassafras
satang75711563sata_ng
satanic939933satanic
satanism1039673satanism
satanist8313363satanist
satay84718463sat__ay
sateens73710753sateens
sates54949323sat__es
satiates8314633satiates
satins64930483sat_ins
satire63218003satir_e
satiric939243satiric
satirise8310683satirise
satirist8313503satirist
satis55633673sat__is
satori6415833sator_i
satrapy12497933satrapy
satsumas1043573satsumas
saturant8410643saturant
saturants946383saturants
saturate8312813saturate
saturates9811593saturates
satyr848483satyr__
satyric1237493satyric
satyrid1137233satyrid
satyrids1245623satyrids
saunas63915433sa_unas
savages1139973savages
savannas1143733savannas
savants1038653savants
savarin10310003savarin
savarins1139893savarins
savates10312953savates
savers93825923saver_s
savors95616103savor_s
sawers94620163sawer_s
saxtubas1741913saxtubas
sayers94221593sayer_s
sayonaras1242473sayonaras
scalares103210983scalares
scalars93711903scalar_s
scarab10310063s_carab
scarabs1137293s_carabs
scares85033003s_cares
scarfs114714683s_carfs
scarps104718603s_carps
scars75433533s_car_s
scarts85321493s_carts
scleras948223scleras
seamarks1445303seamarks
sears54744913s_ear_s
seaters74028933seater_s
seawards1237203seawards
seawares1139333seawares
senoras72714953senoras
sewars94018623sewar_s
shamas113717933s_hamas
shards104319173s_hards
shares95236413s_hares
sharias102516003s_harias
sharks135019723s_harks
sharns95516983s_harns
sharps115516083s_harps
shears93820903shear_s
sierras737863sierras
sifakas1443333sifakas
simars84916933simar_s
sirras63814863s_irras
sitar54820543sitar__
sitarist8315283sitarist
sizars154812623sizar_s
skaters113512943skater_s
slaters73123723slater_s
smarms105712533s_marms
smarts86218003s_marts
smears84714433smear_s
snares65329033s_nares
snarfs95113423s_narfs
snarks104815733s_narks
snarls64016873s_narls
soars54732513s_oar_s
sofars94712783sofar_s
solfataras1351333solfataras
sonars64818973sonar_s
sonatas7510293sonatas
soras55041013s__oras
souaris7312323souaris
sowars94318003sowar_s
spares84834553s_pares
sparks124616363s_parks
spars75431543s_par_s
spatulas1045473spatulas
spears84019473spear_s
squares163714453squares
squarks20417183squarks
stabs76221383s_ta_bs
stacks124317263s_tacks
stades74626243s_tades
stadias8411113stadias
staffs12349753s_taffs
stages75629493s_tages
stags66226743s_ta_gs
staigs75414813s_taigs
stains64923653s_tains
stairs65416333s_tairs
stakes103927293s_takes
stalag7310023s_talag
stalags838643s_talags
stales65538293s_tales
stalks104614553s_talks
stalls64019923s_talls
stamps105614023s_tamps
stands75118053s_tands
stanes64933403s_tanes
stangs75018163s_tangs
stanks104917703s_tanks
stanzas1636363stanzas
stapes85028733s_tapes
staphs114411033s_taphs
star48037763s_tar__
starch113013203s_tarch
stare54440263s_tar_e
stared75429873s_tared
starer64027363s_tarer
starers74522313s_tarers
starets73515923s_tarets
stark95425623s_tar_k
starry94911673s_tarry
start55642313s_tar_t
startsy10536703s_tartsy
starve94613743s_tarve
starves104614553s_tarves
stases64225563s_tases
stasis63116873s_tasis
statal61613223s_tatal
staters73922323stater_s
states64337083s_tates
stators73915553stator_s
stats55933363s_ta_ts
statures83711113statures
status65515213s_tatus
staves94525193s_taves
stays86022023s_ta_ys
steres63929533s_teres
sterns64616753s_terns
stirks104914233s_tirks
stirps85011813s_tirps
stirs55921613s_tir_s
stoas55126023s_t_oas
stomas84816323s_tomas
storax1389783s_torax
stores65533643s_tores
storks106115933s_torks
storms85814603s_torms
strap77925263s_t_rap
straps87721783s_traps
strass67117223s_trass
stratas73013573stratas
straw813321293s_t_raw
straws98718673s_traws
stray88525573s_t_ray
strays96417933s_trays
stupas83910883s_tupas
sturts63915143s_turts
styrax1675243s_tyrax
subareas1038623subareas
sugars7312423sugar_s
sultanas8237153sultanas
suras55336323s__uras
surras65919533s_urras
sutra54217933sut_ra_
suttas63813793sut_tas
sutural7310223sutural
sutures7314223sutures
svaraj1634963s_varaj
swaraj1636023s_waraj
swards105415133s_wards
swarfs125612063s_warfs
swarms116112163s_warms
swears94114073swear_s
tabards10310383tabards
takas95520683__takas
talars66021683talar_s
talas55935893__talas
tamarao977583tamarao
tamaraos10105883tamaraos
tamarau9107053tamarau
tamaraus1096183tamaraus
tamaris9413573tamaris
tantara72410813tantara_
tantras73112093tantras
tapas74627713__tapas
taramas9612693taramas
tares57456563__tares
tarns56433953__tarns
taros55640823__taros
tarps76527113__tarps
tars46763953__tar_s
tartanas8258893tartanas
tartars73313403tartar_s
tarts57242023__tarts
tatamis939713tatamis
tatar56122063tatar__
taters64932193tater_s
tetras63017613tet_ras
tiaras6314533_tiaras
toras55540373__toras
tuatara745503tuatara_
tuateras836183tuateras
uakaris1146633uakaris
ultras6310183ult_ras
varas86028193__varas
vawards14457573vawards
watapes12228383watapes
wataps11248683wata_ps
waters95030623water_s
yantras10259003yantras
yatagan1144133yatagan
yatagans1244083yatagans
zamarras1943803zamarras
zananas16319563zananas

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 Limit1340274886.89319443.9
3Display Results4884880.1702870.6
 (SQL Overall)1786914887.21924752.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.