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

58 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
wildflowers2111266(None) 
wildflower20112741wildflower_
windflowers21112751windflowers
wallflowers2052402wallflowers
wildfowlers21131562wildf_owlers
willowers15166692wil__lowers
windflower20133012windflower_
bellflowers1952263bellflowers
gillyflowers2261203gillyflowers
mindblowers1951513mindblowers
twinflowers2051953twi_nflowers
wallflower1952533wallflower_
wallowers15127653wal__lowers
widowers1535113wi_d__owers
wildfowler2081593wildf_owler_
wildfowls1952083wildf_ow_ls
willower14127453wil__lower_
willpowers1842893wil_lpowers
windrowers1743843wind_rowers
beflowers17165824__beflowers
bellflower1852404bellflower_
bellowers14177624bel__lowers
cauliflowers2061464cauliflowers
coneflowers19113154coneflowers
cornflowers1952584cornflowers
dayflowers2052414_dayflowers
deflowers16145644__deflowers
flowers133413174____flowers
foamflowers2252134foamflowers
followers15146184fol__lowers
gillyflower2161234gillyflower_
hallowers15137724hal__lowers
mayflowers2152474_mayflowers
mindblower1851534mindblower_
moonflowers1952164moonflowers
reflowers15125984__reflowers
safflowers1942804_safflowers
starflowers1772374starflowers
sunflowers1683264_sunflowers
swallowers1653814swal__lowers
twinflower1951994twi_nflower_
wallopers14136274wal__lopers
wallower14158934wal__lower_
widower1435344wi_d__ower_
wildcatters1751434wildcatters
wilders113513504wild____ers
wildfires1642834wildf_ire_s
wildfowl1842244wildf_ow__l
willers103517914wil__l__ers
willowed15156764wil__lowe_d
willowier1563784wil__lowier_
willows13299754wil__low__s
willpower1773184wil_lpower_
windflaws1942404windflaw__s
windhovers2042214wind_hovers
windrower1644224wind_rower_
winegrowers1851974winegrowers
winnowers1543954wi__nnowers

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.453394461.4
2DLD Change Limit148819588.78316944.0
3Display Results58580.0301933.3
 (SQL Overall)178691589.26619284.6
 
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.