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 “overlengthening” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
overlengthening237139(None) 
overlengthen1972093overlengthe__n_
overlengthened2271513overlengthen_ed
overlengthens2071993overlengthe__ns
lengthening1652444____lengthening
overtightening2261804over_tightening
strengthening1862004_str_engthening
overengineering2071545over_engineering
overextending2553915over_e_xt_ending
overlearning1644715overle___arning
overlending1647615overlen____ding
overlength1762995overlength_____
overlengths1862015overlength____s
overletting1548015overle__t__ting
overlighting2044435overl_ig_h_ting
oversweetening2171865oversweet_ening
overweening1846235overwe____ening
overweighing2353705overweig_h__ing
overweighting2453135overweig_h_ting
overwintering2053055overwin_t_ering
restrengthening2091055restrengthening
enlightening1751726__enl_ightening
orienteering1352616o__rien_teering
overbeating17410486overbe_at___ing
overbetting1747456overbe__t__ting
overbleaching2452396overble_ach__ing
overbreathing22173676overbreath__ing
overburdening2052016over__burdening
overcleaning1844936overcle____aning
overconcerning2262426overcon_cerning
overdesigning1952716overde__signing
overeating141016536over_e_at___ing
overediting1648046over_edit___ing
overemoting1747316over_emot___ing
overexplaining2772476over_explaining
overfeeding1945916overfe____eding
overgoverning2162696over___governing
overhanging1946326overhang____ing
overheating1849936overhe_at___ing
overhunting1856526overhun_t___ing
overidentifying2671466overiden_tifying
overleaping1747446overle____aping
overmanning1745946overman____ning
overmastering1953356over_mast_ering
overmelting1768116overme_lt___ing
overnighting2054256over__nigh_ting
overornamenting2181536overorn_amenting
overplanning1844566overplan____ning
overplanting1846976overplan_t___ing
overreaching2175176overre_ach__ing
overreacting1856666overreact___ing
overregulating1963796overre_gulating
overrunning1545056overrun____ning
overseeding1647006overse____eding
overseeing1438386overse____e_ing
oversetting1548816overse__t__ting
overslaughing2152086overslaug_h__ing
oversleeping1843816oversle____eping
oversteering1645316over___steering
overstrewing1944676over___strewing
overteaching2174926overte_ach__ing
overthinking2343496over____thinking
overturning1545976over____turning
overwatering1954936over__wat_ering
overwetting1847256overwe__t__ting
unenlightening197716unenl_ightening

Search took 8 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 Limit95024666.65614276.4
3Display Results66660.0461434.8
 (SQL Overall)178691667.06225303.2
 
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.