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

246 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
lower8583041(None) 
blower115316571blower
bower107328181bower
cower104531771cower
dower95027701dower
flower124815501flower
glower105114931glower
loner55431031loner
loper75129231loper
loser54728671loser
lover85526451lover
lowe75435311lowe_
lowed95233901lowed
lowers94624921lowers
lowery124112701lowery
lowes85732461lowes
mower104523451mower
plower114315061plower
power105325951power
rower85430491rower
slower94016151slower
sower85229311sower
tower85729201tower
vower115220791vower
avower1236822avower
blowed125016692blowed
blowers124313592blowers
blowier1248942blowier
boner75133082boner
borer75131272borer
bowed114533422bowed
bowel105621202bowel
bowers115523702bowers
bowery146012112bowery
bowler114217312bowler
bowyer14368922bowyer
boxer145016522boxer
clawer114512782clawer
cloner84418092cloner
closer84918202closer
clover114617122clover
clowder13367932clowder
coder86134212coder
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
cover105430772cover
cowed115637842cowed
cowers114625532cowers
cowier113616162cowier
coyer105222842coyer
crower114117552crower
doer57734702do_er
doper86128392doper
doser66228562doser
doter65428622doter
dowed104632612dowed
dowel95618192dowel
dowers104523292dowers
dowery134311662dowery
downer104414922downer
dowser104716082dowser
dozer158419272dozer
eloper85414152eloper
ewer77523982_ewer
fewer115216122fewer
flowed133513762flowed
flowers133413172flowers
flowery16327782flowery
fowler123712582fowler
foyer116416552foyer
glover104513532glover
glowed114913832glowed
glowers113412092glowers
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025152goner
grower104614932grower
hewer115719932hewer
hoer76533982ho_er
homer105828452homer
honer85332092honer
hoper105829142hoper
hoser811529762hoser
hover115524132hover
howe106734102howe_
howes114730262howes
howler123514312howler
joker165715892joker
jowar155211432jowar
jowed164724422jowed
knower1337072knower
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
laser54633322laser
later54843922later
laver85031792laver
lawed96028322lawed
lawyer12386972lawyer
laxer125420332laxer
layer84626472layer
leer46239352l_eer
leger65721502leger
leper74820742leper
lever85125162lever
lewder10479612lewder
liber74723612liber
lier45942462l_ier
lifer85822152lifer
liger65024462liger
liker95627062liker
liner55938912liner
liter54736342liter
liver85132962liver
loader74316302loader
loafer93610942loafer
loaner64416502loaner
lobar7313012lobar
lobber104016592lobber
lobe65535362lobe_
lobed86022132lobed
lobes75331002lobes
locker124019422locker
lode56240112lode_
loden66621142loden
lodes66436912lodes
lodger86517682lodger
lofter94614722lofter
loge56837192loge_
loges66534202loges
logger86420002logger
logier75015732logier
loiter64619172loiter
loller63315282loller
lone45849132lone_
loners64225802loners
longer75823192longer
looed64626132looed
looey84822912looey
looker104816952looker
looper83817112looper
looser65219942looser
looter64222322looter
lope65941922lope_
loped85128332loped
lopers84424142lopers
lopes76437342lopes
lopper103717202lopper
lore45850352lore_
lores55045402lores
lose45144582lose_
losel54419422losel
losers65123582losers
loses56742012loses
lotter64025602lotter
louder74414602louder
lour45430682lo_ur
louver94110392louver
love75234762love_
loved95021362loved
lovers94223432lovers
loves85332012loves
low66051872low__
lowered112711912lowered
lowest93915592lowest
lowlier10338902lowlier
lowly114113332lowly
lown76929292low_n
lows75843012low_s
lowse87219902lowse
loxed135017052loxed
loxes125227472loxes
luger65322082luger
lurer54625312lurer
lwei75312642l_wei
moper94925922moper
mover104220862mover
mowed113629012mowed
mowers113219402mowers
newer85717462newer
noter55025642noter
older65121172older
omer67028392_omer
over77227342_over
owe67041032_owe_
owed86833872_owed
owes75137102_owes
owner84613312_owner
oyer75927652_oyer
pawer104422972pawer
plover115312612plover
plowed124213202plowed
plowers123812242plowers
poker115122882poker
poler74431792poler
poser75128772poser
powder123611902powder
powers113822322powers
powter114116032powter
prower114218122prower
rawer84623732rawer
roger64521412roger
roper75431912roper
rover85527372rover
rowed94034322rowed
rowel84721412rowel
rowen84921152rowen
rowers94924572rowers
sawer85026212sawer
sewer84426212sewer
shower124315102shower
sloper84615912sloper
slowed104617072slowed
sober74822402sober
sorer56236572sorer
sowar85821342sowar
sowed94933862sowed
sowers94923432sowers
tawer85223442tawer
toker95924912toker
toner55336242toner
toper75231022toper
toter55932132toter
towed95134582towed
towel84920522towel
towers94423672towers
towery124012092towery
toyer84521552toyer
vomer105517382vomer
voter85121052voter
vowed124424572vowed
vowel115515012vowel
vowers124317182vowers
wooer84316692wooer
wowed124023772wowed
wowser125110202wowser
yowe106728742yowe_
yowed1253025182yowed
yowes114926372yowes
yowler123310042yowler
zoner144520342zoner

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.0931921408.6
2DLD Change Limit538002461.75030742.9
3Display Results2462460.0633904.8
 (SQL Overall)1786912461.90693751.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.