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

75 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
overcomplicated2715291(None) 
overcomplicate25152971overcomplicate_
overcomplicates26152931overcomplicates
overcompensated2582763overcompensated
complicated2046094____complicated
noncomplicated2362614_noncomplicated
overcommitted2362724overcom_mi_tted
overcommunicate2672424overcommunicate_
overcompensate2393014overcompensate_
overcompensates2482844overcompensates
overcompliance25142624overcompli_ance
overcompliances26152474overcompliances
overmedicated2253474over__medicated
uncomplicated2253764__uncomplicated
complicate1847625____complicate_
complicates1947055____complicates
overamplified2462695over_ampli_fied
overcomplex2753025overcompl____ex
overcompressed2472715overcomp_ressed
overcorrected2163055overco_rrec_ted
overmedicate2053695over__medicate_
overmedicates2153505over__medicates
overoperated1876025over_o_p_erated
overpopulated2194415overpo_p_ulated
oversimplified2562265oversimpli_fied
complected19295866____complec_ted
complicatedly2561706____complicatedly
decompensated21122896_de_compensated
decorticated18144166_de_co_rticated
excommunicated3062456__excommunicated
explicated22106106__e___xplicated
implicated1745976_____implicated
operculated1645146operc__ul__ated
overapplication2462396over_application
overcivilized3162896overcivili__zed
overcleaned1744706overc___l_eaned
overcleared1744526overc___l_eared
overcoached2244176overco___ac_hed
overcolored1744616overco__l__ored
overcommit1954276overcom_mi__t__
overcommits2053506overcom_mi__t_s
overcompresses2372856overcomp_resses
overconstructed23112386overconstructed
overcooled1646226overco_ol____ed
overcounted1745886overco____unted
overeducated1954346over___educated
overestimated19144856over__estimated
overexplicit2663256over_explicit__
overexploited2663036over_expl_oited
overinflated1953946over_infl__ated
overlighted1944216over____lighted
overmelted1646896over__mel___ted
overoperate1676686over_o_p_erate_
overoperates17116606over_o_p_erates
overopinionated2171056over_opinionated
overplanted1746236over___pl_anted
overplayed19206756over___pl__ayed
overplied1539056over___pli___ed
overplotted1743906over___pl_otted
overpopulate19114686overpo_p_ulate_
overpopulates2094596overpo_p_ulates
overpriced18107526over___pric__ed
overprinted1785936over___pri_nted
overregulated1894416overregul__ated
oversimplifies2462506oversimpli_fies
oversimplistic2371926oversimpli_stic
overspiced1845956over__sp_ic__ed
overstimulated2093676overstimul__ated
oversupplied2072696oversuppli___ed
percolated1548226_perco__l__ated
reduplicated1853706___reduplicated
replicated1548776___r__eplicated
sextuplicated2561736_se_xtuplicated
triplicated1653936__tr__iplicated
vellicated1644806_ve____llicated

Search took 10 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.1261418182.5
2DLD Change Limit95024759.04610504.5
3Display Results75750.0461630.4
 (SQL Overall)178691759.21819385.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.