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

224 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
mispages1331118(None) 
mispage12310521mispage_
mispaged1438241mispaged
massages1159882massages
messages1138232messages
midspaces1643992midspaces
milages103114402mi_lages
mileages11249692mileages
millages113212902millages
mintages111110512mintages
mirages102213532mi_rages
misdates111113632misdates
miseases102614342miseases
misgauges1344312misgauges
mismakes16129882mismakes
mismates121114562mismates
misnames12119882misnames
misparse1237732misparse
misparses1347652misparses
misparts12108172misparts
misplaces1537952misplaces
misrates101318242misrates
misspaces1546512misspaces
mistakes141213412mistakes
misusages1244972misusages
pipages1289422pi_pages
visages1138692vis_ages
airspaces1344503airspaces
assuages936273assuages
asswages1255053asswages
bisnagas1142843bisnagas
boscages1366643boscages
boskages1565423boskages
dipsades1246493dipsades
discases112014503discases
diseases92415813diseases
disparages1446043disparages
disparts11109953disparts
displaces1448593displaces
disposes11313823disposes
disputes1139653disputes
disrates91118153disrates
dissaves1239413dissaves
distaves12311403distaves
dosages92310803dos_ages
hostages122311693hostages
images91411463_i_mages
impales113311763_impales
incages103013883_incages
innages82911303_innages
linages8813173li_nages
lineages979183lineages
linkages1385953linkages
lipases9209483li_pases
mages85036023m___ages
manages103418963m_anages
massage1039893massage_
massaged1236753massaged
massager1136873massager
massagers1245513massagers
meltages1148243meltages
menages103615393m_enages
mesdames1346043mesdames
message1037833message_
messaged1235543messaged
messuages1244393messuages
metages102714973m_etages
midges103516483mi__dges
midranges1344653midranges
midspace1543953midspace_
migrates111112853migrates
milage93414123mi_lage_
mileage10299313mileage_
millage103112753millage_
milpas101710273milpa__s
mintage101110123mintage_
mirage92313653mi_rage_
misacts1139353mis_acts
misadds1136303mis_adds
misagent11410723mis_agent
misagents1246793mis_agents
misaims11310113mis_aims
misate81222693mis_ate_
misaver1249813mis_aver
misavers1348063mis_avers
misbiases1346253misbiases
miscalls1239003miscalls
miscasts1238343miscasts
mischarges1885153mischarges
miscites12313783miscites
miscodes13310423miscodes
miscues11312393mis_cues
misdate101413963misdate_
misdated121211123misdated
misdoes10312493mis_does
misease92713043misease_
miseaten10310773miseaten
miseats92815783misea_ts
miseries10320403miseries
mises74740563mis___es
misfiles133110983misfiles
misfires132210583misfires
misframes1646633misframes
misgauge1244253misgauge_
misgauged1443703misgauged
misgave13298283misgave_
misgives14329293misgives
misgrades1347363misgrades
mishaps1438713misha_ps
misjudges2042643misjudges
miskals13369763miska_ls
mislabel1296173mislabel
mislabels13114313mislabels
mislayer1337503mislayer
mislayers1445943mislayers
mislays12349243misla_ys
mislies92922283mis_lies
mislikes143311833mislikes
mislives132912153mislives
mislodges1344363mislodges
mismade12129353mismade_
mismake15139373mismake_
mismanages1544203mismanages
mismarks1645893mismarks
mismate111415353mismate_
mismated131111333mismated
mismoves1537293mismoves
misname11119483misname_
misnamed13127593misnamed
mispackages2251683mispackages
mispaging1537803mispaging
mispaint121111893mispaint
mispaints13106183mispaints
misparsed1446253misparsed
mispart111113773mispa_rt
misparted1437263misparted
mispatch1743853mispatch
mispatches1974103mispatches
mispen10312173misp__en
mispens11311073misp_ens
misphrases1745083misphrases
misplace1437553misplace_
misplaced1646253misplaced
misplans1238863misplans
misplants1347313misplants
misplayed1745303misplayed
misplays1555543misplays
mispled12310463misp_led
mispoise1248263mispoise
mispoises1348353mispoises
misprices1547913misprices
misprizes2247223misprizes
misraise10410523misraise
misraises1149933misraises
misrate91319143misrate_
misrated111315383misrated
misrules1039383misrules
missals93914423missa_ls
missays124010253missa_ys
misses85130873mis__ses
misshapes1645913misshapes
missies93423983mis_sies
missiles103015083missiles
missises103513693missises
missives133212843missives
misspace1446523misspace_
misspaced1645353misspaced
misstates11710633misstates
missuses10309683missuses
mistake131312623mistake_
mistaken14147833mistaken
mistaker14109333mistaker
mistakers15117083mistakers
mistimes12612613mistimes
mistraces13312293mistraces
mistunes10311133mistunes
mistypes15116713mistypes
misusage1145173misusage_
misuses93216023mis_uses
misvalues1444683misvalues
misyokes1735513misyokes
montages111412183montages
moorages1139053moorages
moulages1138053moulages
muspikes1635243muspikes
pages85235073___pages
passages1139513passages
pillages113012613pillages
pipage1199143pi_page_
pipeages1336423pipeages
pishoges1446953pishoges
postages112815323postages
rampages1336673rampages
respaces12311043respaces
respades1139853respades
restages92815773restages
rivages1138873ri_vages
sages65339063__s_ages
seepages1137283seepages
signages1037483signages
silages82514443si_lages
sinkages1386853sinkages
slippages1483983slippages
spaces104722633__spaces
spades94222583__spades
spaes76029973__spa_es
spales84728103__spales
spares84834553__spares
sparges104016343__sparges
spates85028173__spates
stages75629493__stages
swages104417073__swages
tillages93011263tillages
tisanes7311853tis_anes
upstages11147373upstages
usages759603_us_ages
villages123010603villages
vintages12118273vintages
visage1049083vis_age_
visaged1235683vis_aged
warpages1437053warpages
wastages12109753wastages
webpages1643053webpages
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.406440125.6
2DLD Change Limit1461622247.01620832.7
3Display Results2242240.0932408.6
 (SQL Overall)1786912247.51523777.9
 
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.