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

183 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
mowers11321940(None) 
bowers115523701bowers
cowers114625531cowers
dowers104523291dowers
lowers94624921lowers
mopers104220371mopers
movers115117191movers
mower104523451mower_
powers113822321powers
rowers94924571rowers
sowers94923431sowers
towers94423671towers
vowers124317181vowers
avowers1336332avowers
blowers124313592blowers
boners84825432boners
borers85122682borers
bowels114315592bowels
bower107328182bower_
bowery146012112bowery
bowlers123715782bowlers
bowyers15438732bowyers
boxers155013482boxers
coders95426972coders
comers105328082comers
cooers84324562cooers
copers104629842copers
corers85231072corers
covers114627962covers
cower104531772cower_
crowers124614892crowers
doers65225712do_ers
dopers95522482dopers
dosers75723632dosers
doters74423912doters
dowels104813342dowels
dower95027702dower_
dowery134311662dowery
downers113912772downers
dowsers115013522dowsers
dozers164815422dozers
embowers15236452embowers
emoters94712872emoters
empowers15276842empowers
ewers86018822_ewers
flowers133413172flowers
fowlers133411202fowlers
foyers125413132foyers
glowers113412092glowers
goers65520252go_ers
gofers104711512gofers
gomers94116882gomers
goners74420172goners
growers113612722growers
hewers123715272hewers
hoers85724922ho_ers
homers114821972homers
honers94324972honers
hopers114222972hopers
hosers95223952hosers
hovers124320252hovers
howes114730262howe_s
howlers133312352howlers
imbowers15295092imbowers
impowers15296822impowers
jokers175511192jokers
jowars16369652jowars
knowers1436332knowers
loners64225812loners
lopers84424142lopers
losers65123582losers
lovers94223432lovers
lower85830412lower_
lowery124112712lowery
lowes85732462lowe_s
macers105321272macers
makers123921732makers
masers84623452masers
maters85032382maters
mazers173917092mazers
meters85625832meters
mewlers12288982mewlers
milers84625162milers
mimers105520182mimers
miners84126632miners
misers85025702misers
miters84328772miters
mixers154513562mixers
moaners92813552moaners
mobbers133610922mobbers
mockers153812942mockers
models94216352models
modems114610762modems
modern939522modern
moderns1037962moderns
modes85537412mode_s
mohels115011322mohels
mohurs1135932mohurs
moilers93615202moilers
moires8915632moires
mokes114631032moke_s
molars85517322molars
molders103315552molders
moles74747922mole_s
molters93816972molters
momes95134472mome_s
momsers113810842momsers
momzers20367132momzers
moneys115513622moneys
mongers104217272mongers
mooners94015342mooners
moors74923142mo_ors
mooters93818622mooters
mopeds11499662mopeds
moper94925922moper_
mopery135210972mopery
mopes95134982mope_s
moppers133412452moppers
morels84820012morels
mores76249642more_s
mors65950062mo__rs
moseys114711702moseys
moshers124017842moshers
mossers94116192mossers
motels83616892motels
motes75944002mote_s
motets84216192motets
mothers123717622mothers
motors84616592motors
moues75732842moue_s
mousers95216442mousers
mover104220862mover_
moves106128422move_s
mowed113629012mowe_d
mows96340832mow__s
musers84719092musers
noters64020992noters
ombers104214402ombers
omers76923192_omers
overs85224792_overs
owes75137102_owe_s
owners94210702_owners
oyers87620882_oyers
pawers114818782pawers
plowers123812242plowers
pokers124617922pokers
polers84225642polers
posers84223972posers
powders134111552powders
power105325952power_
powters124015652powters
rogers74517912rogers
ropers84325902ropers
rovers95423522rovers
rowels94515452rowels
rowens94515302rowens
rower85430492rower_
sawers94620162sawers
sewers94719712sewers
showers134612662showers
smokers13389322smokers
sobers85218852sobers
sowars94318002sowars
sowens93613152sowens
sower85229312sower_
tawers94118602tawers
tokers104818892tokers
toners64128002toners
topers85025322topers
toters65026362toters
towels94314642towels
tower85729202tower_
towery124012092towery
toyers95516332toyers
vomers115614942vomers
voters95017442voters
vowels124410482vowels
vower115220792vower_
wooers93712442wooers
wowsers13488752wowsers
yowes114926372yowe_s
yowlers13328922yowlers
zoners155115992zoners

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit825511832.98327673.8
3Display Results1831830.0762407.9
 (SQL Overall)1786911833.16956387.2
 
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.