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

179 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
misname1111948(None) 
misnamed13127591misnamed
misnames12119881misnames
minae75627722mi_na_e
misate81222692mis_ate
misdate101413962misdate
misease92713042misease
misframe1546972misframe
misgave13298282misgave
mismade12129352mismade
mismake15139372mismake
mismate111415352mismate
misnomer1247142misnomer
mispage12310522mispage
misrate91319142misrate
mistake131312622mistake
mistime11312612mistime
bename103316073_bename
beshame1447483beshame
binate8419773bi_nate
bisnaga1042853bisnaga
bistate9313823bistate
byname13256363_byname
discase102912863discase
disease83213843disease
disme85716243dis__me
disrate81418523disrate
dissave1139413dissave
distome10313233distome
ensnare767123ensnare
filename1344353filename
finale94116763fi_nale
fissate103010033fissate
gisarme1044173gisarme
inane52820343_i_nane
innage73011573_innage
innate63917313_innate
insane6314893_insane
insnare748243insnare
jobname1842933jobname
kinase104210653ki_nase
linage7713403li_nage
lissome937583lissome
macrame1338713macrame
madame1139853m_adame
magnate10512703magnate
manage93818903m_anage
massage1039893massage
menace103216943m_enace
menage93216543m_enage
mensae84114053mensa_e
mesdames1346043mesdames
mesne75116293mesn__e
message1037833message
midspace1543953midspace
migrate101314173migrate
milage93414123mi_lage
mileage10299313mileage
millage103112753millage
millime112511403millime
mime85736413mi___me
mina65136933mi_na__
minable112315073mi_nable
minaret9520683mi_naret
minas75434113mi_na_s
mince95325233mi_n_ce
mine67256183mi_n__e
mingle93518783mi_ngle
minim97321603mi_nim_
minima105512653mi_nima
minims104514813mi_nims
minke115421763mi_n_ke
mintage101110123mintage
minute83414293mi_nute
mirage92313653mi_rage
misact10316693mis_act
misadd1037163mis_add
misaim10311853mis_aim
misaimed1338093misaimed
misaims11310113misaims
misaver1249813mis_aver
misbecame1762723misbecame
miscall1139653miscall
miscast11312423miscast
miscite11314383miscite
miscode12310413miscode
miscue10412223mis_cue
misdated121211123misdated
misdates111113633misdates
misdeem12217873misdeem
misdone10310863misdone
mise66043593mis___e
miseases102614343miseases
miseat82925713misea_t
miseaten10310773miseaten
miseats92815793miseats
misfile122611553misfile
misfire12229893misfire
misframed1745623misframed
misframes1646633misframes
misgauge1244253misgauge
misgive13339033misgive
misgrade1247503misgrade
mishap1338873misha_p
mishaps1438723mishaps
miskal123710263miska_l
miskals13369773miskals
mislabel1296173mislabel
mislaid1039303mislaid
mislain9311243mislain
mislay113510683misla_y
mislayer1337503mislayer
mislays12349243mislays
mislie83219153mis_lie
mislike132914833mislike
mislive122812693mislive
mismakes16129883mismakes
mismanage1444153mismanage
mismark1536703mismark
mismated131111333mismated
mismates121114563mismates
mismet103722373mis__met
mismove1437083mismove
misnaming1447423misnaming
misnomers1346183misnomers
misnumber1552383misnumber
misogamy1644083misogamy
mispaged1438243mispaged
mispages13311183mispages
misparse1237733misparse
mispart111113783mispart
misplace1437553misplace
misraise10410523misraise
misrated111315383misrated
misrates101318243misrates
misrule939353misrule
missable12311533missable
missaid10310303missaid
missal84314903missa_l
missals93914433missals
missay114112143missa_y
missays124010253missays
misshape1545983misshape
missile92815403missile
missive122413143missive
misspace1446523misspace
misstamp1443803misstamp
misstate10711343misstate
mistaken14147833mistaken
mistaker14109333mistaker
mistakes141213413mistakes
mistimed1339123mistimed
mistimes12612613mistimes
mistrace12312643mistrace
mistune9310653mistune
mistype14126523mistype
misusage1145173misusage
misuse83213643mis_use
misvalue1344683misvalue
misyoke1635823misyoke
muscae10410673musca_e
name65637413___name
nickname1642793nickname
penname11328553penname
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
prename11412643prename
rename82718813_rename
same65245643__s_ame
sesame8311013ses_ame
shame105726703__shame
signage937773signage
snake94821113__snake
snare54429983__snare
surname937603surname
tisane6311573tis_ane
visage1049083vis_age
winsome1237463winsome

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271797.08018930.4
3Display Results1791790.0602983.3
 (SQL Overall)1786911797.54623680.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.