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

173 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
moorages113905(None) 
moorage1038741moorage_
borages103917162_borages
courages11311392courages
floorages1364982floorages
footages1239052footages
forages114217282_forages
mirages102213532m_irages
montages111412182montages
morales93619402m_orales
moulages1138052moulages
rootages939102rootages
storages9311102storages
amperages1447683amperages
averages1249183averages
barrages11711083barrages
bondages1237893bondages
boraces113716853_boraces
borage93917013_borage_
boranes93720403_boranes
borates94823013_borates
boraxes163511633_boraxes
boscages1366643boscages
boskages1565423boskages
brokages1536253brokages
buoyages1443803buoyages
choragus1474303choragus
chorales133712883chorales
coinages11310803coinages
collages113514243collages
comrades13149773comrades
cooperages1565583cooperages
cordages12310113cordages
corkages1539103corkages
corrades111211263corrades
corsages11310363corsages
cottages113310493cottages
courage10310993courage_
coverages1538833coverages
cowages13310943_cowages
cowhages1736113cowhages
dockages1635983dockages
dosages92310803_dosages
dotages92311793_dotages
ecotages1136973ecotages
enrages83114853_enrages
floorage1275093floorage_
flotages1237163flotages
flowages1535733flowages
foggages1434213foggages
foliages1247623foliages
footage1148843footage_
footraces1446713footraces
forage104617003_forage_
foraged124812283_foraged
forager114412563_forager
foragers12349633_foragers
forges105024263_for_ges
fromages1437073fromages
garages9314113_garages
goorals838703goora_ls
gorges85321893_gor_ges
homages131011583_homages
hoorahed1545093hoorahed
hoorahs13399603hoora_hs
hoorayed1544013hoorayed
hoorays13418373hoora_ys
hostages122311693hostages
lockages1536723lockages
lovages1138033_lovages
macrames1438953macrames
madrases112610003madrases
mages85036023m___ages
manages103418963m_anages
marges94525713m_ar_ges
marriages1247383marriages
massages1159883massages
meltages1148243meltages
menages103615393m_enages
merges94122493m_er_ges
messages1138233messages
metages102714973m_etages
meterages1248183meterages
midranges1344653midranges
migrates111112853migrates
milages103114403m_ilages
mileages11249693mileages
millages113212903millages
mintages111110513mintages
mirage92313653m_irage_
mispages13311183mispages
misrates101318243misrates
moderates12710753moderates
moires8915633moir__es
monades103713823m_onades
monorails1148743monorails
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
mooches143714453moo_ches
moolahs12347383moola_hs
moolas83615593moola__s
mooneyes1396113mooneyes
moonrises1146723moonrises
moored93814173moor__ed
moorhen1236023moor_hen
moorhens1344853moorhens
moorier93113073moor_ier
mooriest102812723moor_iest
moorings11257713moorings
moorlands1244203moorlands
moors74923143moor___s
morae75831193m_ora_e_
moraines10314363m_oraines
morale85220553m_orale_
morals85324633m_ora_ls
moras76438783m_ora__s
morass84614503m_ora_ss
morasses1038903m_orasses
morays114613883m_ora_ys
mores76249643m_or__es
morgans10310123m_organs
morgen9312203m_or_gen
morgens10310463m_or_gens
morgues1038273m_orgues
morrises10711073morrises
mortgages1344023mortgages
motorcades1543773motorcades
motorises11311673motorises
motorizes20410783motorizes
moulage1037903moulage_
nonages8313843_nonages
noodges9317713noo_dges
ohmages13115093_ohmages
ooralis7312553_ooralis
oranges84215333__oranges
orates64328613__orates
outages82317323_outages
outrages92215933outrages
overages12513833overages
peerages1189893peerages
peonages1138473peonages
phorates13413043phorates
portages112613223portages
postages112815323postages
potages102416423_potages
pottages112910453pottages
prorates10418073prorates
rages64539443___rages
rootage839053rootage_
shortages1336513shortages
soakages1336143soakages
socages101012053_socages
soccages1336383soccages
soilages9189673soilages
sororates9410473sororates
storage8310473storage_
storaxes1536883storaxes
stowages1236473stowages
thoraces13118943thoraces
thoraxes1896363thoraxes
tollages92410193tollages
tonnages9187873tonnages
towages1139233_towages
tutorages1045773tutorages
umbrages1336623umbrages
umpirages1443343umpirages
voltages1237253voltages
vorlages1236033vorlages
voyages1435703_voyages
wooralis1145803wooralis
wooraris1145063wooraris
wordages1337053wordages

Search took 9 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 Filter1786911461620.546327272.9
2DLD Change Limit1461621737.86018595.7
3Display Results1731730.1561109.0
 (SQL Overall)1786911738.56220870.2
 
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.