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 “ironweed” 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
ironweed124405(None) 
ironweeds1342781ironweeds
ironed74916012iron__ed
ironized1858202ironized
ironwood1245182ironwood
bronzed19308213bron_zed
browed125216393bro_w_ed
browned134710973bro_wned
browsed134511233bro_wsed
congeed113212313_congeed
crowded14418793cro_wded
crowed124717303cro_w_ed
crowned133912433cro_wned
droned84616863dron__ed
drownded14334433drownded
drowned12419903dro_wned
drowsed12448743dro_wsed
fireweed1545353fir_eweed
fronded12388863fron_ded
fronted114011273fron_ted
frowned14348833fro_wned
growled12278173gro_wled
hogweed1534443_hogweed
indeed83913563i__ndeed
ionised82911493i_onised
ionized172611293i_onized
ironclad1143093ironclad
irone55126363iron__e_
ironer64216453iron__er
ironers74813553iron_ers
irones64724013iron__es
ironies7517423iron_ies
ironize16610373ironize_
ironizes17510373ironizes
ironmen936453iron_men
ironness836953ironness
ironside945853ironside
ironware1144653ironware
ironwares1244553ironwares
ironwomen1443983ironwomen
ironwoods1344613ironwoods
ironwork15125063ironwork
jimsonweed235613jimsonweed
knotweed1642103knotweed
moonseed1154673moonseed
pinweed1346933_pinweed
pondweed1543103_pondweed
proceed12310553pro_ceed
pronated11414053pronated
pronged113912393pron_ged
prowled13309913pro_wled
ragweed1235073_ragweed
renewed11309993_renewed
richweed17163583richweed
rockweed1843313_rockweed
rosinweed1341713_rosinweed
rowed94034323_ro_w_ed
roweled11269863_ro_weled
trowed104714653tro_w_ed
troweled12106113tro_weled
wronged12397673wron_ged

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.423422437.4
2DLD Change Limit146162618.06318127.5
3Display Results61610.0134692.3
 (SQL Overall)178691618.49921024.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.