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

95 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
artwork144708(None) 
artworks1546521artworks
cutwork16176812cutwork
earthwork1943682earthwork
farmwork2044182farmwork
fretwork1845682fretwork
network1446792network
outwork141710352outwork
prework164210902prework
rework136619782_rework
saltwork1545532saltwork
warwork1757572war_work
yardwork1944502yardwork
actor71116073act_or_
actors81016753act_ors
althorn1047763althorn
arbor74818113ar_bor_
arbors84717873ar_bors
ardor64617863ar_dor_
ardors74416863ar_dors
armlock1544313armlock
armor75118053ar_mor_
armors85017813ar_mors
armory114211473ar_mory
armyworm1842853armyworm
artery9911453art_ery
artier63419733artier_
attorn6310793a_ttorn
author939763author_
authors10311833authors
awlwort1356353awlwort
bywork1834863_bywork
capework1945793capework
careworn1347873careworn
casework1746763casework
craftwork2142683craftwork
cribwork1943513cribwork
cutworks17166003cutworks
cutworm14186343cutworm
daywork1845653daywork
ductwork1843553ductwork
earthworks2043563earthworks
earthworm1743223earthworm
earworm1238733ear_worm
farmworks2143843farmworks
firework1847403firework
flatwork1845393flatwork
footwork1845813footwork
formwork2044523formwork
fretworks1945103fretworks
frostwork1943493frostwork
futhork1745103futhork
hackwork1945113hackwork
hairwork1845073hairwork
handwork1946903handwork
heartworm1743313heartworm
ironwork15125053ironwork
lacework1746843lacework
lathwork1845633lathwork
legwork1545653legwork
networks1546143networks
nonwork1448423nonwork
outwore101912693outwore
outworks15148973outworks
outworn101610753outworn
paintwork1843013paintwork
partook1337313part_ook
pinwork16107243pinwork
preworks17599003preworks
preworn124711213preworn
rackwork1645583rackwork
ragwort11510733ragwort
recork126315483_recork
reword106321403_reword
rewore938030153_rewore
reworks145113593_reworks
reworn98122193_reworn
saltworks1645163saltworks
saltwort1148593saltwort
sartor6313873sart_or_
sartors7314953sart_ors
scutwork1743403scutwork
seatwork1546773seatwork
stork96819693_st_ork
taskwork1444033taskwork
tinwork1476993tinwork
topwork1646343topwork
tryworks1844603tryworks
warworks1877063war_works
warworn1357343war_worn
waxwork24104883waxwork
webwork1944833webwork
wirework1846563wirework
work115528843___work
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 Filter1786911340270.1701051123.5
2DLD Change Limit134027958.06316622.5
3Display Results95950.0332878.8
 (SQL Overall)178691958.26621617.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.