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

221 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
millages11321290(None) 
milages103114401mi_lages
mileages11249691mileages
millage103112751millage_
pillages113012611pillages
tillages93011261tillages
villages123010601villages
collages113514242collages
diallages1145462diallages
grillages1174942grillages
meltages1148242meltages
milage93414122mi_lage_
mileage10299312mileage_
millcakes1744682millcakes
milles84526562mill__es
milliares1149402milliares
millimes122411372millimes
millines102718062millines
millraces1345752millraces
mintages111110512mintages
mirages102213532mi_rages
mispages13311182mispages
moulages1138052moulages
pillage103412602pillage_
pillaged12298092pillaged
pillager11278552pillager
pillagers12276922pillagers
silages82514442si_lages
smallages1245292smallages
spillages1256082spillages
sullages939972sullages
tallages92312002tallages
tillage83111342tillage_
tollages92410192tollages
ullages838952_ullages
village113610832village_
villager12267512villager
villagers13296152villagers
alleges84212573_alleges
anlages82414113_anlages
ballades114211643ballades
bilges94915633bi_l_ges
billies93923503bill_ies
biplanes1238573biplanes
bulkages1535273bulkages
bullaces12299433bullaces
ciliates10413453ciliates
collage102813763collage_
collaged12279973collaged
collagen11338573collagen
collagens12256033collagens
collates103019143collates
colleges112410523colleges
diallage1045233diallage_
dilates83220663di_lates
dillies84122163dill_ies
fellates11312753fellates
filiates11412663filiates
fillagree1343623fillagree
fillagrees1452583fillagrees
filles94224523fill__es
fillies103420253fill_ies
foliages1247623foliages
gallates92815523gallates
gillies84120963gill_ies
grillades1194543grillades
grillage1055613grillage_
haulages1236623haulages
haylages1536013haylages
hilloes103815963hill_oes
illites72415013_illites
illudes8347553_illudes
illumes9327673_illumes
images91411463_i_mages
imblazes2144723imblazes
incages103013883_incages
inlaces92512903_inlaces
innages82911303_innages
keelages1335743keelages
killdees1373963killdees
killies113318113kill_ies
linages8813173li_nages
lineages979183lineages
linkages1385953linkages
mages85036023m___ages
mailbags1343903mailbag_s
malates93522603m_alates
maleates103316343maleates
mallards1138323mallards
mallees93315973mall_ees
maltases1039693maltases
manages103418963m_anages
maquillages2351403maquillages
massages1159883massages
melanges1138613melanges
meltage1037953meltage_
menages103615393m_enages
messages1138233messages
metages102714973m_etages
midges103516483mi__dges
midlands1245543midlands
midlegs1156323midleg_s
midlines112613333midlines
midlives14287463midlives
midranges1344653midranges
migrates111112853migrates
miladies1139923miladies
miladis1049823mi_ladis
miles74645073mi_l__es
militates11310883militates
millable121710133millable
millcake1644653millcake_
milldams1344633milldams
mille75029133mill__e_
milled94326173mill__ed
milleped1335173milleped
millepeds1443223millepeds
miller84625413mill__er
millers93621343mill_ers
millet84030743mill__et
millets94216843mill_ets
milliards1246193milliards
milliare1039153milliare_
milliaries1248243milliaries
milliemes13255843milliemes
millier93716703mill_ier
milliers102611903milliers
milligal1145703milligal
milligals1245033milligals
millime112511403millime_
milline92519113milline_
milliner102811863milliner
milliners11289953milliners
millings113712583millings
millions101712433millions
milliped1337383milliped
millipeds1444703millipeds
millirem1245693millirem
millirems1344323millirems
millrace1245433millrace_
millruns1043643millruns
mills75435053mill___s
milpas101710273milpa__s
mintage101110123mintage_
mirage92313653mi_rage_
misdates111113633misdates
miseases102614343miseases
misgauges1344313misgauges
mislabel1296173mislabel
mislabels13114313mislabels
mislayer1337503mislayer
mislayers1445943mislayers
mislays12349243misla_ys
mislies92922283misl_ies
mislikes143311833mislikes
mislives132912153mislives
mislodges1344363mislodges
mismakes16129883mismakes
mismates121114563mismates
misnames12119883misnames
mispage12310523mispage_
mispaged1438243mispaged
misplaces1537953misplaces
misrates101318243misrates
mistakes141213413mistakes
misusages1244973misusages
mollahs12328283molla_hs
mollies93420233moll_ies
montages111412183montages
moorages1139053moorages
moulage1037903moulage_
mucilages1443813mucilages
mullahs12388733mulla_hs
mullas84215933mulla__s
mullites10411643mullites
oeillades1043953oeillades
pelages10714613_pelages
permillages1652543permillages
pillared11228093pillared
pillars9313493pilla_rs
pilotages1245503pilotages
pipages1289423pi_pages
pipeages1336423pipeages
plages94520153__plages
pupillages1542373pupillages
rilles64725503rill__es
rivages1138873ri_vages
salvages1238123salvages
scalages113010253scalages
selvages1236513selvages
signages1037483signages
silage72715303si_lage_
silanes72517163si_lanes
sillies73425083sill_ies
sinkages1386853sinkages
smallage1145183smallage_
smilaxes1744653smi_laxes
soilages9189673soilages
spillage1146263spillage_
sullage859913sullage_
tallage82712073tallage_
tallaged10257923tallaged
thirlages1343763thirlages
tillites8312833tillites
tollage82610163tollage_
treillages1143463treillages
ullage739043_ullage_
ullaged937033_ullaged
villae95615383villa_e_
villagery16273363villagery
villains1138003villains
villas96117263villa__s
villenages1442953villenages
vintages12118273vintages
violates11311193violates
visages1138693vi_sages
voltages1237253voltages
vorlages1236033vorlages
willies103920153will_ies
windages1338263windages
zillahs1935383zilla_hs

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622216.18623627.9
3Display Results2212210.0932376.3
 (SQL Overall)1786912216.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.