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

108 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
overshade163699(None) 
overshaded1845841overshaded
overshades1746281overshades
overgrade1457622overgrade
overhate14312792over_hate
overlade12611552over_lade
oversad11259962overs_ad_
oversale11313872overs_ale
oversave14310492overs_ave
overscale1447992overscale
overshadow2041962overshadow
oversharp1743752oversharp
overshoe1438562oversh_oe
overside122013932overs_ide
overstate121010862overstate
overtrade1348512overtrade
everglade1442563everglade
eyeshade1542593eye_shade
overage11514053over__age
overate10620963over__ate
overawe13511463over__awe
overbake17129803over_bake
overbrake1847253overbrake
overcame151310693over_came
overcharge1944423overcharge
overdare12311183over_dare
overglad13116533overglad_
overglaze2286273overglaze
overgoad13127153overgoad_
overgoaded1655573overgoaded
overgoads14115893overgoads
overgraded1656593overgraded
overgrades1556933overgrades
overgraze2276673overgraze
overhand15229963over_hand
overhanded1846693over_handed
overhandle1744123over_handle
overhands16227803over_hands
overhang15248863over_hang
overhard15238793over_hard
overhated16610443over_hated
overhates15311943over_hates
overhaul1436223over_haul
overhead152110363overhead_
overheads16248933overheads
overhope1638343over_hope
overhype1944593over_hype
overladed1459223over_laded
overladen1367643over_laden
overlades13510353over_lades
overlate11716283over_late
overload12119283overload_
overloaded1566593overloaded
overloads13127663overloads
overrate11615693over_rate
override121512523over_ride
overrode121810583over_rode
overrude12168093over_rude
oversales12313143overs_ales
oversalt11312743overs_alt
oversauce1447043oversauce
oversaved1638623overs_aved
oversaves15310183overs_aves
oversaw13268163overs_a_w
overscaled1646463overscaled
overscore1447863overscore
oversea102412113oversea__
overseas112612423oversea_s
oversee102717603overs__ee
overseed122513353overseed_
overseeded1545453overseeded
overseeds13248893overseeds
oversewed1636953oversewed
oversexed2037223oversexed
overshading1946643overshading
overshadowed2351423overshadowed
overshadows2151593overshadows
overshirt1547903overshirt
overshoes1538863overshoes
overshoot1557133overshoot
overshot1449433oversh_ot
overshots1546623overshots
oversides131512663overs_ides
oversize201812513overs_ize
oversized221710153oversized
oversmoke1845013oversmoke
oversoak1536993oversoa_k
oversoaked1845823oversoaked
oversoaks1635983oversoaks
oversold12218933oversold_
overspice1647123overspice
overstaff1844483overstaff
overstated14119443overstated
overstates131110113overstates
overstay1436733oversta_y
overstayed17125853overstayed
overstays1535943overstays
overstride1447073overstride
overstrode1445223overstrode
overstudy1643203overstudy
oversuds1237033overs_uds
oversure111611163overs_ure
overtake151210143over_take
overtame131510523over_tame
overtraded1557083overtraded
overtrades1457493overtrades
overwide15179463over_wide
persuade1145853_persuade

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 Limit1486411087.48619855.9
3Display Results1081080.0432511.6
 (SQL Overall)1786911087.94922479.7
 
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.