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

167 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
mileages1124969(None) 
milages103114401mil_ages
mileage10299311mileage_
millages113212901millages
lineages979182lineages
maleates103316342maleates
meltages1148242meltages
milage93414122mil_age_
millage103112752millage_
mintages111110512mintages
mirages102213532mi_rages
miseases102614342miseases
mispages13311182mispages
pillages113012612pillages
pipeages1336422pipeages
silages82514442sil_ages
tillages93011262tillages
villages123010602villages
acreages1138373acreages
alienages1045973alienages
alleges84212573alle_ges
anlages82414113anl_ages
bilges94915633bil__ges
bulkages1535273bulkages
ciliates10413453ciliates
cleaves124111623_cleaves
collages113514243collages
deleaves1248063deleaves
diallages1145463diallages
dilates83220663dil_ates
diseases92415813diseases
diverges13258313diverges
filenames1444293filenames
filiates11412663filiates
fledges12409393_fledges
foliages1247623foliages
grillages1174943grillages
ideates8313733_ideates
ileuses738673_ileuses
ilexes134510253_ile_xes
images91411463_i_mages
immerges1345393immerges
impledges1543153impledges
incages103013883_incages
innages82911303_innages
keelages1335743keelages
kleagles1343143_kleagles
leagues837943__leagues
leases65428113__leases
leaves94222383__leaves
ledges84918013__ledges
leges64427293__le_ges
lieges74113443li_e_ges
limeades11116643limeades
linages8813173li_nages
lineage878983lineage_
linkages1385953linkages
mages85036023m___ages
mailbags1343903mailbag_s
malates93522603mal_ates
maleate94117543maleate_
maltases1039693maltases
manages103418963m_anages
maneges103612143mane_ges
massages1159883massages
meager94515203m__eager
melanges1138613melanges
melees83618083mele__es
meltage1037953meltage_
menages103615393m_enages
merges94122493m__erges
messages1138233messages
metages102714973m_etages
meterages1248183meterages
micelles1288833micelles
midges103516483mi__dges
midlegs1156323midle_g_s
midranges1344653midranges
migrates111112853migrates
miladies1139923miladies
miladis1049823mil_adis
milers84625163mile__rs
miles74645073mil___es
militates11310883militates
millcakes1744683millcakes
milles84526563mil__les
milliares1149403milliares
millimes122411373millimes
millines102718063millines
millraces1345753millraces
milpas101710273milpa__s
mimeses1139073mime_ses
mintage101110123mintage_
mirage92313653mi_rage_
mirexes1636993mire_xes
misdates111113633misdates
misease92713043misease_
miseaten10310773miseaten
miseats92815783misea_ts
miseries10320403miseries
misgauges1344313misgauges
misleader1246503misleader
misleaders1345203misleaders
misleads11358543mislea_ds
misleared1277453misleared
mislearns1144523mislearns
mislodges1344363mislodges
mismakes16129883mismakes
mismates121114563mismates
misnames12119883misnames
mispage12310523mispage_
mispaged1438243mispaged
misrates101318243misrates
mistakes141213413mistakes
misusages1244973misusages
montages111412183montages
moorages1139053moorages
moulages1138053moulages
mucilages1443813mucil_ages
oleates7417833_oleates
peages94321853__peages
pelages10714613pel_ages
pileate93815923pileate_
pileated112711133pileated
pilferages1642623pilferages
pillage103412603pillage_
pillaged12298093pillaged
pillager11278553pillager
pillagers12276923pillagers
pilotages1245503pilotages
pipages1289423pi_pages
pipeage1236203pipeage_
plages94520153_pl_ages
pleases94515483_pleases
pledges113811583_pledges
poleaxes1767273poleaxes
releases8313343releases
rivages1138873ri_vages
salvages1238123salvages
selvages1236513selvages
sieges73816833si_e_ges
signages1037483signages
silage72715303sil_age_
silanes72517163sil_anes
silences10310073silences
silexes1438653sile_xes
sinkages1386853sinkages
sleaves103813203_sleaves
sleazes162810333_sleazes
sledges94511573_sledges
smallages1245293smallages
smilaxes1744653smil_axes
soilages9189673soil_ages
spillages1256083spillages
sullages939973sullages
tallages92312003tallages
tillage83111343tillage_
tollages92410193tollages
ullages838953_ullages
village113610833village_
villager12267513villager
villagers13296153villagers
villenages1442953villenages
vintages12118273vintages
visages1138693vi_sages
voltages1237253voltages
windages1338263windages

Search took 8 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 Limit1461621677.07620656.0
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.56223630.1
 
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.