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

91 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
misplaced164625(None) 
displaced1546791displaced
misplace1437551misplace_
misplaces1537951misplaces
misplayed1745301misplayed
displace1348652displace_
displacer1446432displacer
displaces1448592displaces
displayed1645882displayed
mispaged1438242misp_aged
misplanned1583872misplanned
misplanted1565442misplanted
mispleaded1644132mispleaded
mispled12310462mispl__ed
mispriced1646422mispriced
misspaced1645352misspaced
mistraced1439452mistraced
discalced1545653discalced
disgraced1446743disgraced
displacers1545013displacers
displanted14126633displanted
displayer1545833displayer
displeased1444483displeased
disploded1446543disploded
displumed1544353displumed
emplaced1536053_emplaced
fireplaced1842943fireplaced
inlaced10239873_i_nlaced
isolated9410523_isolated
midspace1543953midsp_ace_
midspaces1643993midsp_aces
misacted1338673mis__acted
misallied1246543misallied
misbalanced1852423misbalanced
misbiased1444843misbiased
miscalled1447443miscalled
misclaimed1744263misclaimed
misclassed1564073misclassed
misdated121211123mis_dated
misdialed1345513misdialed
misframed1745623misframed
misgraded1446233misgraded
mislabel1296173mis_label
mislaid1039303mis_la_id
mislayer1337503mis_layer
misleared1277453misleared
misled94719313mis_l__ed
misliked15319513mis_liked
mislived14328783mis_lived
mismated131111333mis_mated
misnamed13127593mis_named
mispage12310523misp_age_
mispages13311183misp_ages
misparsed1446253misparsed
misparted1437263misparted
mispatched2053833mispatched
mispenned1445413mispenned
misphrased1843863misphrased
misplacing1745913misplacing
misplan1147773mispla__n
misplans1238863mispla_ns
misplant12410763mispla_nt
misplants1347313misplants
misplay1436383mispla__y
misplays1555543mispla_ys
misplead1345023mispl_ead
mispoised1446803mispoised
misprice1448133misprice_
misprices1547913misprices
misprized2346603misprized
misrated111315383mis_rated
misrelated1346493misrelated
misseated12610113misseated
misshaped1744753misshaped
misspace1446523misspace_
misspaces1546513misspaces
misstated1278973misstated
mistrace12312643mistrace_
mistraces13312293mistraces
misvalued1544283misvalued
outplaced1446353outplaced
placed114318003___placed
preplaced1676483preplaced
replaced133211403_replaced
respaced1338503resp_aced
respliced1445543respliced
solaced102911063__solaced
spaced114517253__sp_aced
splayed13357813__splayed
spliced124310593__spliced
unplaced1338613_unplaced

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 Filter1786911486410.420425454.8
2DLD Change Limit148641916.97021325.8
3Display Results91910.0461978.3
 (SQL Overall)178691917.43624030.5
 
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.