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

210 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
meltage103795(None) 
meltages1148241meltages
metage93114451me_tage
helotage1245712helotage
maltase938902maltase
melange1038362melange
meltable12310472meltable
menage93216542me_nage
message1037832message
metages102714972me_tages
metate82720532me_tate
milage93414122mil_age
mileage10299312mileage
millage103112752millage
mintage101110122mintage
montage101211712montage
multiage1147982multiage
pelage9515362pel_age
peltate92013772peltate
restage83316192restage
selvage1136552selvage
septage1078402septage
tentage81010642tentage
ventage11109622ventage
voltage1136862voltage
anlage72514233anl_age
beldame1237233beldame
betake124512703be_take
bulkage1435703bulkage
cartage10312593cartage
cellae84915933cella_e
centare93113703centare
cetane8315283ce_tane
collage102813763collage
cottage104210573cottage
cuttage10318343cuttage
degage92711383de_gage
delate73827753del_ate
deleave1147723deleave
delta66117773delta__
deltaic1037023deltaic
deltas74414823delta_s
deluge8189403del_uge
dentate8315153dentate
dotage82711613_dotage
ecotage1036883ecotage
elate55335883_el_ate
eluate62315433_eluate
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
estate64719763_estate
etape74413703_e_tape
fellate10313433fellate
flotage1136683flotage
foliage1147533foliage
footage1148843footage
gelate73421263gel_ate
gestate83614073gestate
hectare1238473hectare
hektare1435513hektare
helotages1346123helotages
heptane1238363heptane
herbage1337013herbage
heritage1246533heritage
hostage113111233hostage
jetlag1434523jetlag_
jetlags1533863jetlags
keelage1236193keelage
leafage1194573leafage
leakage1235003leakage
mage75739133m___age
malate84624563mal_ate
maleate94117543maleate
maltases1039693maltases
maltose939793maltose
manage93818903m_anage
massage1039893massage
meager94515203me__ager
meagre9349323me__agre
mealtime1245123mealtime
meatal84114733meata_l
mediae94217413media_e
mediate103415213mediate
meditate11310623meditate
melamed1249633mel_amed
melanges1138613melanges
melee73729103mel__ee
melt65752893melt___
melted94219063melt_ed
melter83520113melt_er
melters93918313melters
melting103317753melting
melton8311553melt_on
meltons9410923meltons
melts74930103melt__s
meltwater1443433meltwater
melty104918363melt__y
menace103216943me_nace
menages103615393me_nages
mensae84114053mensa_e
menta74424423menta__
mental84521603menta_l
mentee84121293ment_ee
merge84523693me__rge
messaged1235543messaged
messages1138233messages
messuage1144523messuage
mestee84523883mest_ee
meta65932413me_ta__
metal75427383me_ta_l
metaled102913883me_taled
metals84520893me_tals
metamer1139613me_tamer
metatag1045053metatag_
metatags1144693metatags
metates92720013me_tates
mete64438133me_t__e
meterage1147933meterage
methane123211793methane
metope10611123me_tope
metre74821303me_t_re
mettle83815723me_ttle
milages103114403mil_ages
mileages11249693mileages
militate10311673militate
millages113212903millages
mintages111110513mintages
mirage92313653m_irage
mispage12310523mispage
mistake131312623mistake
montaged12107763montaged
montages111412183montages
montane91313623montane
moorage1038743moorage
mortgage1244213mortgage
moulage1037903moulage
multipage1446453multipage
multure939183multure
mutagen1056603m_utagen
mutase82811993m_utase
mutate83017483m_utate
onstage838363onstage
outage72017533_outage
peage84723573pe__age
pectase112410363pectase
pectate112214693pectate
peerage1089803peerage
pelages10714613pel_ages
peltast9310513peltast
pentane9415743pentane
peonage1048723peonage
pillage103412603pillage
pilotage1145373pilotage
plage84520403_pl_age
portage103013643portage
postage103214853postage
potage92715903_potage
pottage103310603pottage
reimage1037913reimage
relace83122153rel_ace
relate64033633rel_ate
release7312763release
restaged103011863restaged
restages92815773restages
restate73824883restate
retag63618413re_tag_
retags73414303re_tags
retake104718533re_take
retape83917683re_tape
rootage839053rootage
salvage1138193salvage
scutage1036333scutage
seepage1037543seepage
selvaged1334343selvaged
selvages1236513selvages
septages1168263septages
septate9511873septate
serfage1138403serfage
setae56026223se_ta_e
sewage10310733se_wage
silage72715303sil_age
smallage1145183smallage
stage65330193__stage
sullage859913sullage
tallage82712073tallage
teenage8108053teenage
telae54323293tel_a_e
telltale844423telltale
tentages91011043tentages
testae64216253testa_e
testate73916233testate
tillage83111343tillage
tollage82610163tollage
ullage739043_ullage
unitage838993unitage
upstage10167443upstage
vantage11109893vantage
velate93720143vel_ate
ventages12119773ventages
vestige1137433vestige
village113610833village
vintage11128143vintage
voltages1237253voltages
waftage14115323waftage
wantage11119623wantage
wastage11109253wastage
wattage1186983wattage
webpage1543133webpage
welfare1335723welfare

Search took 7 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.406440125.6
2DLD Change Limit1340272106.22021547.7
3Display Results2102100.0762763.2
 (SQL Overall)1786912106.70226662.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.