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

44 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
subtrends124406(None) 
subtends1136171subt_ends
subtrend1145191subtrend_
subbreeds1443572subbreeds
subrents10310292sub_rents
subteens1037422subteen_s
subtend1037102subt_end_
subtrahends1751722subtrahends
uptrends1142832_uptrends
outbreeds1244223outbreeds
outreads9289003ou_treads
quitrents1843893quitrents
strands83711953s__trands
subagents1245003subagents
subareas1038623subare_as
subbreed1345873subbreed_
suberins10315093suberin_s
subfields1543303subfields
subgenus1145753sub_genus
subheads1496533sub_heads
submenus1245903sub_menus
suborned1137303suborned_
suborners1146313suborners
suborns939493subor_n_s
subpenas1246903sub_penas
subpoenas1344413subpoenas
subrent9315083sub_ren_t
subrings11229883sub_rings
subteen938523subteen__
subtended1345153subt_ended
subtests1037533subt_ests
subtexts1744903subt_exts
subthemes1644113subthemes
subtleness1245443subtleness
subtones10311383subt_ones
subtracts1346363subtracts
subtrahend1652653subtrahend_
subtribes1346233subtribes
subvenes1339633sub_venes
suspends1145143su_spends
trends75513543___trends
untreads936223_untreads
untrendy1243483_untrendy
uptrend1044293_uptrend_

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit148641446.23323847.4
3Display Results44440.0162750.0
 (SQL Overall)178691446.67226782.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.