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 “lores” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

458 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
lores5504540(None) 
bores76448251bores
cores76361851cores
fores85847101fores
gores65740371gores
lares54852631lares
lobes75331001lobes
lodes66436911lodes
loges66534201loges
lopes76437341lopes
lords64923501lords
lore45850351lore_
lories64933041lories
loris55329151loris
loses56742011loses
loves85332011loves
lowes85732461lowes
loxes125227471loxes
lures56138531lures
lyres85019961lyres
mores76249641mores
ores46056681_ores
pores75849031pores
sores55454281sores
tores55352671tores
yores85031321yores
acres76327762acres
adores74420722adores
aloes54933672alo_es
apres75426402apres
ares45871022_ares
aures55137092aures
bares75457132bares
blares85021632blares
blokes123813882blokes
bodes84935102bodes
boles75448602boles
bones76446532bones
boras75938302boras
bore66051332bore_
boreas85421732boreas
bored85034302bored
borer75131272borer
borers85122682borers
borks115727702borks
borts76735452borts
boxes145625072boxes
byres104421382byres
cares77369182cares
ceres75540012ceres
chores114828022chores
cires74932912cires
clones84526562clones
closes85425592closes
cloves114918822cloves
clozes174915562clozes
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cords86030622cords
core67263112core_
cored85044222cored
corer75538872corer
corers85231072corers
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
corse75036182corse
corses84433462corses
corves115122522corves
coses76949492coses
cotes76347842cotes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
crores86121162crores
cures75645432cures
dares66146702dares
doers65225712doers
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
dore56353302dore_
dories75232362dories
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dures65635922dures
elopes85918162elopes
eyres84921772eyres
fares85852872fares
feres86038182feres
fires85740752fires
flares94521702flares
floes85528142flo_es
floras94715692floras
floret9321122floret
florets1039852florets
foes76543442fo_es
forbs105720802forbs
forces114422132forces
fords95328182fords
fore78351472fore_
forest94926742forest
forges105024262forges
forks125324682forks
formes114623712formes
forms105327052forms
fortes95327182fortes
forts86034452forts
foxes156321092foxes
froes86126692froes
galores82614342galores
glares75518872glares
globes94314542globes
glories81915922glories
gloves104115182gloves
glozes164313352glozes
goers65520252goers
goes55644092go_es
gore55744962gore_
gored75227082gored
gorges85321892gorges
gorms85619592gorms
gorps85316992gorps
gorse65926812gorse
gorses74723292gorses
goxes135018262goxes
gyres94820322gyres
hares86255542hares
heres86245902heres
hires86134342hires
hoers85724922hoers
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
horas86333102horas
hordes104921632hordes
horns86125332horns
horse86132652horse
horses94729342horses
hoses85443172hoses
howes114730262howes
ires45639282_ires
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
koras95927112koras
kore85834162kore_
kors85933012kor_s
laces76141762laces
lades65141272lades
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lards65331862lards
laree56036292laree
larees65323112larees
larges74824232larges
laris54737462laris
larks95227812larks
lars46956572lar_s
lases54944762lases
laves86039152laves
laxes125430092laxes
lazes145129572lazes
leers54828982leers
lees45455882l_ees
leges64427292leges
lenes54738522lenes
leones64417722leones
les35663072l__es
leses54930812leses
lexes127225262lexes
liers55130402liers
lies46454192l_ies
likes96231902likes
limes75636502limes
lines57054572lines
liras56021982liras
lire47845292lire_
litres65220392litres
lives86133192lives
livres94311862livres
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
loaves94813852loaves
lobe65535362lobe_
lobed86022132lobed
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
locks115126922locks
locoes85516582locoes
locos75822602locos
locus74819992locus
lode56240112lode_
loden66621142loden
lodens74315062lodens
lodges86820152lodges
loess55714702loess
lofts85518362lofts
loge56837192loge_
logos67225332logos
logs57343112lo_gs
loids66220702loids
loins56728422loins
lolls512121732lolls
lone45849132lone_
loner55431042loner
loners64225812loners
longes75925572longes
longs65527062longs
looed64626132looed
looey84822912looey
looeys95110122looeys
loofs85623782loofs
looies65025832looies
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122lo_os
loose56627682loose
looses67328242looses
loots55431422loots
lope65941922lope_
loped85128332loped
loper75129232loper
lopers84424142lopers
lops66043352lo_ps
loral55927822loral
loran55925092loran
lorans65117602lorans
lord55032082lor_d
lorded84916732lorded
loreal63814312loreal
lorises73918592lorises
lorn46435252lor_n
lorries74518352lorries
lorry86315672lorry
lory75931712lor_y
lose45144582lose_
losel54419422losel
losels64714582losels
loser54728672loser
losers65123582losers
loss45337962lo_ss
losses65925232losses
lotas55926302lotas
lotos54724632lotos
lots47652092lo_ts
lottes65322752lottes
lotus55718062lotus
louies64525102louies
louis57322322louis
loupes84918052loupes
loups75319622loups
loured74617402loured
lours55125292lours
louse56131012louse
louses66230282louses
louts56330272louts
louvres10356522louvres
love75234762love_
loved95021362loved
lover85526452lover
lovers94223432lovers
lowe75435312lowe_
lowed95233902lowed
lower85830412lower
lowers94624922lowers
lowest93915592lowest
lows75843012lo_ws
lowse87219902lowse
loxed135017052loxed
lubes74727992lubes
luces75528432luces
lucres84513302lucres
ludes65728852ludes
lues45943552l_ues
luges65928752luges
lunes55337772lunes
lure45142462lure_
lured65427492lured
lurer54625312lurer
lurers64217492lurers
lurex124816732lurex
lurks95218742lurks
lutes55836662lutes
luxes124921502luxes
lyes75530832l_yes
lyre75623792lyre_
lyses84518252lyses
mares76457632mares
meres75143572meres
mires75640882mires
modes85537412modes
moires8915632moires
mokes114631032mokes
moles74747922moles
momes95134472momes
mopes95134982mopes
moras76438782moras
more67154522more_
morel75729092morel
morels84820012morels
morns75527442morns
mors65950062mor_s
morse76032702morse
morts75533562morts
motes75944002motes
moues75732842moues
moves106128422moves
mures75937222mures
nares55544152nares
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noris54928272noris
norms76019312norms
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
ogres65818632ogres
okes84936342_okes
oles46453472_oles
ones46146532_ones
oozes145418712oozes
opes65942612_opes
orbs66626252_orbs
orcs67025432_orcs
ore36661832_ore_
orles55326212_orles
ors35750112_or_s
orts46538332_orts
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pares77164482pares
peres76246642peres
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pore66451262pore_
pored85234512pored
porks115124142porks
porns75527342porns
ports75934592ports
poses74642762poses
poxes145325722poxes
pyres105523882pyres
rares55247442rares
res35565042__res
robes75133302robes
rodes614039082rodes
roes45954142ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scores84725922scores
seres55448892seres
shores94830412shores
sires55945372sires
sloes54728872slo_es
slopes84820452slopes
snores64324322snores
sokes95031422sokes
soles55547922soles
sones55444142sones
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sore47059532sore_
sored66141782sored
sorel56231442sorel
sorels63921162sorels
sorer56236592sorer
sorest65028002sorest
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
splores91910952splores
spores84726612spores
stores65533662stores
tares57456562tares
tires55437492tires
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
toras55540372toras
torcs75123762torcs
tore47359322tore_
tories65435882tories
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torse55833332torse
torses64727952torses
tortes64826052tortes
torts56138122torts
torus54329762torus
totes55139682totes
tres46542902_tres
tsores65113662tsores
tyres84725232tyres
vires84529682vires
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wares88250582wares
whores125617102whores
wires86034912wires
woes76440662wo_es
words95425072words
wore77144672wore_
works125621902works
worms105320762worms
worse86525262worse
worses95522952worses
worts88631182worts
yokes125223022yokes
yore76335942yore_
yowes114926372yowes
zones145528042zones
zoris145320012zoris

Search took 5 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 Filter178691538000.300595636.7
2DLD Change Limit538004583.90613773.7
3Display Results4584580.2501832.0
 (SQL Overall)1786914584.45640101.2
 
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.