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

40 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
groundwoods175195(None) 
groundwood1652051groundwood_
roundwoods1552891_roundwoods
groundworks2052092groundworks
roundwood1443262_roundwood_
greenwoods1553023green_woods
groundhogs1651833ground_hogs
groundouts12123193ground_outs
groundwork1952193groundw_ork
ironwoods1344613iro_n_woods
roundworms1652603_roundworms
brushwoods1952554br_ushwoods
cordwoods16104774_co_rdwoods
fruitwoods1751994fr_uitwoods
godhoods1444174g_o__dhoods
greasewoods1651504greasewoods
greenwood1443084green_wood_
grounded1136574ground__ed_
grounders1156784ground__ers
groundhog1551784ground_ho_g
groundings1343744ground_ings
groundless1243474ground_less
groundlings1442074groundlings
groundmass1451934ground_mass
groundnuts12142184ground_nuts
groundout11144774ground__out
grounds9228314groun____ds
groundsels1242384ground_sels
groundswells176994groundswells
groundwater1651534groundwater
groundwaters1751464groundwaters
groupoids1342464grou__poids
gumwoods15123924g__u_mwoods
ironwood1245184iro_n_wood_
redwoods1345774_r__edwoods
rosewoods1345064_ro_sewoods
roundworm1543114_roundw_orm
sourwoods1344024_sou_rwoods
touchwoods1952734_touchwoods
woundworts1752424_woundworts

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 Filter1786911488190.423422437.4
2DLD Change Limit148819408.31317902.0
3Display Results40400.0301333.3
 (SQL Overall)178691408.76620384.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.