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

197 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
meltages114824(None) 
meltage1037951meltage_
metages102714971me_tages
helotages1346122helotages
maltases1039692maltases
melanges1138612melanges
menages103615392me_nages
messages1138232messages
metage93114452me_tage_
metates92720002me_tates
milages103114402mil_ages
mileages11249692mileages
millages113212892millages
mintages111110512mintages
montages111412182montages
pelages10714612pel_ages
restages92815762restages
selvages1236512selvages
septages1168262septages
tentages91011042tentages
ventages12119762ventages
voltages1237252voltages
anlages82414103anl_ages
beldames1336803beldames
betakes134212523be_takes
bulkages1535273bulkages
cartages11313313cartages
centares102913893centares
cetanes9315133ce_tanes
collages113514233collages
cottages113310493cottages
cuttages11297223cuttages
delates83526283del_ates
deleaves1248063deleaves
deltas74414823delta__s
deluges9169263del_uges
dotages92311793_dotages
ecotages1136973ecotages
ectases92911673_ectases
elates65032363_el_ates
eluates72014673_eluates
encages103313783_encages
engages92912493_engages
enrages83114853_enrages
entases72816273_entases
estates74520173_estates
etapes85415293_e_tapes
fellates11312753fellates
flotages1237163flotages
foliages1247623foliages
footages1239053footages
gelates83219583gel_ates
geotaxes1644743geotaxes
gestates93213723gestates
hectares1338853hectares
hektares1535813hektares
helotage1245713helotage_
heptanes1339003heptanes
herbages1437083herbages
heritages1346713heritages
hostages122311693hostages
jetlags1533863jetlag_s
keelages1335743keelages
leafages1244623leafages
leakages1334933leakages
mages85036023m___ages
malates93522603mal_ates
maleates103316343maleates
maltase938903maltase_
maltoses1039853maltoses
manages103418963m_anages
massages1159883massages
meager94515193me__ager
mealtimes1345243mealtimes
meatuses1038203meatuses
mediates112814063mediates
meditates1239813meditates
melamed1249633mel_amed
melange1038363melange_
melees83618083mel__ees
melodies11310123melodies
meltable12310473meltable
melted94219063melt__ed
melter83520113melt__er
melters93918313melt_ers
meltons9410923melt_ons
melts74930103melt___s
meltwater1443433meltwater
meltwaters1542963meltwaters
menaces112715523me_naces
menage93216543me_nage_
meninges1137433meninges
mentalese1146323mentalese
mentees93214503ment_ees
merges94122483me__rges
mesdames1346043mesdames
message1037833message_
messaged1235543messaged
messuages1244393messuages
mestees94617753mest_ees
metaled102913873me_taled
metals84520883me_ta_ls
metamer1139613me_tamer
metamers1249623me_tamers
metatags1144693metatag_s
metate82720533me_tate_
meterages1248173meterages
metes74736213me_t__es
methanes133812163methanes
metopes11311363me_topes
metres85121563me_t_res
mettles94115023me_ttles
milage93414123mil_age_
mileage10299313mileage_
militates11310883militates
millage103112743millage_
mintage101110123mintage_
mirages102213533m_irages
mispages13311183mispages
mistakes141213403mistakes
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
moorages1139053moorages
mortgages1344023mortgages
moulages1138053moulages
multiage1147983multiage_
multures1039333multures
mutagen1056603m_utagen
mutagens1144853m_utagens
mutases92012043m_utases
mutates92215793m_utates
outages82317323_outages
peages94321843pe__ages
pectases122411193pectases
pectates122213943pectates
peerages1189883peerages
pelage9515363pel_age_
peltasts1035703peltasts
peltate92013773peltate_
peltries10313023peltries
pentanes10316073pentanes
peonages1138473peonages
pillages113012603pillages
pilotages1245503pilotages
plages94520153_pl_ages
portages112613223portages
postages112815323postages
potages102416423_potages
pottages112910453pottages
reimages1138373reimages
relaces93420883rel_aces
relates73731423rel_ates
relaxes143215323rel_axes
releases8313343releases
restage83316183restage_
restaged103011853restaged
restates83423413restates
retags73414303re_tag_s
retakes113718863re_takes
retapes93917423re_tapes
retaxes143615093re_taxes
rootages939103rootages
salvages1238123salvages
scutages1136503scutages
seepages1137283seepages
selvage1136553selvage_
selvaged1334343selvaged
septage1078403septage_
serfages1238233serfages
sewages1139753se_wages
silages82514443sil_ages
smallages1245293smallages
stages75629493__stages
sullages939973sullages
tallages92312003tallages
telltales944393telltales
telotaxes1644643telotaxes
tentage81010643tentage_
testates83615443testates
tillages93011243tillages
tollages92410193tollages
ullages838953_ullages
unitages938273unitages
upstages11147373upstages
vantages12119023vantages
ventage11109623ventage_
vestiges1238243vestiges
villages123010593villages
vintages12118273vintages
voltage1136863voltage_
waftages15105393waftages
wantages12109023wantages
wastages12109753wastages
wattages12106783wattages
webpages1643053webpages
welfares1445543welfares

Search took 10 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.1561145455.1
2DLD Change Limit1461621979.14015991.5
3Display Results1971970.0762592.1
 (SQL Overall)1786911979.37219066.5
 
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.