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

101 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
overjoyed233478(None) 
overdosed14128072overdosed
overdyed16126512over_dyed
overhoped1837092overhoped
overjoy2034872overjoy__
overjoys2135182overjoy_s
overloved16217642overloved
overvoted1637502overvoted
enjoyed1834523__enjoyed
overacted1539633overacted
overaged13511673over_aged
overalled1339063overalled
overarmed1538103overarmed
overawed1579963over_awed
overbaked19127823overbaked
overbed132811843over__bed
overboard1537813overboard
overboiled1646123overboiled
overbold14208543overbo_ld
overbooked2044433overbooked
overbore131111583overbore_
overbred1459843over_bred
overbreed1548033overbreed
overcold14208493overco_ld
overcome151110703overcome_
overcomer16127743overcomer
overcomes161110333overcomes
overcooked2044913overcooked
overcooled1646223overcooled
overcoy1536633overcoy__
overcured15148643overcured
overdared1439163overdared
overdoer12128713overdo_er
overdoes121212543overdo_es
overdone121210913overdone_
overdose121110063overdose_
overdoses13119793overdoses
overdried1439013overdried
overdye14126923over_dye_
overdyer15125453over_dyer
overdyes15127473over_dyes
overed102216623over___ed
overemoted1646323overemoted
overfed142510253over__fed
overfeed15299433over_feed
overflowed2044583overflowed
overfond1537323overfo_nd
overgoad13127153overgo_ad
overgoaded1655573overgoaded
overhated16610443overhated
overhold15219013overho_ld
overhope1638343overhope_
overhopes1738143overhopes
overhyped2144153overhyped
overjoying2445143overjoying
overladed1459223overladed
overlived16248513overlived
overload12119283overlo_ad
overloaded1566593overloaded
overlooked1844413overlooked
overlord12119183overlo_rd
overlorded1555863overlorded
overloud12117753overlo_ud
overlove14239173overlove_
overloves15218673overloves
overmined1539603overmined
overmixed2236063overmixed
overplayed19206753overplayed
overplied1539053overplied
overpower1746233overpower
overrated13313083overrated
overrode121810573overrode_
overruled13127813overruled
oversaved1638613oversaved
overscored1646363overscored
overseed122513343over_seed
oversewed1636933oversewed
oversexed2037203oversexed
oversized221710153oversized
oversmoked2044203oversmoked
oversoaked1845823oversoaked
oversold12218933overso_ld
overstayed17125853overstayed
overtaxed20117243overtaxed
overtimed15159243overtimed
overtired131310253overtired
overtoiled1446283overtoiled
overtone111012573overtone_
overtones121011853overtones
overtopped1844653overtopped
overtured13169213overtured
overurged1496673overurged
overused1249443over_used
overvote1438953overvote_
overvotes1538423overvotes
overword15119233overwo_rd
overwore141111393overwore_
overworked2145183overworked
overwound1644763overwound
reenjoyed2042533reenjoyed
unenjoyed2041993unenjoyed

Search took 7 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.1731032896.0
2DLD Change Limit1486411016.59322545.3
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.81226231.8
 
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.