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

66 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
overdecks194457(None) 
overdeck1835221overdeck_
overdecked2164602overdecked
overpacks2075962overpacks
afterdecks2052103afterdecks
bedecks1635793_be_decks
foredecks1973383fore_decks
overacts1339653over_acts
overbears14208483overbears
overbeats14279823overbeats
overbets132510683overbe_ts
overbooks1855873overbooks
overcooks1875763overcooks
overdares13310673overdares
overdear12248083overde_ar
overdecking2246053overdecking
overdirects1752813overdirects
overdoers13117403overdoers
overdoes121212543overd_oes
overdogs13127493overd_ogs
overdoses13119793overdoses
overdraws1645663overdraws
overdress1346593overdress
overdries13310883overdries
overdrinks1853593overdrinks
overdubs1494573overd_ubs
overdyers16125003overdyers
overdyes15127473overd_yes
overeats112415263over_eats
overedits1346813overedits
overfears15236943overfears
overfeeds16226023overfeeds
overfocus1744263overfocus
overheads16248933overheads
overheaps17226953overheaps
overhears15258873overhears
overheats15229993overheats
overleaps14226783overleaps
overlends13237523overlends
overlets112312363overle_ts
overlooks1685483overlooks
overmeek1735493overmeek_
overmelts1447263overmelts
overmilks1844453overmilks
overpack1966623overpack_
overreacts1545433overreacts
overseas112612423overse_as
overseeds13248893overseeds
overseers12298783overseers
oversees112415903overse_es
oversells1236973oversells
oversets113114173overse_ts
oversews14289423overse_ws
oversick1736983oversick_
oversoaks1635983oversoaks
overstocks1943643overstocks
overtalks1645663overtalks
overtasks1644593overtasks
overtricks1944443overtricks
overweak18216073overweak_
overwears15227873overwears
overweens15247003overweens
overwets14219953overwe_ts
overworks19127393overworks
overzeals2165763overzeals
verdicts1446013_verdicts

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.453394461.4
2DLD Change Limit148641666.23323847.4
3Display Results66660.0302200.0
 (SQL Overall)178691666.71626606.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.