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 “misstops” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
misstops1217641(None) 
missteps12156141missteps
misstop11156411misstop_
missions10311902missions
misstamps1543372misstamps
misstep11158462misstep_
ripstops1265012ripstops
bishops1437033bi_shops
desktops1542463desktops
emissions1146923emissions
estops84011223__estops
fissions1138033fissions
hightops1745043hightops
hilltops1344933hilltops
hyssops1543123hyss_ops
insteps936573_insteps
isotope9227783_isotope
isotopes10228073_isotopes
isotopy12215123_isotopy
maintops1244403maintops
midships1645693midships
midstory1445103midstory
midsts95510053midst__s
milksops1642853milksops
minsters103813923minsters
misatone1049763misatone
misatones1148933misatones
miscooks1645463miscooks
miscopy1636663mi_scopy
misdoes10312493mi_sdoes
misgrows1444963misgrows
mishaps1438723mi_shaps
miskeeps1644163miskeeps
misknows1743063misknows
misos76523293mi_s_o_s
missals93914423miss_als
missays124010253miss_ays
misseats104011683misseats
missels94614813miss_els
missends11368233missends
misses85130873miss__es
missets94516573miss_ets
misshape1545983misshape
misshapes1645913misshapes
misshod1335873missho_d
missies93423983miss_ies
missiles103015083missiles
mission9312743missio_n
missis84417503miss__is
missises103513693missises
missives133212843missives
missort9314653miss_ort
missorts1038323missorts
missout9412663miss_out
missouts1037623missouts
misspoke1645413misspoke
misstamp1443803misstamp
misstart10410043misstart
misstarts1145833misstarts
misstate10711343misstate
misstates11710633misstates
missteer1037223missteer
missteers1135913missteers
misstopped17102813misstopped
misstyle1345273misstyle
misstyles1445023misstyles
missuits1078023missuits
missus85312293miss__us
missuses10309683missuses
mistbows1543993mistbows
misters93927513mi_sters
mistook1337153mi_stook
mists76633903mi_st__s
mistutors1144763mistutors
mistype14126523mi_stype
mistypes15116713mi_stypes
nonstops10116883nonstops
omissions1146153omissions
pistols93213983pi_stols
pistons93016373pi_stons
pistous92714383pi_stous
postops11311713_postops
ripstop1174763ripstop_
stops74827283___stops
tiptops1136073ti_ptops
unstops936993_unstops
visitors1146433visitors

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 Limit146162876.64022012.3
3Display Results87870.0461891.3
 (SQL Overall)178691877.10925135.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.