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

119 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
missouts103762(None) 
missorts1038321missorts
missout9412661missout_
miscounts1386412miscounts
miscuts1139182mi_scuts
misdoubts1482502misdoubts
misroute1049102misroute
misroutes1148312misroutes
misseats104011682misseats
missets94516572miss_ets
missort9314652missort_
missound1145112missound
missounds1243532missounds
missuits1078022missuits
missus85312292miss_u_s
assorts73310153_assorts
beshouts1346763beshouts
bistorts10118803bistorts
cissoids1145363cissoids
dimouts1037893di_mouts
discounts1287823discounts
dismounts1275283dismounts
disports111111113disports
disroots948623disroots
disseats93211503disseats
dissects11279243dissects
dissents93411863dissents
disserts92411813disserts
dissolute1045743dissolute
distorts91112343distorts
hideouts1285573hideouts
insouls737213_insouls
issues648803_iss_ues
mahouts1237143m_ahouts
mascots113910343masco_ts
masscults13103013masscults
masseurs1034923masseurs
miaous8511693mi_aou_s
midguts11296013mi_dguts
midmosts1343773midmosts
midsoles1137763midsoles
midsts95510053mids__ts
misacts1139353mi_sacts
misbound1344933misbound
miscasts1238343miscasts
miscodes13310423miscodes
miscoins12311083miscoins
miscooks1645463miscooks
miscount1299463miscount
miscues11312393mi_scues
miscut10614813mi_scut_
misdoers1137103misdoers
misdoes10312493misdo_es
misdoubt1394073misdoubt
miseats92815783mi_seats
misedits1147963misedits
misfits12279663mi_sfits
misfocus1543453misfocus
misforms1545883misforms
mishits122513083mi_shits
misjoins1736913misjoins
mismeets12297733mismeets
mismoves1537293mismoves
misos76523293mi_so__s
misparts12108173misparts
mispoints13106633mispoints
misquote1945133misquote
misquotes2044593misquotes
misrouted1247303misrouted
missals93914423miss_als
missays124010253miss_ays
misseat93617233misseat_
missels94614813miss_els
missends11368233missends
missent94318713missent_
misses85130873miss__es
misset85028153miss_et_
missies93423983miss_ies
missiles103015083missiles
missions10311903missions
missis84417503miss__is
missises103513693missises
missives133212843missives
missorted1247033missorted
misstarts1145833misstarts
misstate10711333misstate
misstates11710623misstates
missteps12156143missteps
misstops12176413misstops
missuit9911303miss_uit
missuses10309683missuses
mistouch1543793mistouch
mistrust1049203mistrust
mistrusts1146003mistrusts
mistruth1346043mistruth
mistruths1443683mistruths
mists76633903mi_s__ts
miswords1446603miswords
misyokes1735513misyokes
mysosts1234543m_ysosts
pigouts1037593pi_gouts
pissants1097363pissants
pissoirs1044693pissoirs
pistous92714383pistou_s
rissoles839113rissoles
scouts84817943__scouts
shouts94017713__shouts
sickouts1455503sickouts
snouts64915863__snouts
spouts85115113__spouts
stouts65019003__stouts
timeouts1044773timeouts
tissues737463tiss_ues
viscounts1484583viscounts
viscous1238833viscou_s
washouts1445903washouts
wideouts1275233wideouts
wipeouts1354203wipeouts
withouts1445113withouts

Search took 10 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.1701051123.5
2DLD Change Limit1461621198.86016496.8
3Display Results1191190.0462587.0
 (SQL Overall)1786911199.07619688.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.