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

223 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
moors7492314(None) 
boors74325011boors
doors65022131doors
moods85224621moods
mools76027171mools
moons75331001moons
moor66628551moor_
moory105115791moory
moos66051301moo_s
moots75831661moots
mors65950061m_ors
motors84616601motors
amours83512662amours
boars75229602boars
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boor66130682boor_
boos67955032boo_s
boots75837972boots
coirs75221052coirs
colors86622372colors
cooers84324562cooers
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492coo_s
coots75636842coots
cors66656442_cors
doers65225712doers
dolors75115312dolors
donors75115792donors
dooms85321342dooms
door56928512door_
dorrs65520592dorrs
dors56747602_dors
floors94112352floors
foods95924162foods
fools86824202fools
foots85528282foots
fours85521492fours
goers65520252goers
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912goo_s
hoars85925552hoars
hoers85724922hoers
honors94816792honors
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoots84830252hoots
hours85422392hours
kooks85217262kooks
kors85933012_kors
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122loo_s
loots55431422loots
lours55125292lours
maars74621632maars
mairs76228302mairs
majors154511092majors
manors84420882manors
mars66261872m_ars
mayors115714192mayors
meous76120062meous
meows104612682meows
mhos95517772mho_s
minors85117102minors
mirs66940572m_irs
moans74624372moans
moas65545342m_oas
moats75827642moats
mobs85737372m_obs
mocks135023822mocks
mocs85834902m_ocs
modes85537412modes
mods77945052m_ods
modus85417202modus
mogs75439332m_ogs
mohurs1135932mohurs
moils76125752moils
moira71012022moira
moire71017322moire
moires8915632moires
mojoes15399522mojoes
mojos145314462mojos
mokes114631032mokes
molars85517322molars
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572m_ols
molts76032092molts
momes95134472momes
moms86539482m_oms
momus96116112momus
monas74732152monas
monks116123392monks
monos75930862monos
mons68152262m_ons
moo58460512moo__
mooch125313612mooch
mood76332062moo_d
moody115017492moody
mooed85123982mooed
mool67533862moo_l
moola75117032moola
moolas83615592moolas
moon67140812moo_n
mooners94015342mooners
moony104818272moony
moored93814172moored
moorish123311782moorish
moose76327192moose
moot67653622moo_t
mooters93818622mooters
mopers104220372mopers
mopes95134982mopes
mops85940132m_ops
mor56855002m_or_
mora66641272m_ora
moras76438782moras
more67154522m_ore
mores76249642mores
morn66237562m_orn
morns75527442morns
moron76925422moron
morons84919542morons
morose85116242morose
morris83814732morris
morro73216952morro
morros83714672morros
morse76032702m_orse
mort66758832m_ort
morts75533562morts
mos57067122m_o_s
mosks116117002mosks
moss67641032m_oss
mosts76028542mosts
motes75944002motes
moths106021552moths
motor75317292motor_
mots66853162m_ots
motts76527002motts
moues75732842moues
mourn77215012mourn
mourns84111012mourns
movers115117192movers
moves106128422moves
mowers113219402mowers
mows96340832m_ows
moxas145014392moxas
mozos165516332mozos
mucors104410852mucors
muons75816172muons
murrs75521302murrs
noirs55615462noirs
nooks95420392nooks
noons54125282noons
oars46846032_oars
odors64514282odors
omers76923192omers
oohs75220692_oohs
oops65232672_oops
oots46446442_oots
ors35750112__ors
ours47237562_ours
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poor65630222poor_
poori74816232poori
pooris83916842pooris
poos65949112poo_s
pours74623182pours
roars55622242roars
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
rotors64917952rotors
soars54732512soars
sooks94425452sooks
soots55536212soots
sopors85215202sopors
sours55230502sours
spoors84014032spoors
tools55325242tools
toons55027532toons
toots55331872toots
toros54336192toros
torrs53923562torrs
tors46157382_tors
tours55325892tours
unmoors945902unmoors
woods95723032woods
wooers93712442wooers
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802woo_s
yours85217882yours
zooks184716942zooks
zooms164415522zooms
zoons144919692zoons
zoos135828802zoo_s

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.313570897.8
2DLD Change Limit538002231.56334421.0
3Display Results2232230.0633539.7
 (SQL Overall)1786912231.93992156.3
 
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.