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

48 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
convexly234378(None) 
convex18367742convex__
convexes20278272convexes
convexity2443312convexity
convey144610222conve__y
cleverly1643463cleverly
coevally1646283coevally
comely134213733co_me_ly
complexly2543063complexly
concavely1943673concave_ly
conceal113313013conceal_
conceals123111013conceals
coney105932883con_e__y
congeal104011683congeal_
congeals11309853congeals
context163913433contex_t
contexts17378653contexts
convect143114483conve_ct
convects153410993convects
convene123314323conve_ne
convened143412223convened
convener132913163convener
convenes132916913convenes
convenor13307613convenor
convent123919413conve_nt
convents132614603convents
converge1437393converge
converse13310263converse
conversely1844903conversely
converso1336423converso
convert123721473conve_rt
converts133213553converts
conveyed17247923conveyed
conveyer16278143conveyer
conveyor16245293conveyor
conveys15308223conve_ys
convoy14348543conv__oy
covertly1655763co_vertly
covey136121783co_ve__y
cowedly1635703co_wedly
cravenly1644663cravenly
curvedly1743513curvedly
lonely92912473lon_e_ly
lovely12339713lo_ve_ly
loverly1346973lo_verly
novelly1346513no_velly
overly122411363_o_verly
wontedly1544253wontedly

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 Filter1786911461620.420425454.8
2DLD Change Limit146162486.84621350.0
3Display Results48480.0133692.3
 (SQL Overall)178691487.27924548.8
 
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.