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

46 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
hackworks204520(None) 
hackwork1945111hackwork_
rackworks1745541rackworks
hairworks1944842hairworks
handworks2046702handworks
laceworks1846582laceworks
rackwork1645582rackwork_
rockworks1744872rockworks
taskworks1543902taskworks
artworks1546523_artworks
backswords2243813backswords
backwards2147463backwards
backwoods2146393backwoods
brickworks2053053brickworks
capeworks2045633capeworks
caseworks1846413caseworks
clockworks2052653clockworks
coachworks2443063coachworks
dayworks1945563da_yworks
ductworks1943353ductworks
fancyworks2551913fancyworks
farmworks2143843farmworks
gasworks1645943ga_sworks
hackamores2152423hackamores
hackers164619043hack_er_s
hacklers173710303hackler_s
hairwork1845073hairwork_
hairworms1743973hairworms
handiworks2142693handiworks
handwork1946903handwork_
hayforks2143423ha_yforks
headworks2045953headworks
homeworks2145763homeworks
hookworms2143783hookworms
lacework1746853lacework_
lathworks1945193lathworks
linkworks1544143linkworks
muckworms2242943muckworms
patchworks2443553patchworks
rockwork1644993rockwork_
saltworks1645173saltworks
stickworks18113333stickworks
taskwork1444033taskwork_
warworks1877063wa_rworks
waxworks25114723wa_xworks
yardworks2044483yardworks

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 Filter1786911486410.423422437.4
2DLD Change Limit148641467.56019661.5
3Display Results46460.0162875.0
 (SQL Overall)178691467.99922339.2
 
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.