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

241 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
smartens1028666(None) 
martens93714951_martens
smarten9348861smarten_
heartens113010152heartens
marten84518262_marten_
martins93322062_martins
sarsens7311392s_arsens
sharpens13377812sharpens
shortens11288992shortens
smartass1044272smartass
smarted105012612smarte_d
smartened1244262smartened
smarter94113132smarte_r
smartest10310182smartest
smarties10312872smarties
smarting113212452smarting
smartness1136142smartness
smarts86218002smart__s
smatters104011712smatters
starters83714772starters
amarones10311353amarones
arpens84814823__arpens
artels66216233__artels
barrens94414323_barrens
bartend1038753_bartend
bartends1136793_bartends
barters94223033_barters
battens95313263_battens
careens94514703_careens
cartels94618123_cartels
carters95327253_carters
cartes86239473_carte_s
cartons94122473_cartons
charters134115583charters
chastens13429183chastens
chortens13308793chortens
coarsens10348123coarsens
darkens12409873_darkens
darters84017603_darters
ecartes94212563ecarte_s
fastens105511753_fastens
fattens105111713_fattens
flattens11357483flattens
gardens93312093_gardens
garters84218233_garters
haptens124511343_haptens
hardens113815023_hardens
harkens144112863_harkens
hastens106214813_hastens
hearkens15336693hearkens
hearten102411753hearten_
hoarsens11306023hoarsens
imarets9138643imar_ets
imparters13276573imparters
latens64620213_la_tens
lattens75014673_lattens
maddens11359753_maddens
maidens10349663_maidens
malteds10377603_malteds
mantels94515043_mantels
mantes84430783_mante_s
marcels113212373_marcels
mares76457633_mar_e_s
margent10316693_margent
margents11410133_margents
marges94525713_marge_s
margins103815193_margins
marines93928013_marines
markers133516103_markers
markets133314033_markets
marlins93420473_marlins
maroons92615553_maroons
marrers93414313_marrers
marrons93216973_marrons
marses84827113_marse_s
marted94425213_marte_d
martians103111613_martians
martin84122523_martin_
marting103325013_marting
martini93613873_martini
martinis103311613_martinis
martlets103310483_martlets
marts77442233_mart__s
martyrs1234893_martyrs
marvels123810093_marvels
masters94628923_masters
maters85032393_ma_ters
mates75251363_ma_te_s
mateys115610943_ma_teys
matins84527783_ma_tins
matres84522233_matre_s
matrons93517633_matrons
matters94421753_matters
mattes85624533_matte_s
mattins93316143_mattins
mavens114312973_ma_vens
mittens9349883_mittens
moreens939963_moreens
morgens10310463_morgens
neatens73310403nea_tens
partans94418283_partans
partons94620513_partons
patens84820863_pa_tens
pattens95414923_pattens
platens94213983pla_tens
quartans1736283quartans
quarterns18285153quarterns
quarters173110453quarters
quartes163314933quarte_s
quartets17277573quartets
rattens74213403_rattens
saddens9309603s_addens
salterns8388903s_alterns
salters73622253s_alters
samaritans1242933samaritans
samisens1035483samisens
samites93118713samite_s
sapiens9310173s_apiens
sarans64224433s_ar_ans
sarees65329943s_ar_ees
sarges75128593s_arge_s
sarins63932623s_ar_ins
sarment9318763s_arment
sarments10311963s_arments
sarsen6314233s_arsen_
sartors7314973s_artors
sateens73710753s_ateens
sates54949323s_a_te_s
satins64930483s_a_tins
sautes63924913s_aute_s
scarers94618513scar_ers
scares85033003scar_e_s
scarfers13408463scarfers
scarless10189053scarless
scarlets10178573scarlets
scarpers124712513scarpers
scarted104816123scarte_d
scarting113415263scarting
scarts85321493scart__s
scarves124511623scarve_s
scatters103612753scatters
screens95212183s_creens
seaters74028943sea_ters
shagreens1342633shagreens
shaitans1136413shaitans
shanteys14395513shanteys
sharers104720623shar_ers
shares95236413shar_e_s
sharkers154011053sharkers
sharns95516983shar__ns
sharpen12389723sharpen_
sharpers133810943sharpers
shatters113313913shatters
shorten103511413shorten_
sirens65318153s_ir_ens
skaters113512963ska_ters
skates104219403ska_te_s
skirters12337243skirters
slackens14367713slackens
slaters73123733sla_ters
slates64934063sla_te_s
slatterns935363slatterns
smackers16318713smackers
smaltine1037833smaltine
smaltines1136993smaltines
smaltos9408193smalt_os
smalts85214893smalt__s
smaragds1243303smaragds
smarms105712533smar__ms
smart75834093smart___
smartening1344993smartening
smartie9310173smart_ie
smartly12497433smart_ly
smartweed1542113smartweed
smartweeds1651433smartweeds
smarty115013793smart__y
smashers13339593smashers
smashes123914613smashe_s
smatter93613333smatte_r
smazes174311663sma_ze_s
smearers10308623smear_ers
smelters103310513smelters
smidgens12325643smidgens
smirkers14316353smirkers
smiters93414363sm_iters
smites83921923sm_ite_s
smitten936693smitten_
smoothens14194253smoothens
snarers74216663snar_ers
snares65329033snar_e_s
snarlers8298753snarlers
snorters83410583snorters
soarers74118093soar_ers
softens10347623s_oftens
sorters74221133s_orters
sparers94519613spar_ers
spares84834553spar_e_s
spargers11389733spargers
sparges104016343sparge_s
sparkers144111313sparkers
spartan948333spartan_
sparteine1185483sparteine
sparteines12105173sparteines
spartina1037983spartina
spartinas1135793spartinas
spates85028173spa_te_s
spatters103914703spatters
sporters103714063sporters
spurters103311703spurters
stactes91914633stacte_s
stamens93411483sta_mens
starers74522313star_ers
stares66038753star_e_s
starets73515923star_ets
starkers123712393starkers
starless81610843starless
starlets81610083starlets
started84217323starte_d
starter73817883starte_r
starting93116173starting
startlers9236743startlers
startles82111963startles
starts65423123start__s
startups1033893startups
starvers11459643starvers
starves104614553starve_s
staters73922343sta_ters
states64337083sta_te_s
statins73719773sta_tins
stoutens8255273stoutens
straitens946233straitens
swarmers1346323swarmers
swarths13537323swart_hs
swartness1236113swartness
swatters113911793swatters
sweetens11255433sweetens
syrens94911993s_yr_ens
tartans72615823_tartans
tautens7317843_tautens
wardens113711903_wardens
warrens103810893_warrens

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622416.93621073.0
3Display Results2412410.0962510.4
 (SQL Overall)1786912417.43824024.1
 
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.