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

88 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
handwork194690(None) 
handiwork2043011handiwork
handworks2046701handworks
hackwork1945112hackwork
hairwork1845072hairwork
handbook1844732handbook
handiworks2142692handiworks
handworker2143212handworker
headwork1945792headwork
sandworm1446342sandworm
sandwort12410082sandwort
yardwork1944512yardwork
artwork1447093_artwork
bandora1038813band_ora
bandore10611633band_ore
beadwork1846033beadwork
candor94516423cand_or_
candors104216763cand_ors
capework1945803capework
casework1746773casework
danewort1258243danewort
daywork1845653da_ywork
fancywork2451953fancywork
fanwort13310733fan_wort
farmwork2044193farmwork
hackworks2045203hackworks
haddock1885583ha_ddock
hairworks1944843hairworks
hairworm1644543hairworm
handbooks1944393handbooks
handcar1337373handcar_
handcars1437623handcars
handcart1449323handcart
hander104526433hand_er_
handers114224333hand_ers
handhold1645633handhold
handier113817443handier_
handler113516163handler_
handlers124014143handlers
handloom1444613handloom
handoff1756483hand_off
handout11314103hand_out
handpick2043843handpick
handsome1447603handsome
handworkers2252613handworkers
handwoven1943213handwoven
handwrit1547243handwrit
handwrote1644123handwrote
hardcore1446053hardcore
hardware1546283hardware
hardwire1544623hardwire
hardwood16155743hardwood
hayfork2043763ha_yfork
headword1645523headword
headworks2045953headworks
homework2045833homework
honewort14410083honewort
lacework1746853lacework
landform1445223landform
landlord1045163landlord
landmark1544153landmark
landward1345823landward
lathwork1845633lathwork
leadwork1645073leadwork
linkwork1444253linkwork
madwort13611363ma_dwort
nonwork1448423non_work
paintwork1843013paintwork
pandoor10358583pandoor_
pandoors11258983pandoors
pandora1039543pand_ora
pandore10411853pand_ore
pinwork16107243pin_work
rackwork1645583rackwork
roadwork1645473roadwork
saltwork1545543saltwork
sandworms1545653sandworms
sandworts1346453sandworts
studwork1643693studwork
tandoor8278563tandoor_
tandoori9244773tandoori
tandoors9258053tandoors
taskwork1444033taskwork
tinwork1476993tin_work
warwork1757583wa_rwork
waxwork24104883wa_xwork
woodwork1955933woodwork
yardworks2044483yardworks

Search took 8 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.420425454.8
2DLD Change Limit146162887.29620033.2
3Display Results88880.0332666.7
 (SQL Overall)178691887.74923059.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.