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

94 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
network144679(None) 
networks1546141networks
artwork1447082artwork
cutwork16176812cutwork
fretwork1845682fretwork
legwork1545652legwork
networked1742842networked
networker1643122networker
nonwork1448422nonwork
outwork141710352outwork
rework136619782re_work
seatwork1546772seatwork
webwork1944832webwork
artworks1546523artworks
beadwork1846033beadwork
bethorn1238643bethorn
betook12439603bet_ook
bettor83612223bettor_
bettors93312473bettors
beworm1339983be_worm
bywork1834863_bywork
cutworks17166003cutworks
cutworm14186343cutworm
daywork1845653daywork
deworm1249523de_worm
ductwork1843553ductwork
eelworm1245513eelworm
felwort13410573felwort
fetlock1645323fetlock
fetor81214533fet_or_
fetors91014473fet_ors
flatwork1845393flatwork
footwork1845813footwork
fretworks1945103fretworks
futhork1745103futhork
headwork1945793headwork
interwork1647073interwork
jetport1646643jetport
keyword1844553keyword
lathwork1845633lathwork
leadwork1645073leadwork
legworks1645373legworks
meshwork2043553meshwork
metalwork1843403metalwork
meteor84910073meteor_
meteors94610013meteors
nestor63713423nestor_
nestors73614973nestors
nether94014163nether_
netop7312343net_o_p
netops839213net_ops
netter63722023netter_
netters73618583netters
networkers1742633networkers
networking1842753networking
newborn1244273newborn
newer85717463ne_wer_
newton936983newto_n
newtons1036813newtons
nonnetwork1751893nonnetwork
nonword1149153nonword
nutwood1144953nutwood
openwork1743513openwork
outwore101912693outwore
outworks15148973outworks
outworn101610753outworn
overwork18118223overwork
petcock1744603petcock
pinwork16107243pinwork
prework164210903prework
recork126315483re_cork
retook104313443ret_ook
retore67630763ret_ore
retorn610923423ret_orn
retort66831143ret_ort
reword106321403re_word
rewore938030153re_wore
reworks145113593re_works
reworn98122193re_worn
saltwork1545533saltwork
scutwork1743403scutwork
seatworks1646303seatworks
stork96819693_st_ork
subnetwork1951663subnetwork
teamwork1744563teamwork
tinwork1476993tinwork
topwork1646343topwork
underwork1746413underwork
warwork1757573warwork
waxwork24104883waxwork
webworks2044663webworks
webworm1744303webworm
wetware1335793wetware
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.1431249587.4
2DLD Change Limit134027946.89019452.4
3Display Results94940.0303133.3
 (SQL Overall)178691947.06325299.6
 
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.