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 “overheated” 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
overheated173948(None) 
overhated16610441overh_ated
overheaped1946151overheaped
overbeaten1547712overbeaten
overbetted1645642overbetted
overeaten12312782over_eaten
overeater12312482over_eater
overfeared1746162overfeared
overhate14312792overh_ate_
overhates15311942overh_ates
overhead152110362overhea__d
overheard16246622overhea_rd
overheat142413772overheat__
overheats15229992overheat_s
overhunted1745172overhunted
overleaped1646302overleaped
overmelted1646902overmelted
overrated13313082over_rated
overreacted1745652overreacted
overstated14119442overstated
overtreated1547412overtreated
overwetted1745662overwetted
openhearted1752193openhearted
operated11512223oper__ated
outcheated1645253outcheated
overacted1539633over_acted
overaged13511673over__aged
overate10620963over__ate_
overawed1579973over__awed
overbaked19127833over_baked
overbeat132713833overbeat__
overbeats14279823overbeat_s
overbraked2046053overbraked
overcasted1647793overcasted
overcleaned1744713overcleaned
overcleared1744533overcleared
overdared1439163over_dared
overdecked2164603overdecked
overeager1348323over_eager
overeat102620323over_eat__
overeaters1348633over_eaters
overeats112415263over_eat_s
overedited1547213overedited
overemoted1646333overemoted
overexerted2245273overexerted
overextend2144533over_extend
overfeed15299443overfe__ed
overglazed2475413overglazed
overgoaded1655573overgoaded
overgraded1656593overgraded
overgrazed2466003overgrazed
overhand15229963overh_a_nd
overhanded1846693overhanded
overhard15238793overh_a_rd
overhauled1775403overhauled
overheads16248933overhea_ds
overheap16257343overhea__p
overheaps17226953overhea_ps
overhear14249413overhea__r
overhears15258873overhea_rs
overheating1849933overheating
overheld15197373overhe__ld
overhoped1837093overh_oped
overhyped2144153overh_yped
overladed1459223over_laded
overlate11716283over_late_
overlearned1544453overlearned
overloaded1566593overloaded
overneat112713643overneat__
overoperated1876043overoperated
overpedaled1844303overpedaled
overplanted1746233overplanted
overplayed19206753overplayed
overrate11615693over_rate_
overrates12414623over_rates
overreached2044363overreached
overroasted1545113overroasted
oversalted1447683oversalted
oversaved1638613over_saved
overscaled1646463overscaled
overseed122513353overse__ed
overseeded1545453overseeded
oversewed1636943overse_wed
oversexed2037213overse_xed
overshaded1845843overshaded
oversoaked1845823oversoaked
overstate121010863overstate_
overstates131110113overstates
overstayed17125853overstayed
overtaxed20117243over_taxed
overtraded1557073overtraded
overvoted1637503over_voted
overwater1538073over_water
overwearied1845763overwearied
overweened1744883overweened
overwhelmed2352253overwhelmed
permeated1439363_permeated
preheated1539813pre_heated
reheated122415003_re_heated
superheated1746663superheated
underheated1647013underheated

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.1561145455.1
2DLD Change Limit1406031016.53021531.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.73226543.5
 
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.