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

423 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
lessens740938(None) 
lessees73510241lessees
lessen64212431lessen_
lessons73811021lessons
blessers10277632blessers
blesses93812392blesse_s
cesses84221362cesse_s
esses56422972_esse_s
fesses94820252fesse_s
jesses135215952jesse_s
lasses64827592lasse_s
leadens83610982leadens
leasers74717842leasers
leases65428112lease_s
leavens10409302leavens
lebens8310092le_bens
lenses64620892lense_s
leses54930812le_se_s
lesions73813872lesions
lessee64116362lesse_e
lessened935102lessened
lesser63514852lesse_r
lesson64412042lesson_
lessors73610522lessors
listens74014132listens
loesses7310032loesse_s
loosens716310962loosens
losses65925232losse_s
messans92710462messans
messes84924342messe_s
nesses64718322nesse_s
vessels1035932vessels
yesses93615812yesse_s
aspens85013353_aspens
assent65119953_assent
assents74512223_assents
asses55629283_asse_s
assess65710463_assess
assets65617663_assets
basses85428303basse_s
bassets96414823bassets
beseems1175913beseems
beses75830723be_se_s
besets85718803be_sets
blessed10319493blesse_d
blesser9329293blesse_r
blessing1137593blessing
blessings1233723blessings
blisses94911513blisse_s
bosses85925403bosse_s
busses85023383busse_s
cassena9287843cassena
cassenas10317483cassenas
cassene93111543cassene
cassenes103611293cassenes
ceases84427073cease_s
censers94313903censers
censes83721803cense_s
cessed94615613cesse_d
cessing103814813cessing
cessions1039853cessions
chesses124112633chesse_s
classers104111833classers
classes94717943classe_s
classons1037703classons
colessees11146053colessees
cossets95014283cossets
cresses94219813cresse_s
cressets10309103cressets
cussers94213403cussers
cusses84522773cusse_s
deadens93410693deadens
deafens11317253deafens
deepens10307813deepens
descend11248153descend
descends12266983descends
descent102616293descent
descents112511203descents
designs9328313designs
desmans1039003desmans
dessert82916453dessert
desserts9247923desserts
dissent84018683dissent
dissents93411863dissents
disses75225963disse_s
dossels85511613dossels
dossers84516233dossers
dosses76126273dosse_s
dressers9359863dressers
dresses83716173dresse_s
easels65914553_easels
eases56041613_ease_s
elevens1066803elevens
eosins64419163_eosins
erses55826803_erse_s
eses45336103_e_se_s
eskers105312223_eskers
esnes54817363_esne_s
essays965653_essays
essence947673_essence
essences1047563_essences
essoins737603_essoins
esters64627733_esters
evens84817103_e_vens
fastens105511753fastens
feases95422923fease_s
fesse86116333fesse__
fessed104515063fesse_d
fessing113812863fessing
festers104121393festers
flehmens1643233flehmens
flensers1135463flensers
flenses1039473flense_s
fleshers14339443fleshers
fleshes133913273fleshe_s
flossers11307863flossers
flosses103411973flosse_s
fosses96022083fosse_s
freshens14298313freshens
fussers104210813fussers
fusses94920553fusse_s
gassers84714633gassers
gasses75724783gasse_s
genseng933983genseng
gensengs1043093gensengs
germens1078633germens
gessoes838293gessoes
gestes75721393geste_s
geysers1135703geysers
glasses84414273glasse_s
glistens9366593glistens
glossers9319053glossers
glosses84014123glosse_s
gossans836783gossans
greisens954653greisens
guessers9174903guessers
guesses8169373guesse_s
gussets837443gussets
hassels104311023hassels
hastens106214813hastens
hausens1077633hausens
heavens13439303heavens
hessians1145053hessians
hissers104112313hissers
hisses94719353hisse_s
idlesses936003idlesse_s
ileuses738673ileuse_s
isseis638563_isseis
jerseys1733243jerseys
jessant1438443jessant
jesse126012833jesse__
jessed144112303jesse_d
jessing153710623jessing
jesters144118193jesters
josses135117683josse_s
keens95721183ke__ens
kelsons1137323kelsons
kerseys1433993kerseys
keysets1434343keysets
kissers114211293kissers
kisses104217333kisse_s
knessets1243173knessets
ladens74516233l_adens
lapsers93911053lapsers
lapses85217693lapse_s
lasers64925703l_asers
lases54944763l_ase_s
lashers104121833lashers
lashes94831003lashe_s
lashins103915153lashins
lassies74420103lassies
lassis65216703lass_is
lassoers8338513lassoers
lassoes74613853lassoes
lassos64913813lass_os
lasters75627693lasters
lateens74210553lateens
latens64620213l_atens
lattens75014673lattens
leaden74515223leaden_
leaders83819603leaders
leakers113415423leakers
leaners73718173leaners
leans55536253le__ans
leapers93716663leapers
learns65513743le_arns
lease55230263lease__
leased74722883lease_d
leaser65322673lease_r
leashes103514403leashes
leasing83920163leasing
leasings9379843leasings
leasts64616413leas_ts
leaven95013073leaven_
leavers103717783leavers
leaves94222383leave_s
leben7314853le_ben_
lechers123313963lechers
leches115421313leche_s
lecterns1035943lecterns
lectins92515003lectins
ledgers94912183ledgers
ledges84918013ledge_s
leeks95318893le__eks
leers54828983le__ers
lees45455883le__e_s
leets54927123le__ets
legend837693le_gend
legends936073le_gends
legers74518313le_gers
leges64427293le_ge_s
leggins9259473leggins
legions84611783legions
legless838013legless
legmen939343legmen_
leisters83312823leisters
lemans85316393le_mans
lemons84415053le_mons
lenders84419643lenders
lenes54738523le_ne_s
lenient7313843lenient
lens46146493l___ens
lense54523433lense__
lensed74015473lense_d
lensing84015103lensing
lensless835583lensless
lensmen937883lensmen_
lenten6312883lenten_
leones64417723leone_s
lepers84817323le_pers
leptins92412693leptins
leptons91910433leptons
lesbians1043603lesbians
lesbos837403le_sbos
lesion64715063lesion_
less45635103le_s__s
lessening1045333lessening
lessoned945393lessoned
lessor64010603less_or
lethes94818083lethe_s
letters73819853letters
leucins938103leucins
leudes75314093leude_s
leukons1135753leukons
levees93714523le_vees
levels94113283le_vels
levers94621323le_vers
leviers103510343leviers
levies93919863levie_s
levins94514653le_vins
lewises1039133lewise_s
lewissons1241743lewissons
lexes127225263le_xe_s
lezzes14387833lezze_s
lichens123510683lichens
liens56525503l__iens
likens105613703l_ikens
limens84618033l_imens
lindens839413lindens
linens64818393l_inens
linseys1035083linseys
lippens11328533lippens
lisles63416283lisle_s
lispers94514323lispers
listees73416673listees
listels74212433listels
listen64816813listen_
listers74026533listers
livens94314893l_ivens
lodens74315063l_odens
loosen66615963loosen_
looses67328253loose_s
losels64714593l_osels
losers65123583l_osers
loses56742013l_ose_s
lossless835473lossless
loudens8368053loudens
louses66230283louse_s
lumens85013973l_umens
lumpens11298263lumpens
lushes94022743lushe_s
lusters73921443lusters
lususes736713lususe_s
lyases95211873lyase_s
lyses84518253l_yse_s
lysines10369093lysines
lysins94610953l_ysins
lysogens1244523lysogens
lyssas935443lyss_as
masses85028713masse_s
menses84222453mense_s
meseems1165603meseems
meshes115019443meshe_s
mesnes85216213mesne_s
mesons83215843me_sons
messan83912063messan_
messed95018183messe_d
messing103916393messing
messmen1137393messmen_
mestees94617753mestees
mispens11311073mispens
missels94614813missels
missend104411373missend
missends11368233missends
missense1037963missense
missent94318713missent
misses85130873misse_s
missets94516573missets
mossers94116193mossers
mosses85527683mosse_s
mussels9419843mussels
musses84624783musse_s
neatens73310403neatens
nelsons738003nelsons
nesters74422793nesters
osseins736133_osseins
oyesses1037333oyesse_s
passels93913023passels
passers94717753passers
passes86030473passe_s
peahens12307573peahens
peasen84815963peasen_
peases85229473pease_s
pectens11189203pectens
peens76428193pe__ens
peises84125043peise_s
pensees9311203pensees
pepsins11310433pepsins
perses85428063perse_s
persons93717013persons
pesters93827093pesters
pissers95014753pissers
pisses84525083pisse_s
pleasers104010293pleasers
pleases94515483please_s
plessors10278253plessors
plisses94411773plisse_s
plusses93510693plusse_s
posses85128803posse_s
possess9419123possess
possets94212773possets
pressers103215023pressers
presses93523153presse_s
pusses84322843pusse_s
reasons72514943reasons
reassess836513reassess
reddens9259783reddens
reopens939373reopens
reseeds84012333reseeds
reseeks11348623reseeks
reseen64318413reseen_
resees63827483re_sees
resend75016773re_send
resends83513713re_sends
resent63833623re_sent
resents74221223re_sents
resets65427613re_sets
resews94814173re_sews
reshes94124363reshe_s
resigns83910963resigns
resins64528773re_sins
resters74130403resters
reuses66025523reuse_s
russets738163russets
sarsens7311393sarsens
sasses64124393sasse_s
seasons72614233seasons
seisers73816393seisers
seises64026713seise_s
seisins73614393seisins
selsyns1092943selsyns
semens84616973se_mens
senseis73310643senseis
senses63923943sense_s
sepses84515883sepse_s
sessions839723sessions
sestets7911473sestets
sevens93813663se_vens
sisses64520603sisse_s
sleekens12274873sleekens
susses64221053susse_s
tassels74510853tassels
tasses64826763tasse_s
tassets75012773tassets
teasels74311313teasels
teasers75317243teasers
teases65426273tease_s
teens56227483te__ens
telsons739223telsons
tenses64722553tense_s
tessera736333tessera
testees74215913testees
testers74124543testers
testes65125823teste_s
testons7313563testons
tossers74713503tossers
tosses65225393tosse_s
tressels8367653tressels
tresses73719543tresse_s
tussehs10395563tussehs
tussers74313563tussers
tusses64921243tusse_s
versers103813523versers
verses94223763verse_s
versets103913103versets
vespers1239033vespers
vessel937953vesse_l
vestees103513173vestees
weakens14367063weakens
weasels10468503weasels
weasons102310583weasons
weens85224053we__ens
wessand1144833wessand
wessands1243683wessands
westerns11328963westerns
westers105221963westers
wisses94619603wisse_s
worsens104610263worsens
wusses93314893wusse_s
yeses85119323ye_se_s
yessed104511163yesse_d
yessing113210063yessing
zesters163517293zesters

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 Filter1786911340270.393454684.5
2DLD Change Limit1340274236.40320931.9
3Display Results4234230.1602643.8
 (SQL Overall)1786914236.95625688.8
 
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.