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

295 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
tamaris941357(None) 
tamari8313381tamari_
tamarin9311891tamarin
tamarins10310831tamarins
tamarisk1445461tamarisk
ambaris113112122_ambaris
damars93814992damar_s
safaris101110662safaris
samaras9312912samaras
tabards10310382tabards
talaria7412502talaria
talars66021682talar_s
tamales93216142tamales
tamals84116622tama_ls
tamarao977582tamarao
tamaraos10105882tamaraos
tamarau9107052tamarau
tamaraus1096182tamaraus
tamarind1147012tamarind
tamarinds1244162tamarinds
tamarisks1543632tamarisks
tamers84224032tamer_s
tamis76728722tam__is
tatamis939712tatamis
tatars64619792tatar_s
uakaris1146632uakaris
abatis84317933_abatis
abris75722603_a_bris
acari75020283_acari_
acarid95017063_acarid
acarids105312243_acarids
acarus8312193_acarus
afars85716513_afar_s
agaric93513623_agaric
agarics10319943_agarics
agars66120643_agar_s
alarms85913053_alarms
amahs107819063_ama_hs
amain74922893_ama_in
amarna839793_amarna
amas67746293_ama__s
amass77119683_ama_ss
amazes175613473_amazes
ambari103012163_ambari_
ambaries123312353_ambaries
ambries111614543_ambries
amirs75924923_amir_s
amis66445323_am__is
amorist9317643_amorist
arris56824683_a_rris
ascaris93613323ascaris
atamans9710433atama_ns
atmans84413963atma_ns
atmas75721013atma__s
attars64515313attar_s
auris55331523_a_uris
awards107113453_awards
basmatis1247343basmatis
bayards13379683bayards
bazars174613113bazar_s
calamaris1346063calamaris
camail10314823cama_il
camails11311743camails
camas96333523cama__s
camases114216343camases
camass104114183cama_ss
cambric1537363cambric
cambrics1645243cambrics
cameras11313343cameras
canards10311203canards
canaries10318943canaries
capris10415073ca_pris
cumarin1139263cumarin
cumarins1238643cumarins
curaris94114773curaris
cymars13599143cymar_s
dalasis8810533dalasis
damages11511273damages
damans94715983dama_ns
damar84117733damar__
damasks1435073damasks
dammars12308193dammar_s
dataries9314033dataries
daymares1445333daymares
demarks14339233demarks
earmarks1444793earmarks
fumaric1446303fumaric
gamas85431353gama__s
gamays126310903gama_ys
gambirs12359083gambirs
gamers94420823gamer_s
gazars164811553gazar_s
gramaries12128293gramaries
haars85620473ha_ar_s
hadarim13117423hadarim
hamadas1339663hamadas
hamals114816813hama_ls
hamartia13115933hamartia
hamartias14115353hamartias
hamates122917673hamates
hamauls12387803hamauls
havartis1444373havartis
hazards2037463hazards
hegaris11310423hegaris
kabars124513953kabar_s
kamalas13339123kamalas
kauris103611523ka_uris
laari54415713la_ari_
lahars94013163lahar_s
lamas75532793lama__s
lanais6316793lana_is
laris54737463__laris
lazars153812393lazar_s
maars74621633ma_ar_s
mairs76228303__mairs
makars124612633makar_s
malaria9313693malaria
malarias10313753malarias
malars85020683malar_s
mamas95930773mama__s
maras75443283__maras
marcs95726623__marcs
mares76457633__mares
maria75032883__maria
marish114319053__marish
marks115933483__marks
marls75535163__marls
mars66261863__mar_s
marts77442233__marts
mavis105622723__mavis
maxis145721563__maxis
mazards1937703mazards
namers84517333namer_s
naris55735293__naris
navars92810573navar_s
ouraris73512933ouraris
palais8420423pala_is
paris75145943__paris
patamars1246843patamar_s
radars71314663radar_s
ramadas1039303ramadas
ramparts1245583ramparts
remarks13329983remarks
romajis1635903romajis
rumakis1335523rumakis
safari91110223safari_
salamis9313513salamis
salaries8319573salaries
samadhis1444253samadhis
samara8313853samar_a
samarium1257283samarium
samariums1345133samariums
sambars115113843sambar_s
samsaras1045873samsaras
samurais1046133samurais
saris54544953__saris
sataras7315053sataras
satoris7317233satoris
savarin10310003savarin
savarins1139893savarins
seamarks1445303seamarks
simars84916933simar_s
smarms105712533_smarms
smarts86218003_smarts
souaris7312323souaris
tabanid1047323tabanid
tabanids1144963tabanids
tabard9313333tabar_d
tabaret92717313tabaret
tabarets10287233tabarets
tabbis102910863ta_bbis
tabers84621573taber_s
taborin92210453taborin
taborins103310213taborins
tabors84517093tabor_s
tabulis938833tabulis
tagrags936123tagrags
tahinis1048003tahinis
tahrs85412333ta_hr_s
takahes1436173takahes
takas95520683taka__s
takers103923743taker_s
talar56225383talar__
talas55935893tala__s
talers64628143taler_s
tallis63319963ta_llis
tamable11312843tamable
tamal73522613tama__l
tamale83717393tama_le
tamandu1044423tamandu
tamandus1143943tamandus
tamarack1644363tamarack
tamaracks1743753tamaracks
tamarillo1152743tamarillo
tamarillos1252113tamarillos
tamasha12125423tamasha
tamashas13135683tamashas
tambacs13219363tambacs
tambaks15218153tambaks
tambalas1237033tambalas
tamburas12316043tamburas
tamburs11288603tamburs
tamein8313083tam_ein
tameins9311413tameins
tamer75230103tamer__
tames75242013tam__es
tamises92715973tamises
tammie104212683tam_mie
tammies113814683tammies
tampalas1245473tampalas
tampans113310983tampans
tampers113516743tampers
tampons112711553tampons
tamps95524083tam__ps
tams67247933tam___s
tanbarks1445563tanbarks
tankards1366253tankards
tantaras8269533tantaras
tantras73112093tantras
tantric939573tantric
tantrism1048373tantrism
tanukis1134713tanukis
tanyards1276183tanyards
tapalos938813tapalos
tapas74627713tapa__s
tapers84025813taper_s
tapirs84113173tapir_s
tapis75028863t__apis
taramas9612693taramas
tares57456563t__ares
tarmacs1138323tarma_cs
tarns56433953t__arns
taros55640823t__aros
tarps76527113t__arps
tarres64723043ta_rres
tarries73324263ta_rries
tars46763953t__ar_s
tarsi55222173t__arsi
tartaric1047053tartaric
tartars73313403tartar_s
tarts57242023t__arts
tatami839183tatami_
tatar56122063tatar__
taters64932193tater_s
tatsois748373tatsois
taverns10317803taverns
tawdries12136083tawdries
tawers94118603tawer_s
taxers134015283taxer_s
taxis126821973t__axis
teacarts10116073teacarts
tears55436463t_ear_s
teawares1148083teawares
terais64023503tera_is
tetris62816293t_etris
tharms115712243t_harms
thwarts1345023thwarts
tiaras6314533t_iaras
timarau975843timarau
timaraus1095063timaraus
timbres11249343timbres
timers84420993timer_s
tmesis8529793t_mesis
tolars64817923tolar_s
tomans85419133toma_ns
tovarish1445123tovarish
towards1138783towards
tramcars1245223tramcar_s
tsadis7429133t_sadis
tsarism958253t_sarism
tsarist7712253t_sarist
tsars56717103t_sar_s
tsooris734693tsooris
tsoris63411193t_soris
tsouris735153tsouris
tsuris62710203t_suris
tuataras844853tuataras
tuladis835693tuladis
tumbril11256403tumbril
tumbrils12255373tumbrils
tumors8810603tumor_s
tzarism1866323t_zarism
tzarist1659103t_zarist
tzars144914273t_zar_s
tzuris15286913t_zuris
uakari1046863uakari_
umamis1038273_umamis
uraris63817273_uraris
vagaries12310293vagaries
vawards14457573vawards
wasabis1255363wasabis
zamarra1843783zamarra
zamarras1943803zamarras
zamarro1842883zamarro
zamarros1942683zamarros

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.1401276364.3
2DLD Change Limit1340272957.72017361.0
3Display Results2952950.0933172.0
 (SQL Overall)1786912957.95322468.4
 
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.