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

263 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
missays12401025(None) 
mislays12349241mislays
missals93914421missals
missay114112141missay_
assays977902_assays
dismays13237432dismays
essays965652_essays
massas85116462massa_s
messans92710462messans
middays14335662middays
midways16386182midways
misassays1442532misassays
miseats92815782miseats
mishaps1438722mishaps
miskals13369762miskals
mislay113510682mislay_
misplays1555542misplays
missaid10310302missaid
missal84314902missa_l
misseats104011682misseats
missels94614812missels
misses85130872miss_es
missets94516572missets
missies93423982missies
missis84417502miss_is
missus85312292miss_us
missy105617562miss_y_
airways1336243airways
assais6711963_assais
assay8710283_assay_
bioassays1451753bioassays
cissies94116153cissies
cissy104811073ciss_y_
dipsas9359893dipsa_s
disbars10310323disbars
dismals102010243dismals
dismay12229473dismay_
displays1446293displays
dissave1139413dissave
dissaves1239413dissaves
disseats93211503disseats
disses75225963diss_es
dossals8379293dossals
emissary1343473emissary
essay867623_essay_
fiscals1238003fiscals
fishways2043643fishways
fissate103010033fissate
fossas94610703fossa_s
gainsays1243513gainsays
gossans836783gossans
hissers104112313hissers
hisses94719353hiss_es
hissies103915823hissies
hissy116112123hiss_y_
hussars10326983hussars
inlays9389873_inlays
isbas71010403_isba_s
isseis638563_isseis
issues648803_issues
jigsaws1842563jigsaws
kismats13257843kismats
kissers114211293kissers
kisses104217333kiss_es
kissy125510313kiss_y_
linseys1035083linseys
lyssas935443lyssa_s
mainstays1443393mainstays
margays1337493margays
masas75630413m_asa_s
massa75518923massa__
massage1039893massage
massages1159883massages
masses85028713mass_es
massifs1237743massifs
massy104518963mass_y_
matsahs1236563matsahs
maydays1634493maydays
mays96940033m___ays
mensas85115863mensa_s
mesas76823203m_esa_s
mescals112911563mescals
message1037833message
messages1138233messages
messan83912063messa_n
messes84924343mess_es
messiahs1343963messiahs
messy104913833mess_y_
miasmas1167743miasmas
miasms1097383mias_ms
micas96823053mi_ca_s
mickeys18447943mickeys
midday13327503midday_
midsts95510053mids_ts
midway15327153midway_
mihrabs1444203mihrabs
mikvahs19162493mikvahs
milpas101710273milpa_s
mimbars1397383mimbars
mimosas1136753mimosa_s
minas75434113mi_na_s
minyans1237263minyans
mioses84318853mios_es
miosis83615163mios_is
mirzas1738183mirza_s
misact10316693mi_sact
misacts1139353misacts
misadd1037163mi_sadd
misadds1136303misadds
misaim10311853mi_saim
misaims11310113misaims
misassay1343203misassay_
misate81222693mi_sate
misbias1139083misbias
miscall1139653miscall
miscalls1239003miscalls
miscast11312423miscast
miscasts1238353miscasts
misclass1246843misclass
miscues11312393miscues
miscuts1139183miscuts
misdate101413963misdate
misdates111113633misdates
misdeals1147223misdeals
misdials1137493misdials
misdoes10312493misdoes
misdraws1445753misdraws
misease92713043misease
miseases102614343miseases
miseat82925713misea_t
misers85025703mi_sers
misery114113543misery_
mises74740563mi_s_es
misfits12279663misfits
misgave13298283misgave
mishap1338873misha_p
mishears1338323mishears
mishits122513083mishits
miskal123710263miska_l
mislaid1039303mislaid
mislain9311243mislain
mislayer1337503mislayer
mislayers1445943mislayers
misleads11358543misleads
mislies92922283mislies
mismade12129353mismade
mismake15139373mismake
mismakes16129883mismakes
mismark1536703mismark
mismarks1645893mismarks
mismate111415353mismate
mismates121114563mismates
misname11119483misname
misnames12119883misnames
misos76523293mi_s_os
mispage12310523mispage
mispages13311183mispages
misparse1237733misparse
mispart111113783mispart
misparts12108173misparts
mispens11311073mispens
misplans1238863misplans
misplay1436383misplay_
misraise10410523misraise
misrate91319143misrate
misrates101318243misrates
misreads11268923misreads
miss65339423mi_s__s
missable12311533missable
missaying1537633missaying
misseat93617243misseat
missed94423603miss_ed
missel85216523miss_el
missend104411373missend
missends11368233missends
missense1037963missense
missent94318713missent
misset85028153miss_et
misshape1545983misshape
misshapes1645913misshapes
misshod1335873misshod
missile92815403missile
missiles103015083missiles
missing103619073missing
mission9312743mission
missions10311903missions
missises103513693missises
missive122413143missive
missives133212843missives
missort9314653missort
missorts1038323missorts
missout9412663missout
missouts1037623missouts
misspace1446523misspace
misspaces1546513misspaces
misspeaks1743063misspeaks
misstamp1443803misstamp
misstamps1543373misstamps
misstart10410043misstart
misstarts1145833misstarts
misstate10711343misstate
misstates11710633misstates
misstep11158463misstep
missteps12156143missteps
misstop11156413misstop
misstops12176413misstops
misstyle1345273misstyle
misstyles1445023misstyles
missuit9911303missuit
missuits1078023missuits
missuses10309683missuses
mistake131312623mistake
mistakes141213413mistakes
misters93927513misters
mistrals101212623mistrals
mistryst1345843mistryst
mists76633903mi_s_ts
misty106120453mi_sty_
misusage1145173misusage
misusages1244973misusages
misusers10348083misusers
misuses93216023misuses
mitsvahs1642003mitsvahs
morays114613883m_orays
moseys114711703m_oseys
mossers94116193mossers
mosses85527683moss_es
mossy105217063moss_y_
muscats1138933muscats
mussels9419843mussels
musses84624783muss_es
mussy104117643muss_y_
naysays1344123naysays
oilways1334873oilways
outsays102710403outsays
pissant91012503pissant
pissants1097363pissants
pissers95014753pissers
pisses84525083piss_es
pitsaws1234993pitsaws
resays93714153_resays
ripsaws1243823ripsaws
sashays1336333sashays
says75942103___says
shays116021433__shays
sisals63013573si_sals
sisses64520603siss_es
sissies73716603sissies
sissy85812073siss_y_
slays85723683__slays
spays105520513__spays
stays86022023__stays
sways115518463__sways
tissues737463tissues
tussahs10335113tussahs
tussars7359253tussars
unsays9399543_unsays
vassals1057953vassals
visas84317653vi_sa_s
vistas94513273vista_s
visuals1036853visuals
wiseass1035823wiseass
wisses94619603wiss_es

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.423422437.4
2DLD Change Limit1340272636.70319995.1
3Display Results2632630.1102390.9
 (SQL Overall)1786912637.23624694.7
 
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.