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

49 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
uptrends114283(None) 
uptrend1044291uptrend_
subtrends1244062subtrends
trends75513542__trends
untreads936222untreads
untrendy1243482untrendy
upends9438762up__ends
upsends10265292up_sends
appends1236393ap_pends
attends8257593_attends
bartends1136793bartends
extends15227113ext_ends
hatreds11307813hatre_ds
intends8239963int_ends
operands1146813operands
outreads9289003outreads
parents93418123_parents
pends85527193_p__ends
perpends13227743_perpends
portends11358963_portends
pyrenes123511223_pyrenes
quitrents1843883quitrents
rends65129953___rends
retreads937823retreads
spends94714473sp__ends
spreads1039763sp_reads
strands83711953_strands
subtends1136173subt_ends
subtrend1145193subtrend_
tends65425583__t_ends
treads74817923__treads
trend64817453__trend_
trendy10469603__trendy
unbends10236993u_nbends
unthreads1343633unthreads
untread857413untread_
upbinds12234813up_binds
upbraids1343553upbraids
upend85011043up__end_
uplands1036943up_lands
uprears9107493up_rears
upsend9356883up_send_
upstands1144093upstands
uptears9106453upt_ears
uptowns12194343uptown_s
upturned11214013upturned_
upturns9264973upturn_s
upwinds13224223up_winds
yearends12234483yearends

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 Filter1786911461620.203880251.2
2DLD Change Limit146162498.01618233.8
3Display Results49490.0301633.3
 (SQL Overall)178691498.24921662.1
 
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.