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

56 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
overtreating164855(None) 
overbeating17410482over_beating
overbreathing22173672overbreathing
overeating141016532ove__reating
overheating1849932over_heating
overrating14814202over_r_ating
overreacting1856662over_reacting
overtrading1648262overtr_ading
entreating11811553__entreating
estreating11710363__estreating
overbearing1748423over_bearing
overbetting1747453over_betting
overbraking2147143overbr_aking
overbreathings23171673overbreathings
overbreeding1944443overbreeding
overcleaning1844933overcleaning
overclearing1845153overclearing
overdirecting2053743overdirecting
overdrawing1956683overdr_awing
overdressing1745733overdressing
overexerting2346493overexerting
overfearing1847553over_fearing
overgrading1747513overgr_ading
overgrazing2566773overgr_azing
overhating17910953ove__rhating
overheaping2046793over_heaping
overhearing1847843over_hearing
overleaping1747443over_leaping
overletting1548013over_letting
overmelting1768113over_melting
overoperating1956723overoperating
overprinting1846873overprinting
overreaching2175173over_reaching
overroasting1646093over_roasting
oversetting1548813over_setting
overspreading2053603overspreading
overstating15410733over_stating
overstressing1753713overstressing
overstrewing1944673overstre_wing
overtaking1878893overt__aking
overtaxing2157693overt__axing
overteaching2174923overt_eaching
overtrain1259783overtr_a_in_
overtraining1646023overtraining
overtrains13109503overtr_a_ins
overtreat1249373overtreat___
overtreated1547413overtreat_ed
overtreatment1863763overtreatment
overtreats1346643overtreat__s
overtrimming2053743overtrimming
overtrumping2053333overtrumping
overwearing1847713over_wearing
overwetting1847253over_wetting
overwriting1847903overwr_iting
pretreating1448893pre_treating
retreating111414773_re_treating

Search took 4 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 Filter178691950240.360496363.9
2DLD Change Limit95024563.42027784.8
3Display Results56560.0331697.0
 (SQL Overall)178691563.81346863.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.