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

71 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
overteach174500(None) 
overreach1745501overreach
overbleach2042552overbleach
overcoach1944792overcoach
overreact1448402overreact
overteaches1944102overteaches
forereach1743663forer_each
outreach1346003outr_each
overact12315043over__act
overarch1647243over_arch
overbear13228883overbea_r
overbears14208483overbears
overbeat132713833overbea_t
overbeats14279823overbeats
overdear12248083overdea_r
overdeck1835223overde_ck
overeasy1437153over_easy
overeat102620323over_ea_t
overeats112415263over_eats
overfear14247403overfea_r
overfears15236943overfears
overhead152110363overhea_d
overheads16248933overheads
overheap16257343overhea_p
overheaps17226953overheaps
overhear14249413overhea_r
overheard16246623overheard
overhears15258873overhears
overheat142413773overhea_t
overheats15229993overheats
overleaf14237973overlea_f
overleap13237833overlea_p
overleaps14226783overleaps
overleapt14247883overleapt
overlearn1235903overlearn
overmatch1944243overmatch
overmuch1844083over_much
overnear11238473overnea_r
overneat112713643overnea_t
overpack1966623over_pack
overrash1436953over_rash
overreached2044363overreached
overreacher1953033overreacher
overreaches1944523overreaches
overreacts1545433overreacts
overrich1648453over_rich
oversea102412113oversea__
overseas112612423oversea_s
overstretch1952693overstretch
overtake151210143overt_ake
overtalk1537073overt_alk
overtame131510523overt_ame
overtart11312493overt_art
overtask1535773overt_ask
overtax17257733overt_a_x
overteaching2174923overteaching
overthick2143323overthick
overtrade1348513overtrade
overtrain1259783overtrain
overtreat1249373overtrea_t
overtreats1346643overtreats
overtrick1865833overtrick
overwatch2043833overwatch
overweak18216073overwea_k
overwear14248603overwea_r
overwears15227873overwears
overweary18255413overweary
overweigh1945523overweigh
overzeal2076093overzea_l
overzeals2165763overzeals
reteach1237413_re_teach

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.420425454.8
2DLD Change Limit148641716.33023482.0
3Display Results71710.0302366.7
 (SQL Overall)178691716.78026355.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.