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

369 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
lowes8573246(None) 
howes114730261howes
lobes75331001lobes
lodes66436911lodes
loges66534201loges
lopes76437341lopes
lores55045401lores
loses56742011loses
loves85332011loves
lowe75435311lowe_
lowed95233901lowed
lower85830411lower
lowers94624921lowers
lowest93915591lowest
lows75843011low_s
lowse87219901lowse
loxes125227471loxes
owes75137101_owes
yowes114926371yowes
aloes54933672alo_es
awes76037552_awes
blokes123813882blokes
blowed125016692blowed
blower115316572blower
blowers124313592blowers
blows105423832blow_s
bodes84935102bodes
boles75448602boles
bones76446532bones
bores76448252bores
bowed114533422bowed
bowel105621202bowel
bowels114315592bowels
bower107328182bower
bowers115523702bowers
bowls106121432bowls
bows96242862bow_s
bowse105420632bowse
bowses115718862bowses
boxes145625072boxes
clones84526562clones
closes85425592closes
cloves114918822cloves
clowns114810112clowns
clozes174915562clozes
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coves105539172coves
cowed115637842cowed
cower104531772cower
cowers114625532cowers
cowls106922212cowls
cows97046642cow_s
coxes145430862coxes
cozes166033242cozes
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
dowed104632612dowed
dowel95618192dowel
dowels104813342dowels
dower95027702dower
dowers104523292dowers
downs94918572downs
dows85941052dow_s
dowse96020812dowse
dowses105718302dowses
dozes155226302dozes
elopes85918162elopes
ewes76328702_ewes
floes85528142flo_es
flowed133513762flowed
flower124815502flower
flowers133413172flowers
flows115822362flow_s
foes76543442fo_es
fores85847102fores
fowls115518892fowls
foxes156321092foxes
globes94314542globes
gloves104115182gloves
glowed114913832glowed
glower105114932glower
glowers113412092glowers
glows95518032glow_s
glozes164313352glozes
goes55644092go_es
gores65740372gores
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
hoses85443172hoses
howe106734102howe_
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602how_s
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
jowed164724422jowed
jowls156214522jowls
jows146632092jow_s
laces76141762laces
lades65141272lades
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lares54852632lares
lases54944762lases
laves86039152laves
lawed96028322lawed
lawns85215422lawns
laws76441682law_s
laxes125430092laxes
lazes145129572lazes
lees45455882l_ees
leges64427282leges
lenes54738522lenes
leones64417722leones
les35663072l__es
leses54930812leses
lewis85315842lewis
lexes127225262lexes
lies46454192l_ies
likes96231902likes
limes75636502limes
lines57054572lines
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
loops75723962loops
loos49051122lo_os
loose56627682loose
looses67328242looses
loots55431422loots
lope65941922lope_
loped85128332loped
loper75129232loper
lopers84424142lopers
lops66043352lo_ps
lords64923502lords
lore45850352lore_
lories64933042lories
loris55329152loris
lose45144582lose_
losel54419422losel
losels64714582losels
loser54728672loser
losers65123582losers
loss45337962lo_ss
losses65925232losses
lotas55926302lotas
lotos54724632lotos
lots47652092lo_ts
lottes65322752lottes
lotus55718062lotus
louies64525102louies
louis57322322louis
loupes84918052loupes
loups75319622loups
lours55125292lours
louse56131012louse
louses66230282louses
louts56330272louts
love75234762love_
loved95021362loved
lover85526452lover
lovers94223432lovers
low66051872low__
lowery124112712lowery
lowish12310532lowish
lowly114113332lowly
lown76929292low_n
lowness1037812lowness
loxed135017052loxed
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552l_ues
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
lwei75312642l_wei
lweis8458692l_weis
lyes75530832l_yes
lyres85019962lyres
lyses84518252lyses
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
mopes95134982mopes
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
mowed113629012mowed
mower104523452mower
mowers113219402mowers
mows96340832mow_s
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noses55435642noses
notes55034582notes
nows75738232now_s
nowts86915852nowts
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oozes145418712oozes
opes65942612_opes
ores46056682_ores
oses46641512_oses
owe67041032_owe_
owed86833872_owed
owls76022932_owls
owns76819582_owns
owse76321622_owse
oxes116530722_oxes
oyes74940132_oyes
plowed124213202plowed
plower114315062plower
plowers123812242plowers
plows105419902plow_s
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
power105325952power
powers113822322powers
pows95537662pow_s
poxes145325722poxes
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
rowed94034322rowed
rowel84721412rowel
rowels94515452rowels
rowen84921152rowen
rowens94515302rowens
rower85430492rower
rowers94924572rowers
rows75941752row_s
sloes54728872slo_es
slopes84820452slopes
slowed104617072slowed
slower94016152slower
slowest10168712slowest
slows85323462slow_s
sokes95031422sokes
soles55547922soles
sones55444142sones
sores55454282sores
sowed94933862sowed
sowens93613152sowens
sower85229312sower
sowers94923432sowers
sows75342492sow_s
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
totes55139682totes
towed95134582towed
towel84920522towel
towels94314642towels
tower85729202tower
towers94423672towers
towies93521192towies
towns86018882towns
tows78545552tow_s
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
vowed124424572vowed
vowel115515012vowel
vowels124410482vowels
vower115220792vower
vowers124317182vowers
vows106626942vow_s
woes76440662wo_es
wowed124023772wowed
wows104633492wow_s
yokes125223022yokes
yores85031322yores
yowe106728742yowe_
yowed1253025182yowed
yowies123913732yowies
yowls115715432yowls
yows106433122yow_s
zones145528042zones

Search took 3 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.1701051123.5
2DLD Change Limit538003691.94027732.0
3Display Results3693690.0933967.7
 (SQL Overall)1786913692.20381112.6
 
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.