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

87 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
tinwork147699(None) 
pinwork16107241pinwork
tinworks1596041tinworks
linkwork1444252linkwork
nonwork1448422nonwork
pinworks17106352pinworks
pinworm1467182pinworm
timework1744802timework
tinhorn1046032tinhorn
tinware1038602tinware
topwork1646342topwork
artwork1447093artwork
bywork1834863_bywork
cribwork1943523cribwork
cutwork16176823cutwork
daywork1845653daywork
einkorn1144223einkorn
fanwort13310733fanwort
figwort1448223figwort
finmark16154883finmark
firework1847413firework
hairwork1845073hairwork
handwork1946903handwork
inborn8319143_inborn
inform11310153_inform
intort6418923_intort
inward10310333_inward
inwove12167273_inwove
ironwork15125063ironwork
kinfolk1363603kinfolk
legwork1545663legwork
lifework1844763lifework
linkworks1544143linkworks
millwork1745523millwork
minor74920063min_or_
minors85117103min_ors
misword1338413misword
network1446803network
nonword1149153nonword
openwork1743523openwork
outwork141710353outwork
paintwork1843013paintwork
pinworms15115783pinworms
prework164210913prework
rework136619793_rework
ribwort1249003ribwort
ringworm1444673ringworm
stickwork17133443stickwork
stonework1644093stonework
studwork1643693studwork
tanbark1337373tanbark
taskwork1444033taskwork
teamwork1744563teamwork
tenor53620253ten_or_
tenors63217753ten_ors
tensor63812673tensor_
tensors72712373tensors
timeworks1844753timeworks
timeworn1344233timeworn
tinder73821803tinder_
tinders84219173tinders
tindery11389363tindery
tinfoil1044633tinfoil
tinhorns1145013tinhorns
tinier63622233tinier_
tinker103619923tinker_
tinkers113517143tinkers
tinner64119963tinner_
tinners73717313tinners
tinpot8312513tinpo_t
tinter63923643tinter_
tinters74221113tinters
tinwares1137913tinwares
titlark1144723titlark
toilworn1143583toilworn
topworks1745343topworks
tryworks1844603tryworks
tubework1744743tubework
twinborn1341903twinborn
uncork1239043_uncork
unworn93411333_unworn
warwork1757583warwork
waxwork24104883waxwork
webwork1944843webwork
winnock1643893winnock
wirework1846573wirework
work115528843___work

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 Filter1786911340270.406440125.6
2DLD Change Limit134027876.75019855.9
3Display Results87870.0461891.3
 (SQL Overall)178691877.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.