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

314 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
lessor6401060(None) 
lesser63514851lesser
lesson64412041lesson
lessors73610521lessors
plessor9317691plessor
blesser9329292blesser
censor84011292censor
colessor1045232colessor
gesso649602gesso_
lasso55015682lasso_
lassoer7379382lassoer
lassos64913812lassos
leaser65322672leaser
lector83514982lector
lesbo739252lesbo_
lesbos837402lesbos
lesion64715062lesion
less45635102less__
lessee64116362lessee
lessen64212432lessen
lessons73811022lessons
lissom837402lissom
nestor63713422nestor
plessors10278252plessors
pressor93512882pressor
seisor63712342seisor
sensor63813842sensor
tensor63812672tensor
tussor6378232tussor
alastor739653alastor
assessor843623assessor
assort64916383_assort
basso76017283basso_
bassos85313703bassos
bedsore1057803bedsore
bescour1145203bescour
besnow1145713besnow
besom95716973be_som
besot76429713be_sot
bestir8311163bestir
bestow1149463bestow
bettor83612223bettor
bevor101510813be_vor
blesbok1543123blesbok
bless75917813bless__
blessed10319493blessed
blessers10277633blessers
blesses93812393blesses
blossom11114963blossom
castor84418533castor
censer84516583censer
censors93611843censors
cess65326053cess__
cessed94615613cessed
cesses84221363cesses
cession939813cession
cestoi84511953cestoi
cestos84718093cestos
classer93614613classer
classon937693classon
colessors1145663colessors
cursor84110293cursor
cusser86016093cusser
cusso74912293cusso_
cussos84210003cussos
debtor938333debtor
decor84717573de_cor
denser74115193denser
desorb95210203de_sorb
despot93413293despot
dessert82916453dessert
devisor11357043devisor
dosser74417973dosser
dresser83611953dresser
elector93313253elector
elusory1083993elusory
ephor10310013_ephor
error53712233_error
escar74011993_escar
escort84616483_escort
escot75320083_escot
eskar9457453_eskar
esker94412983_esker
ess36030883_ess__
essay867623_essay
esses56422973_esses
essoin638193_essoin
ester54727713_ester
estop74312103_estop
fervor1235643fervor
fess76529163fess__
fesse86116333fess_e
fessed104515063fessed
fesses94820253fesses
fester94723513fester
fetor81214533fe_tor
flenser1036783flenser
flesher133610923flesher
flexor1634503fle_xor
flosser10339693flosser
fusser94813773fusser
gasser75017773gasser
gessoed935743gessoed
gessoes838293gessoes
geyser1036513geyser
glosser83410813glosser
guesser8166543guesser
hector113312653hector
hisser94713793hisser
hussar9317283hussar
hyssop1443413hyssop
jess116022033jess__
jesse126012833jess_e
jessed144112303jessed
jesses135215953jesses
jester134319153jester
jetsom15126143jetsom
kelson1038153kelson
kisser104212453kisser
kusso9398033kusso_
kussos10336423kussos
labor75117313l_abor
lapser84113143lapser
lascar868573lascar
laser54633323l_aser
lasher94824533lasher
lass47444543lass__
lasses64827593lasses
lassi56316853lass_i
lassie64917743lassie
lassis65216703lassis
lassoed8408743lassoed
lassoers8338513lassoers
lassoes74613853lassoes
laster64830633laster
leader74824653leader
leaker104620073leaker
leaner64022193leaner
leaper88118943leaper
lear47045953le__ar
leas45954183leas__
lease55230263leas_e
leased74722883leased
leasers74717843leasers
leases65428113leases
leash85519213leas_h
least56134883leas_t
leasts64616413leasts
leaver94321513leaver
lecher113415853lecher
lectors93415763lectors
ledger85914393ledger
leer46239353le__er
lees45455883lees__
lefter93613433lefter
legator83011133legator
leger65721513le_ger
leghorn1146223leghorn
legion75712983legion
legs56133693legs__
legwork1545663legwork
lehr75514943le__hr
leis45739603leis__
leister73212753leister
leisure736693leisure
leks85427603leks__
lekvar1333043lekvar
lemon75618183le_mon
lemur739773le_mur
lender73921273lender
leno47331393le_no_
lenos56024863le_nos
lens46146493lens__
lense54523433lens_e
lensed74015473lensed
lenses64620893lenses
lento57223393lento_
lentos65317403lentos
leper74820743le_per
lepton82510803lepton
les35663073le_s__
leses54930813le_ses
lesions73813873lesions
lessees73510243lessees
lessens7409383lessens
lessoned945393lessoned
lest46956323le_s_t
lets47147943lets__
letter63722583letter
leukon1036143leukon
levator10298963levator
lever85125163le_ver
levier94013873levier
levo76820063le_vo_
lewder10479613lewder
lewisson1142023lewisson
leys76430183leys__
licensor10113723licensor
lictor83610853lictor
liquor1534203liquor
lisper84114433lisper
lissome937583lissome
lister64527253lister
loess55714703loess__
loessal744393loessal
loesses7310033loesses
looser65219943looser
loser54728673l_oser
loss45337963loss__
losses65925233losses
lossy85214643loss_y
lusher93818763lusher
luster64023673luster
lyssa835713lyss_a
lyssas935443lyssas
mentor8414363mentor
meson74118313me_son
mess65932433mess__
messan83912063messan
messed95018183messed
messes84924343messes
messier93412923messier
messy104913833mess_y
meteor84910073meteor
missort9314653missort
mosser84618273mosser
mosso74715183mosso_
nelson638423nelson
ness45526563ness__
nesses64718323nesses
nester64124183nester
nestors73614973nestors
obsessor1043033obsessor
passer84721033passer
pastor84817483pastor
person83517873person
peso66925823pe_so_
pesos77221623pe_sos
pessary1246873pessary
pester84827593pester
pesto75723723pesto_
pestos84719083pestos
pisser84416383pisser
pissoir945043pissoir
pleaser93912343pleaser
pledgor11334993pledgor
plexor1535253ple_xor
presser93717623presser
pressors103212693pressors
questor16146633questor
reason62616333reason
reassort8410683reassort
rector84019753rector
rescore95616203rescore
reshod103012233reshod
reshoe92816483reshoe
reshot93519633reshot
reshow123111433reshow
resistor847673resistor
resod64720053re_sod
resorb84914353re_sorb
resort65728623re_sort
resow88217243re_sow
respot83117633respot
rester63832433rester
restore75822983restore
revisor10388733revisor
scissor994123scissor
season62714903season
sector83415933sector
seiser65318343seiser
seisors73212843seisors
seizor15428533seizor
senhor93010813senhor
senior63214053senior
senor53822803se_nor
sensors73514643sensors
sensory10329093sensory
session739763session
stressor875543stressor
sublessor1143653sublessor
teaser65421523teaser
telson6310293telson
tenor53620253te_nor
tenser64919433tenser
tensors72712373tensors
termor84412513termor
terror63811733terror
terser67317823terser
tessera736333tessera
tester64227153tester
teston6313303teston
tosser64215663tosser
tressour844573tressour
tussar6369543tussar
tusser64615833tusser
tussore7317283tussore
tussors7388773tussors
tussur6357293tussur
vector113212063vector
vendor10359803vendor
verser94516963verser
verso85314633verso_
versos93812803versos
vesper1138083vesper
vessel937953vessel
visor82512833_visor
weason93210823weason
weldor10317653weldor
wester94222893wester
yessed104511163yessed
yesses93615813yesses
yester93417983yester
zester153617793zester

Search took 7 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 Filter1786911127160.780229091.0
2DLD Change Limit1127163145.78319490.9
3Display Results3143140.0933376.3
 (SQL Overall)1786913146.65626846.6
 
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.