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

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

43 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
overviolent175410(None) 
overlent112715293over___lent
overpotent1548053over_potent
nonviolent1355154_nonviolent
ovariole1144924ovar_iole__
ovarioles1244614ovar_iole_s
overalert12411114over__alert
overbidden1743384overbidden_
overbilled1645424overbille_d
overbilling1766024overbilling
overboiled1646134overboile_d
overboiling1746844overboiling
overcooled1646234overcoole_d
overcooling1746844overcooling
overcount1448324over_co_unt
overdirect1644514overdi_rect
overfilled1745054overfille_d
overfilling1885644overfilling
overgarment17135134overgarment
overgilt1239624overgi_l__t
overidle1248824over_idle__
overkilled1844274overkille_d
overkilling1965064overkilling
overlend122510104over___lend
overlet102619034over___le_t
overmodest1645204over_modest
overpayment2154584overpayment
overplant142510714over__plant
overprotect1854574overprotect
overridden1543574overridden_
overslept1446854over__slept
overspent1449924over__spent
overtoiled1446294overtoile_d
overtoiling1547194overtoiling
overview1736334overvi__e_w
overviews1844284overvi__ews
overvote1438954overv_ote__
overvoted1637504overv_ote_d
overvotes1538424overv_ote_s
overvoting1747534overv_oting
tervalent1245574_terv_alent
ultraviolent15112794ultraviolent
violent102110814____violent

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 Filter1786911488190.423422437.4
2DLD Change Limit148819438.51317481.4
3Display Results43430.0331303.0
 (SQL Overall)178691438.96919923.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.