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

68 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
windflowers2111275(None) 
wildflowers21112661wildflowers
windflower20133011windflower_
mindblowers1951512mindblowers
twinflowers2051952twin_flowers
wildflower20112742wildflower_
windrowers1743842wind_rowers
coneflowers19113153coneflowers
mindblower1851533mindblower_
sunflowers1683263sun_flowers
twinflower1951993twin_flower_
wallflowers2052403wallflowers
widowers1535113wi_d__owers
wildfowlers21131563wildf_owlers
willowers15166693wi__llowers
windflaws1942403windflaw__s
windhovers2042213wind_hovers
windrower1644223wind_rower_
winegrowers1851973winegrowers
winnowers1543953win__nowers
beflowers17165824__beflowers
bellflowers1952264bellflowers
coneflower1873214coneflower_
cornflowers1952584cornflowers
dayflowers2052414_dayflowers
deflowers16145644__deflowers
endowers1238234_end__owers
flowers133413174____flowers
foamflowers2252134foamflowers
gillyflowers2261204gillyflowers
inclosers11155564_in_closers
indulgers1143804_indul_gers
inflamers1455214_in_flamers
inflaters1247544_in_flaters
inflows1335524_in_flow__s
infolders1385174_in_folders
kindlers13318484kind_l__ers
landlopers1343674land_lopers
mayflowers2152474_mayflowers
minitowers1572864min_itowers
moonflowers1952164moonflowers
reflowers15125984__reflowers
safflowers1942804_safflowers
starflowers1772374starflowers
sunflower1563554sun_flower_
swindlers13306034swind_l__ers
wallflower1952534wallflower_
wallowers15127654w__allowers
widower1435344wi_d__ower_
wildfowler2081594wildf_owler_
wildfowls1952084wildf_ow_ls
willower14127454wi__llower_
willpowers1842894wi_llpowers
windblown1851794windblow__n
winders113721264wind____ers
windflaw1842294windflaw___
windhover1942464wind_hover_
windjammers2661524windjammers
windles113518494wind_l__e_s
windless123310864wind_l__ess
windowed1635574wind__owe_d
windowless1742354wind__owless
windows1447744wind__ow__s
windrowed1743714wind_rowe_d
windrows1546164wind_row__s
winegrower1752264winegrower_
wingovers1643554win__govers
winnower1444254win__nower_

Search took 10 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.436409841.7
2DLD Change Limit148819688.79616918.9
3Display Results68680.0332060.6
 (SQL Overall)178691689.26519286.7
 
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.