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

104 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
overshots154662(None) 
overshoes1538861overshoes
overshoots1644391overshoots
overshot1449431overshot_
overhot13411222over_hot_
overplots1436952overplots
oversalts1238162oversalts
oversets113114172overs_ets
overshirts1644782overshirts
overshoe1438562oversho_e
overshoot1557132overshoot
airshots1145943_airshots
aversions1247053aversions
earshots1146623_earshots
eversions1238363eversions
eyeshots1453373eye_shots
obversions1544513obversions
overacts1339653over_acts
overbeats14279823overbeats
overbets132510683over_bets
overblows1745003overblows
overbooks1855873overbooks
overcasts14217853overcasts
overcoats1438863overcoats
overcooks1875763overcooks
overcools1476773overcools
overcrops1646543overcrops
overcuts1337513over_cuts
overdoes121212543over_does
overdogs13127493over_dogs
overeats112415263over_eats
overedits1346813overedits
overemote1447193overemote
overemotes1546703overemotes
overflows1845113overflows
overgrows1645323overgrows
overhate14312793over_hate
overhates15311943over_hates
overheats15229993overheats
overhold15219013over_hold
overholds16206333over_holds
overholy17216673over_holy
overhope1638343over_hope
overhopes1738143over_hopes
overhunts15245743overhunts
overjoys2135183over_joys
overlets112312363over_lets
overlooks1685483overlooks
overmelts1447263overmelts
overplot1338543overplot_
oversales12313143oversales
oversalt11312743oversalt_
oversaves15310183oversaves
overscore1447863overscore
overscores1547363overscores
overseas112612423overs_eas
overseeds13248893overseeds
overseers12298783overseers
oversees112415903overs_ees
oversells1236973oversells
overset102821473overs_et_
oversews14289423overs_ews
overshade1636993overshade
overshades1746283overshades
overshadows2151593overshadows
oversharp1743753oversharp
overshirt1547903overshirt
oversides131512663oversides
oversights1744443oversights
oversizes211111613oversizes
overskirts1743713overskirts
overslips1446763overslips
overslow1435693overslo_w
oversmoke1845013oversmoke
oversmokes1944703oversmokes
oversoak1536993overs_oak
oversoaks1635983oversoaks
oversoft1438843overs_oft
oversold12218933overs_old
oversoon1138303overs_oon
oversoul1137093overs_oul
oversouls1236603oversouls
overspins1439043overspins
overstate121010863overstate
overstates131110113overstates
overstays1535943overstays
oversteps1436303oversteps
overstirs1238213overstirs
overstock1844503overstock
overstocks1943643overstocks
overstory1546143overstory
oversuds1237033overs_uds
oversups1336553overs_ups
overthrows1943413overthrows
overtops1338513over_tops
overvote1438953over_vote
overvotes1538423over_votes
overwets14219953over_wets
overwrote1557693overwrote
versants1137783_versants
versets103913103_vers_ets
versions11310353_versions
versos93812803_vers_o_s
versts93914733_vers__ts

Search took 9 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.1701051123.5
2DLD Change Limit1486411048.55017384.9
3Display Results1041040.0462260.9
 (SQL Overall)1786911048.76620384.6
 
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.