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

61 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
upflowed174289(None) 
flowed133513762__flowed
outflowed1665062outflowed
plowed124213202_p_lowed
reflowed15126902reflowed
unflawed1536122unflawed
unplowed1436352unplowed
upflow1433522upflow__
upflows1543512upflow_s
upfolded1542882upfolded
allowed111610073_allowed
beflower16166273beflower
bellowed14158603bellowed
billowed14137063billowed
blowed125016693__blowed
deflower15126073deflower
fallowed15127753fallowed
fellowed15136833fellowed
flawed134712723__flawed
flower124815503__flower
followed15146273followed
glowed114913833__glowed
hallowed15179493hallowed
hollowed15157023hollowed
lowed95233903___lowed
mellowed14166923mellowed
outglowed1444313outglowed
pillowed14156383pillowed
piloted10310323_piloted
plower114315063_p_lower
ployed124310563_p_loyed
reflower14126843reflower
reglowed13125853reglowed
replowed14127563replowed
sallowed12149033sallowed
slowed104617073__slowed
sunflower1563553sunflower
tallowed12157713tallowed
unallowed1344413unallowed
unavowed1534783unavowed
unbowed132610243u_nbowed
unclawed1457983unclawed
unclosed111010503unclosed
uncloyed1487343uncloyed
unflexed1935253unflexed
unfluted1237173unfluted
unfolded1338313unfolded
ungloved1335603ungloved
unilobed1136393unilobed
unlobed10219743u_nlobed
unloved112310533u_nloved
unsowed112511053u_nsowed
upflowing1842933upflowing
upfold12124953upf_o_ld
upload9257783up_lo_ad
uploaded1234533up_loaded
uprooted1186393uprooted
upslope1144173upslope_
wallowed15148163wallowed
willowed15156763willowed
yellowed15185743yellowed

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.1561145455.1
2DLD Change Limit146162616.81321453.4
3Display Results61610.0302033.3
 (SQL Overall)178691616.99925530.9
 
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.