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

86 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
misspace144652(None) 
midspace1543951midspace
misspaced1645351misspaced
misspaces1546511misspaces
airspace1244652airspace
midspaces1643992midspaces
mispage12310522mi_spage
misplace1437552misplace
misshape1545982misshape
misspoke1645412misspoke
misstate10711342misstate
mistrace12312642mistrace
airspaces1344503airspaces
disgrace1248283disgrace
displace1348653displace
dissave1139413diss_ave
dissipate1247043dissipate
dissuade1065933dissuade
fissate103010033fiss_ate
isopach1444243_isopach
issuance1045223_issuance
massacre1244743mass_acre
massage1039893mass_age
message1037833mess_age
messmate1246393messmate
messuage1144523messuage
millrace1245443millrace
misact10316693mi_s_act
misate81222693mi_s_ate
mischance1846193mischance
misdate101413963mi_sdate
misease92713043mi_sease
misframe1546973misframe
misgave13298283mi_sgave
misgrade1247503misgrade
mismade12129353mi_smade
mismake15139373mi_smake
mismate111415353mi_smate
misname11119483mi_sname
mispaged1438243mi_spaged
mispages13311183mi_spages
misparse1237733mi_sparse
mispart111113783mi_spart
mispatch1743853mi_spatch
misplaced1646253misplaced
misplaces1537953misplaces
misprice1448133misprice
misrate91319143mi_srate
missable12311533missable
missaid10310303miss_aid
missal84314903miss_a_l
missals93914433miss_als
missay114112143miss_a_y
missays124010253miss_ays
misseat93617243missea_t
misseated12610113misseated
misseats104011683misseats
missense1037963missense
misshaped1744753misshaped
misshapen1643783misshapen
misshaper1644403misshaper
misshapes1645913misshapes
missile92815403miss_ile
missive122413143miss_ive
misspacing1784983misspacing
misspeak1643493misspeak
misspeaks1743063misspeaks
misspell1244303misspell
misspelt1247273misspelt
misspend1345243misspend
misspent1259173misspent
misspoken1743263misspoken
misstamp1443803misstamp
misstart10410043misstart
misstated1278973misstated
misstates11710633misstates
misstyle1345273misstyle
mistake131312623mi_stake
misteach1545443misteach
mistraced1439453mistraced
mistraces13312293mistraces
misusage1145173misusage
mossback1843713mossback
respace11310913_respace
space95325673___space
subspace1445683subspace

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.436409841.7
2DLD Change Limit146162867.47019566.5
3Display Results86860.0461869.6
 (SQL Overall)178691867.95222471.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.