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

53 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
overwetted174566(None) 
overbetted1645641overbetted
overheated1739482overheated
overmelted1646902overmelted
overweened1744882overweened
overacted1539633over_acted
overbeaten1547713overbeaten
overcasted1647793overcasted
overdecked2164603overdecked
overeaten12312783over_eaten
overeater12312483over_eater
overedited1547213overedited
overemoted1646333overemoted
overexerted2245273overexerted
overextend2144533over_extend
overfeared1746163overfeared
overfeed15299443overfe__ed
overhated16610443over_hated
overheaped1946153overheaped
overhunted1745173overhunted
overleaped1646303overleaped
overplotted1743903overplotted
overrated13313083over_rated
overreacted1745653overreacted
oversalted1447683oversalted
overseed122513353overse__ed
overseeded1545453overseeded
oversewed1636943overse_wed
oversexed2037223overse_xed
overstated14119443overstated
oversweeten1753513oversweeten
overtreated1547413overtreated
overvoted1637503over_voted
overwarmed1945353overwarmed
overwatched2343063overwatched
overwater1538073overw_ater
overwatered1843653overwatered
overwearied1845763overwearied
overween14218513overwe__en
overweighed2253963overweighed
overweighted2353473overweighted
overwet132013933overwe_t__
overwets14219953overwe_t_s
overwetting1847253overwetting
overwhelmed2352253overwhelmed
overwinter1644443overwinter
overworked2145183overworked
overwrite1579083overwrite_
overwrites1658113overwrites
overwritten1773183overwritten
overwrote1557693overwrote_
rewetted12228353_re_wetted
somersetted1451633somersetted

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 Filter1786911406030.423422437.4
2DLD Change Limit140603536.50021631.2
3Display Results53530.0331606.1
 (SQL Overall)178691536.95625688.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.