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 “pinwork” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
pinwork1610724(None) 
pinworks17106351pinworks
pinworm1467171pinworm
tinwork1476991tinwork
linkwork1444252linkwork
nonwork1448422nonwork
openwork1743512openwork
paintwork1843012paintwork
pinworms15115782pinworms
prework164210902prework
tinworks1596042tinworks
artwork1447083artwork
bywork1834863_bywork
cribwork1943513cribwork
cutwork16176813cutwork
daywork1845653daywork
einkorn1144223einkorn
fanwort13310733fanwort
figwort1448223figwort
finmark16154883finmark
firework1847403firework
hairwork1845073hairwork
handwork1946903handwork
inborn8319143_inborn
inform11310153_inform
intort6418923_intort
inward10310333_inward
inwove12167273_inwove
ironwork15125053ironwork
kinfolk1363603kinfolk
legwork1545653legwork
lifework1844753lifework
linkworks1544143linkworks
millwork1745523millwork
minor74920063min_or_
minors85117103min_ors
misword1338413misword
network1446793network
nonword1149153nonword
openworks1843363openworks
outwork141710353outwork
paintworks1942943paintworks
pandora1039543pandora
pandore10411853pandore
pawnor11357243pawnor_
pawnors12297203pawnors
piddock17103653piddock
piecework2043203piecework
piefort1249533piefort
pignora10306363pignora
pilewort1389123pilewort
pillory12247453pillory
pinafore1344513pinafore
pinbone1138183pinbone
pincer104019173pincer_
pincers113916503pincers
pinder94523453pinder_
pinders103720473pinders
pinery115214293pin_ery
pinewood1445403pinewood
pinfold1336233pinfold
pinger94324093pinger_
pingers104020743pingers
pingo87122713pingo__
pingoes105116523pingoes
pingos95317673pingo_s
pinhole122010433pinhole
pinier84024693pinier_
pinion83815893pinio_n
pinions93413603pinions
pink107039383pin___k
pinker125322443pinker_
pinkers134118603pinkers
pinko115618253pinko__
pinkoes135512313pinkoes
pinkos125313873pinko_s
pinner84521503pinner_
pinners93518603pinners
pinole83218783pin_ole
pinon76024533pin_o_n
pinons86019943pin_ons
pinot78737293pin_o_t
pinots85920273pin_ots
pinto75625753pinto__
pintoes95117713pintoes
pintos86021293pinto_s
pinwale1257843pinwale
pinweed1346933pinweed
pinyon11459763pinyo_n
pinyons12299003pinyons
pork106929683p___ork
preworks17599003preworks
preworn124711213preworn
princock1842833princock
rework136619783_rework
ribwort1248993ribwort
ringworm1444663ringworm
spanworm1544193spanworm
spinor839943spin_or_
spinors939423spin_ors
timework1744793timework
tinhorn1046033tinhorn
tinware1038603tinware
topwork1646343topwork
uncork1239043_uncork
unworn93411333_unworn
warwork1757573warwork
waxwork24104883waxwork
webwork1944833webwork
winnock1643893winnock
wirework1846563wirework
work115528843___work

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.1561145455.1
2DLD Change Limit1340271128.53015712.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.73220463.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.