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 “moorage” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

181 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
moorage103873(None) 
moorages1139041moorages
borage93917012_borage
courage10310992courage
floorage1275082floorage
footage1148832footage
forage104616992_forage
mirage92313652m_irage
montage101211712montage
morae75831192m_ora_e
morale85220552m_orale
moulage1037902moulage
rootage839042rootage
storage8310472storage
agorae7511203agora_e
amperage1347743amperage
average1158853average
barrage10710843barrage
bondage1138253bondage
borages103917163_borages
borane84620213_borane
borate85026153_borate
boscage1276533boscage
boskage1465413boskage
brokage1436673brokage
buoyage1344293buoyage
choragi1346683choragi
chorale124313353chorale
coinage10310553coinage
collage102813753collage
comrade12139213comrade
cooperage1465253cooperage
cordage11310063cordage
corkage1438373corkage
corrade101111043corrade
corsage1039803corsage
cottage104210573cottage
courages11311393courages
coverage1438733coverage
cowage12310663_cowage
cowhage1636293cowhage
dockage1535723dockage
dosage82810003_dosage
dotage82711613_dotage
ecotage1036883ecotage
enrage72715073_enrage
floorages1364973floorages
florae94713883flora_e
flotage1136673flotage
flowage1435723flowage
foggage1334113foggage
foliage1147533foliage
footages1239043footages
footrace1346403footrace
foraged124812273_foraged
forager114412553_forager
forages114217273_forages
forge95126943_for_ge
fromage1336753fromage
garage8314513_garage
gooral7310463goora_l
goorals838703goorals
gorge76423893_gor_ge
homage121210603_homage
hoorah124411113hoora_h
hoorahed1545093hoorahed
hoorahs13399603hoorahs
hooray123011373hoora_y
hoorayed1544013hoorayed
hoorays13418373hoorays
hostage113111233hostage
lockage1436613lockage
lovage1037353_lovage
macrame1338713macrame
mage75739123m___age
manage93818903m_anage
marge85328333m_ar_ge
marriage1147253marriage
massage1039893massage
meltage1037953meltage
menage93216543m_enage
merge84523683m_er_ge
message1037833message
metage93114453m_etage
meterage1147923meterage
midrange1244433midrange
migrate101314163migrate
milage93414123m_ilage
mileage10299313mileage
millage103112743millage
mintage101110123mintage
mirages102213533m_irages
mispage12310523mispage
misrate91319143misrate
moderate11710993moderate
moira71012013moira__
moirai886913moira_i
moire71017313moir__e
monorail1059773monorail
montaged12107763montaged
montages111412183montages
montane91313623montane
mooing93718373mooing_
moola75117033moola__
moolah11409193moola_h
moolahs12347383moolahs
moolas83615593moola_s
mooneye12116933mooneye
moonrise1046783moonrise
moor66628553moor___
moored93814173moor_ed
moorhen1236023moorhen
moorier93113073moorier
mooring102514443mooring
moorings11257693moorings
moorish123311783moorish
moorland1144683moorland
moors74923143moor__s
moory105115793moor__y
moose76327193moo__se
mora66641273m_ora__
moraine9314573m_oraine
moral75533433m_ora_l
morales93619403m_orales
morals85324633m_orals
moras76438763m_ora_s
morass84614493m_orass
moray105423793m_ora_y
morays114613883m_orays
more67154523m_or__e
morgan9311373m_organ
morgen9312203m_or_gen
morgue938113m_orgue
morose85116243m_orose
morse76032703m_or_se
mortgage1244213mortgage
motorcade1443933motorcade
motorise10311523motorise
motorize19410423motorize
moulages1138053moulages
nonage7313683_nonage
nonwage1137163nonwage
noodge8337573noo_dge
ohmage1295063_ohmage
oorali6311263_oorali
oorie53026363_oor_ie
orange74016323__orange
orate55133303__orate
outage72017533_outage
outrage82616883outrage
overage11514053overage
peerage1089803peerage
peonage1048723peonage
phorate12413363phorate
portage103013643portage
postage103214853postage
potage92715903_potage
pottage103310603pottage
prorate9418733prorate
rage55742353___rage
rootages939093rootages
shortage1236303shortage
soakage1236103soakage
socage91012123_socage
soccage1236283soccage
soilage8169353soilage
sororate8411173sororate
storages9311103storages
stowage1136703stowage
tollage82610163tollage
tonnage8168053tonnage
towage1039833_towage
tutorage945743tutorage
umbrage1236723umbrage
umpirage1343573umpirage
voltage1136863voltage
vorlage1136403vorlage
voyage1335473_voyage
woorali1045263woorali
woorari1044633woorari
wordage1236503wordage

Search took 8 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 Filter1786911340270.1601116818.8
2DLD Change Limit1340271817.14018771.3
3Display Results1811810.0603016.7
 (SQL Overall)1786911817.36024278.7
 
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.