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

132 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
overacting1631091(None) 
operating12313722opera_ting
overaction1547992overaction
overactions1648212overactions
overactive1847262overactive
overarching2056892overarching
overarming1639232overarming
overawing16710292overa_wing
overcasting1748512overcasting
overeating141016532overeating
overhating17910952overhating
overpacking2346532overpacking
overrating14814202overrating
overreacting1856662overreacting
oversalting1548572oversalting
overvoting1747532overvoting
abreacting1544533abreacting
aerating92821003_aera_ting
attracting1346563attracting
averaging1446503avera_ging
averting122512733aver__ting
berating113220763_bera_ting
coenacting1545873coenacting
coerecting15218783coerecting
contracting16610473contracting
covenanting1743013covenanting
derating103222283_dera_ting
deratting1139513_deratting
detracting1438713detracting
enacting11311363__enacting
erecting112415063__erecting
eructing112110173__eructing
everlasting1543863everlasting
everting122213133ever__ting
exacting1838523__exacting
extracting2047223extracting
infracting1647353infracting
interacting14411713interacting
iterating10314253itera_ting
moderating1448803modera_ting
obverting1536303obver__ting
operagoing1443583operagoing
orating83520323o__ra_ting
outacting1239213o_utacting
outracing12912163outrac_ing
outrating10916403outra_ting
overact12315043overact___
overacted1539633overact_ed
overacts1339653overact__s
overbaking2067773overbaking
overbeating17410483overbeating
overbetting1747453overbetting
overbuying1945343overbuying
overcalling1747323overcalling
overcastings1853953overcastings
overcoaching2344503overcoaching
overcoming1848733overcoming
overcuring16108763overcuring
overcutting1746823overcutting
overdaring1539503overdaring
overdecking2246053overdecking
overdoing1439143over_doing
overdosing1547543overdosing
overdrying1846543overdrying
overdyeing1845083overdyeing
overediting1648043overediting
overemoting1747313overemoting
overexciting2565333overexciting
overflying2045463overflying
overhanding1947023overhanding
overhanging1946323overhanging
overhauling1846033overhauling
overheating1849933overheating
overhoping1947043overhoping
overhunting1856523overhunting
overhyping2244713overhyping
overing111918053over___ing
overjoying2445143overjoying
overlading1539323overlading
overlapping1945413overlapping
overlaying1738443overlaying
overletting1548013overletting
overliving1747393overliving
overloving1746633overloving
overlying1638003over_lying
overmanning1745943overmanning
overmatching2353673overmatching
overmelting1768113overmelting
overmining1649113overmining
overmixing2346413overmixing
overpassing1746643overpassing
overpaying1937953overpaying
overplanting1846973overplanting
overplying1946513overplying
overreaching2175173overreaching
overriding1548513overriding
overroasting1646093overroasting
overruling1467613overruling
oversaucing1746263oversaucing
oversaving1738163oversaving
overscoring1746833overscoring
overseeing1438383overseeing
oversetting1548813oversetting
oversewing1747433oversewing
overstating15410733overstating
overswing1638453over_swing
overtaking1878893overtaking
overtalking1976693overtalking
overtasking1986153overtasking
overtaxing2157693overtaxing
overteaching2174923overteaching
overtiming1699073overtiming
overtiring141210203overtiring
overturing1499413overturing
overurging1547113overurging
overusing1339043over_using
overvaluing1845283overvaluing
overwarming2046303overwarming
overwatching2453403overwatching
overwetting1847253overwetting
overwriting1847903overwriting
ovulating1336953ovula_ting
preacting142412533pre_acting
reacting113317893_re_acting
redacting13612303_redacting
reenacting1357353reenacting
reerecting1339973reerecting
refracting1638733refracting
reracking1639313_reracking
retracting13311933retracting
tolerating1148593tolera_ting
underacting1547523underacting

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 Filter1786911406030.813219792.1
2DLD Change Limit1406031327.36019103.7
3Display Results1321320.0632095.2
 (SQL Overall)1786911328.23621696.3
 
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.