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

496 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
patents9481520(None) 
latents75214311latents
parents93418121parents
patens84820861paten_s
patent84524921patent_
patients1088761patients
agents74816292_agents
aments85219802_aments
catenas9313112catenas
detents83615152detents
extents142610172extents
intents72115702intents
laments94314852laments
latens64620212laten_s
latent64124302latent_
latests73910312latests
pageants1136692pageants
paints85921832pa_ints
palets85122312pale_ts
pants76536922pa__nts
parent83230422parent_
paten74827342paten__
patency1466312patency
patented1188892patented
patentee1099942patentee
patentees1196542patentees
patently1347112patently
patentor1046372patentor
patentors1146742patentors
paters84935832pate_rs
pates76047892pate__s
patient9617072patient_
patinas96318522patinas
patines95225762patines
patins87528782patin_s
patness92912282patness
pattens95414922patten_s
payments1536942payments
platens94213982platen_s
portents103512822portents
potent84223352potent_
stents65019452_stents
talents7312012talents
tents56434212__tents
abets75621673_abe_ts
absents93510723absents
accents113511233accents
adepts9117103_adepts
advents11309473advents
agenes74720253_agenes
agent65829643_agent_
akenes104817343_akenes
alants67722023_alants
alerts64418223_alerts
amends94713283_amends
amens75624843_amen_s
ament76036543_ament_
anenst63514983_anenst
anent54931843_anent_
ants47243473_a__nts
apartments1445703apartments
aplenty1237173aplenty
appends1236393appends
aptest82917513aptest_
aptness9268573aptness
arenas65021993_arenas
arenes64928393_arenes
argents84014853argents
arpents93613083arpents
ascents93812553ascents
assents74512223assents
ates45047923_ate__s
atones65225773_atones
attends8257593attends
attent62818323attent_
attests7278813attests
aunts55227633_a_unts
avens86419333_aven_s
averts95715243_averts
bannets94013843bannets
bantengs1134593bantengs
bartends1136793bartends
bates75846343bate__s
batons85519423baton_s
battens95313263batten_s
batts76727563bat__ts
bents76033693__bents
brents84717273_brents
butenes9313033butenes
cadent94120363cadent_
cadets96316513cade_ts
calends1039523calends
cants77036943ca__nts
carets85330773care_ts
carnets93918403carnets
catena8312483caten_a
catenae9311373catenae
catenate10312833catenate
catenates11311813catenates
caters85336503cate_rs
cates75951893cate__s
catguts1045323catguts
cathects1545793cathects
catmints1236663catmints
caveats1239803caveats
cements112714223cements
cents74730333__cents
clients938093clients
coagents1138453coagents
contents104018213contents
coparents1347973coparents
daters74827373date_rs
dates65639153date__s
daunts75014083da_unts
davens104612913daven_s
dements103016623dements
dents65031803__dents
detects104011093detects
detent73624483detent_
detente83313603detente
detentes92712873detentes
detests83711743detests
docents102810803docents
eaten55323053eaten__
eaters65535953eate_rs
eatings84616443eatings
eluents738703eluents
entente7412953entente
ententes8312773ententes
events94814073_events
extends15227113extends
extent132714913extent_
facets116316653face_ts
faenas94412763fa_enas
faints94818783fa_ints
fastens105511753fasten_s
fates85139233fate__s
fatness103311293fatness
fattens105111713fatten_s
fitments1376793fitments
foments122912053foments
galenas83310343galenas
gannets83811443gannets
garments1139963garments
garnets84115403garnets
gateaus866333gateaus
gaters74728643gate_rs
gates65939513gate__s
gatings95212823gatings
gents65729613__gents
gerents82612923gerents
haets86525123ha_e_ts
haints94417583ha_ints
hants86335403ha__nts
haptenes133810823haptenes
haptens124511343hapten_s
hastens106214813hasten_s
haters94930403hate_rs
hates86742573hate__s
haunts95614393ha_unts
havens124514043haven_s
hents87330743__hents
hutments1345603hutments
impotents1347003impotents
incents92414533incents
indents83114663indents
inpatients1244293inpatients
intends8239963intends
intent63122773intent_
invents102812053invents
jaunts137511883ja_unts
kalends1235683kalends
ketenes114813503ketenes
ladens74516233laden_s
lagends947273lagends
lament85024943lament_
lateens74210553lateens
laten54328343laten__
latency1236033latency
latened8711923latened
lateness82614073lateness
latently1146353latently
latest63822703latest_
latexes1438313latexes
latinas74416463latinas
latinos73613803latinos
lattens75014673latten_s
loments93413473loments
magenta1038623magenta
magentas1137923magentas
magnets10311143magnets
margents11410133margents
martens93714953marten_s
matelots1047533matelots
maters85032393mate_rs
mates75251363mate__s
mateys115610943mate_ys
matings104516213matings
matins84527783matin_s
matts76829183mat__ts
mavens114312973maven_s
moments113113123moments
motets84216193mote_ts
mutants938583mutants
natant6318733natant_
nates55238333nate__s
neatens73310403neaten_s
oaten55222403oaten__
oaters65029793oate_rs
obtests9136233obtests
octants9128733octants
octets839403octe_ts
orients7311583orients
outeats72215703outeats
pacers105124543pace_rs
paces96741113pace__s
packets155114773packets
pacts95125803pa__cts
paeans85118263pa_eans
paeons83915523pa_eons
pagans95717923pagan_s
pageant10312783pageant_
pagers94423253page_rs
pages85235073page__s
pagings114411063pagings
pains75138283pa_in_s
paint75443693pa_int_
painty114714753pa_inty
pakehas1635313pakehas
paleate94120003paleate
paleness10312983paleness
pales75753803pale__s
palest83926223palest_
palet74650803pale_t_
paletots1047803paletots
palette93613983palette
palettes103112833palettes
palings103915823palings
pallets93919303pallets
palters94021683palte_rs
pandects1335843pandects
pandits103914213pandits
panels84716523pane_ls
panes76148693pa__nes
pangenes112612823pangenes
pangens103112063pangen_s
pangs84628663pa__ngs
panners93621273panners
pannes85522853pa_nnes
pans65855733pa__n_s
pant66061263pa__nt_
panto76129413pa__nto
pantos85222743pa__ntos
panty105929303pa__nty
papers105125323pape_rs
papists112110453papists
paraments13511553paraments
parangs104314373parangs
parental10310943parental
parented11912213parented
pareos87023773pare_os
parers85530743pare_rs
pares77164483pare__s
pareses94718883pareses
paresis93315093paresis
pareus85420743pare_us
pargets105215193pargets
parings104219213parings
parrots9312743parrots
partans94418283partan_s
partings113513733partings
partlets102811513partlets
partners102711133partners
partons94620513parton_s
parts77743373pa__rts
parvenus1335653parvenus
paseos88015813pase_os
pases75346503pase__s
pastels95215183paste_ls
pasterns104112623pasterns
pasters94531733paste_rs
pastes85233913paste__s
pasteups1243493pasteups
pastinas103712153pastinas
pastness102510503pastness
pasts75936503pa__sts
patacas11311003patacas
patches143320383patches
pate65350463pate___
pated85237843pate__d
patella938953patella
patellas1039103patellas
patencies1349173patencies
patenting1248943patenting
pater74740723pate__r
paternal1038333paternal
paternity1444833paternity
pathos115516693pat_hos
paths105521383pat__hs
patience1247523patience
patiences1367433patiences
patienter1145553patienter
patientest1245713patientest
patiently1445633patiently
patin76832853patin__
patina86022193patin_a
patinae95414403patinae
patinate103016313patinate
patinates113814693patinates
patine85328123patin_e
patined105114783patined
patios85221783pat_ios
patois84319363pat_ois
patriots1038053patriots
patrols93513513patrols
patrons93818103patrons
pats66460853pa___ts
patsies93919483patsies
patten84418193patten__
pattened11299393pattened
patterns10439943patterns
patters94825193patters
patties93425143patties
patty104723613pat__ty
patulent1048603patulent_
patzers184210573patzers
pavanes123612653pavanes
pavans115715593pavan_s
pavements1647003pavements
pavers115021823pave_rs
paves104833923pave__s
pavings134011633pavings
pavins114919663pavin_s
pawers114818783pawe_rs
pawnees12298173pawnees
pawners124311073pawners
pawns108818133pa_wn_s
paxes144928423paxe__s
payees114812903paye_es
payers114621823paye_rs
payment14310703payment_
payouts1247303payouts
peahens12307573peahen_s
peasants1038263peasants
peats76140193p__eats
pectens11189203pecten_s
pedants10310113pedants
peens76428193p_een_s
pelts76128813p__elts
pendents1139413pendents
pends85527193p__ends
penes75839223p__enes
penis75129323p__enis
penitents1147703penitents
pens65649643p__en_s
pent66559073p__ent_
pentenes10315633pentenes
percents122713373percents
perpents122312033perpents
pests75933273p__ests
peters86624593pete_rs
pets66248333p__e_ts
petuntse1042473petuntse
pigments1337343pigments
pimento1157223pimento
pimentos1246233pimentos
pinenes93416673pinenes
pints75936223p__ints
pipets105714773pipe_ts
piteous9310683piteous
pitons85319043piton_s
placenta1275723placenta
placentas1364823placentas
placets113911223place_ts
plaints94012053plaints
planets93914083plane_ts
plants84921803p_lants
platanes102711883platanes
platans93413123platan_s
plateaus1035533plateaus
platelets1165763platelets
platen84518203platen__
platers93924093plate_rs
plates85432243plate__s
platinas103610313platinas
platings113611363platings
pleats85218593p_leats
plenty11311413p_lenty
poets76024443p_oe_ts
points85618533p_oints
polenta9310093polenta
polentas1038743polentas
ponent82821593ponent_
portends11358963portends
portent93619643portent_
poteens92910883poteens
potence11711363potence
potences12710693potences
potency1457433potency
potently1347403potently
praters94921653prate_rs
prates84633163prate__s
precents123015043precents
preens85020113preen_s
presents103315643presents
prests84021263p_rests
pretends11299113pretends
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
priests93810863priests
prints84320103p_rints
protects1239743protects
protends113010353protends
protests10310493protests
pschents1544113pschents
punnets9409263punnets
punts75828003p__unts
putons83515153puton_s
putouts937083putouts
putts75719273put__ts
pyrenes123511223pyrenes
raiments1039903raiments
ramenta9311183ramenta
ramets83517393rame_ts
rants55935343ra__nts
ratans63819373ratan_s
ratels64518213rate_ls
raters63936583rate_rs
rates55352013rate__s
ratines75328583ratines
ratings84217413ratings
rattens74213403ratten_s
ravens93916883raven_s
reagents959623reagents
regents83416543regents
relents74018503relents
rents55935183__rents
repents93717623repents
rerents73319423rerents
resents74221223resents
retenes76324623retenes
retests73813853retests
retints74717013retints
rodents8611543rodents
saints65122423sa_ints
salients839563salients
sapients1037423sapients
sarments10311963sarments
satangs8479713satangs
sateens73710753sateens
sates54949323sate__s
satinets8311733satinets
satins64930483satin_s
savants1038653savants
scents85317023_scents
silents73514493silents
sklents11348163sklents
spates85028173spate__s
splents93912133splents
stenos63915773_stenos
stent55634513_stent_
stets55423913_ste_ts
stints65119763_stints
stunts65615253_stunts
taints64520533ta_ints
talent6323323talent_
tangents938713tangents
taters64932203tate_rs
tates55444983tate__s
taunts65715663ta_unts
tautens7317843tauten_s
teats55636813__teats
tends65425583__tends
tenets65518953__tenets
tens45647413__ten_s
tent46159863__tent_
tenth85421833__tenth
tenths94412663__tenths
tenty86121603__tenty
tests56530193__tests
tets45847463__te_ts
texts125515043__texts
tints56030923__tints
urtexts1433143urtexts
valets93715623vale_ts
varments1339063varments
vaunts95212623va_unts
vents86125933__vents
wakens135012043waken_s
wants87932213wa__nts
waters95030633wate_rs
watts86923093wat__ts
wisents10249063wisents
yamens114010823yamen_s
zazens1435833zazen_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.1401276364.3
2DLD Change Limit1340274966.93619323.4
3Display Results4964960.1862666.7
 (SQL Overall)1786914967.26224606.3
 
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.