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
moorages113904(None) 
moorage1038731moorage_
borages103917162_borages
courages11311392courages
floorages1364972floorages
footages1239042footages
forages114217272_forages
mirages102213532m_irages
montages111412182montages
morales93619402m_orales
moulages1138052moulages
rootages939092rootages
storages9311102storages
amperages1447673amperages
averages1249183averages
barrages11711083barrages
bondages1237893bondages
boraces113716853_boraces
borage93917013_borage_
boranes93720403_boranes
borates94823013_borates
boraxes163511633_boraxes
boscages1366643boscages
boskages1565423boskages
brokages1536253brokages
buoyages1443803buoyages
choragus1474293choragus
chorales133712873chorales
coinages11310803coinages
collages113514233collages
comrades13149773comrades
cooperages1565573cooperages
cordages12310113cordages
corkages1539103corkages
corrades111211263corrades
corsages11310363corsages
cottages113310493cottages
courage10310993courage_
coverages1538833coverages
cowages13310933_cowages
cowhages1736103cowhages
dockages1635983dockages
dosages92310803_dosages
dotages92311793_dotages
ecotages1136973ecotages
enrages83114853_enrages
floorage1275083floorage_
flotages1237153flotages
flowages1535733flowages
foggages1434213foggages
foliages1247623foliages
footage1148833footage_
footraces1446703footraces
forage104616993_forage_
foraged124812273_foraged
forager114412553_forager
foragers12349623_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
merges94122483m_er_ges
messages1138233messages
metages102714973m_etages
meterages1248173meterages
midranges1344653midranges
migrates111112843migrates
milages103114403m_ilages
mileages11249693mileages
millages113212893millages
mintages111110513mintages
mirage92313653m_irage_
mispages13311183mispages
misrates101318223misrates
moderates12710743moderates
moires8915633moir__es
monades103713823m_onades
monorails1148723monorails
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
mooches143714453moo_ches
moolahs12347373moola_hs
moolas83615583moola__s
mooneyes1396113mooneyes
moonrises1146723moonrises
moored93814173moor__ed
moorhen1236023moor_hen
moorhens1344843moorhens
moorier93113073moor_ier
mooriest102812723moor_iest
moorings11257683moorings
moorlands1244203moorlands
moors74923143moor___s
morae75831193m_ora_e_
moraines10314343m_oraines
morale85220553m_orale_
morals85324633m_ora_ls
moras76438763m_ora__s
morass84614493m_ora_ss
morasses1038903m_orasses
morays114613883m_ora_ys
mores76249643m_or__es
morgans10310123m_organs
morgen9312203m_or_gen
morgens10310463m_or_gens
morgues1038273m_orgues
morrises10711063morrises
mortgages1344023mortgages
motorcades1543773motorcades
motorises11311663motorises
motorizes20410773motorizes
moulage1037903moulage_
nonages8313843_nonages
noodges9317703noo_dges
ohmages13115093_ohmages
ooralis7312553_ooralis
oranges84215333__oranges
orates64328613__orates
outages82317323_outages
outrages92215923outrages
overages12513833overages
peerages1189883peerages
peonages1138473peonages
phorates13413043phorates
portages112613223portages
postages112815323postages
potages102416423_potages
pottages112910453pottages
prorates10418063prorates
rages64539443___rages
rootage839043rootage_
shortages1336513shortages
soakages1336143soakages
socages101012053_socages
soccages1336383soccages
soilages9189673soilages
sororates9410463sororates
storage8310473storage_
storaxes1536883storaxes
stowages1236473stowages
thoraces13118933thoraces
thoraxes1896353thoraxes
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.346516448.0
2DLD Change Limit1461621738.28017652.4
3Display Results1731730.0802162.5
 (SQL Overall)1786911738.70620525.0
 
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.