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

381 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
lopes7643734(None) 
copes97747101copes
dopes84935041dopes
elopes85918161elopes
hopes105835641hopes
lobes75331001lobes
lodes66436911lodes
loges66534201loges
lope65941921lope_
loped85128331loped
loper75129231loper
lopers84424141lopers
lops66043351lop_s
lores55045401lores
loses56742011loses
loupes84918051loupes
loves85332011loves
lowes85732461lowes
loxes125227471loxes
mopes95134981mopes
opes65942611_opes
popes95933811popes
ropes75940061ropes
slopes84820451slopes
topes76941761topes
aloes54933672alo_es
apes66047432_apes
blokes123813882blokes
blypes13357542blypes
bodes84935102bodes
boles75448602boles
bones76446532bones
bops86037982bop_s
bores76448252bores
boxes145625072boxes
capes95441922capes
cepes94424462cepes
clepes104214622clepes
clones84526562clones
clops95924852clop_s
closes85425592closes
cloves114918822cloves
clozes174915562clozes
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
cope86847382cope_
coped105036842coped
copen94826432copen
copens106119962copens
coper95336092coper
copers104629842copers
copies104130302copies
cops86751372cop_s
copse95623922copse
copses104922472copses
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopas85019062dopas
dope76038892dope_
doped95326712doped
doper86128392doper
dopers95522482dopers
dopey116020352dopey
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dupes86425932dupes
elope75219342elope_
eloped95914142eloped
eloper85414152eloper
elopers95112942elopers
floes85528142flo_es
flops105920142flop_s
foes76543442fo_es
fops96532682fop_s
fores85847102fores
foxes156321092foxes
gapes86030822gapes
globes94314542globes
glops85619552glop_s
gloves104115182gloves
glozes164313352glozes
goes55644092go_es
gores65740372gores
goxes135018262goxes
gropes95220402gropes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopers114222972hopers
hops97942632hop_s
hoses85443172hoses
howes114730262howes
hypes135818672hypes
japes146322822japes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
jupes145218552jupes
kopek1037812kopek
kopeks1134602kopeks
kophs145010932kophs
kopjes1935362kopjes
kops107031292kop_s
laces76141762laces
lades65141272lades
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lapel73716682lapel
lapels83712042lapels
lapis76223152lapis
laps66848872lap_s
lapse74917682lapse
lapses85217692lapses
lares54852632lares
lases54944762lases
laves86039152laves
laxes125430092laxes
lazes145129572lazes
lees45455882l_ees
leges64427282leges
lenes54738522lenes
leones64417722leones
leper74820742leper
lepers84817322lepers
les35663072l__es
leses54930812leses
lexes127225262lexes
lies46454192l_ies
likes96231902likes
limes75636502limes
lines57054572lines
lipe66839732lipe_
lips67141442lip_s
lives86133192lives
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
loaves94813852loaves
lobe65535362lobe_
lobed86022132lobed
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
locks115126922locks
locoes85516582locoes
locos75822602locos
locus74819992locus
lode56240112lode_
loden66621142loden
lodens74315062lodens
lodges86820142lodges
loess55714702loess
lofts85518362lofts
loge56837192loge_
logos67225332logos
logs57343112lo_gs
loids66220702loids
loins56728422loins
lolls512121732lolls
lone45849132lone_
loner55431042loner
loners64225812loners
longes75925572longes
longs65527062longs
looed64626132looed
looey84822912looey
looeys95110122looeys
loofs85623782loofs
looies65025832looies
looks95124862looks
looms75124642looms
loons55731722loons
looped95217172looped
looper83817112looper
loopers93914032loopers
loops75723962loops
loos49051122lo_os
loose56627682loose
looses67328242looses
loots55431422loots
lop58255312lop__
lopped114218622lopped
lopper103717202lopper
loppers113014102loppers
loppy125911662loppy
lords64923502lords
lore45850352lore_
lories64933042lories
loris55329152loris
lose45144582lose_
losel54419422losel
losels64714582losels
loser54728672loser
losers65123582losers
loss45337962lo_ss
losses65925232losses
lotas55926302lotas
lotos54724632lotos
lots47652092lo_ts
lottes65322752lottes
lotus55718062lotus
louies64525102louies
louis57322322louis
loupe75319512loupe_
louped95316382louped
loupen84510292loupen
loups75319622loups
lours55125292lours
louse56131012louse
louses66230282louses
louts56330272louts
love75234762love_
loved95021362loved
lover85526452lover
lovers94223432lovers
lowe75435312lowe_
lowed95233902lowed
lower85830412lower
lowers94624922lowers
lowest93915592lowest
lows75843012lo_ws
lowse87219902lowse
loxed135017052loxed
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552l_ues
luges65928752luges
lunes55337772lunes
lupus74512522lupus
lures56138532lures
lutes55836662lutes
luxes124921502luxes
lyes75530832l_yes
lyres85019962lyres
lyses84518252lyses
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
mope86838042mope_
moped105424732moped
mopeds11499662mopeds
moper94925922moper
mopers104220372mopers
mopey124821822mopey
mops85940132mop_s
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
myopes13419962myopes
napes74828462napes
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
nope65934192nope_
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oops65232672oop_s
oozes145418712oozes
ope56845242_ope_
oped76230152_oped
open66427002_open
opens76118552_opens
ops56641252_op_s
opts68124742_opts
opus66420592_opus
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pes57259782__pes
pipes96030142pipes
plops95920332plop_s
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
pope85535612pope_
pops86340952pop_s
pores75849032pores
poses74642762poses
poxes145325722poxes
qophs19507812qophs
rapes75740722rapes
ripes75435772ripes
robes75133302robes
rodes614039082rodes
roes45954142ro_es
roles56747982roles
rope65542912rope_
roped84630802roped
roper75431912roper
ropers84325902ropers
ropey106021872ropey
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scopes104719592scopes
sipes76036952sipes
slipes84921412slipes
sloes54728872slo_es
slope75823562slope_
sloped94216852sloped
sloper84615912sloper
slopers94213092slopers
slops75026012slop_s
slypes114410482slypes
sokes95031422sokes
soles55547922soles
sones55444142sones
sophs104916022sophs
sops65244562sop_s
sores55454282sores
stopes84525892stopes
supes75628302supes
tapes75838602tapes
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
tope65946382tope_
toped85631312toped
topee76029952topee
topees85519702topees
toper75231022toper
topers85025322topers
tophes115218422tophes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122top_s
tores55352672tores
totes55139682totes
tropes84824352tropes
types105721062types
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wipes104827082wipes
woes76440662wo_es
wops96634152wop_s
yipes106017842yipes
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

Search took 2 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.0802233637.5
2DLD Change Limit538003811.71631352.0
3Display Results3813810.0934096.8
 (SQL Overall)1786913811.88994595.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.