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

76 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
legwork154566(None) 
legworks1645371legworks
leadwork1645072leadwork
leghorn1146222leghorn
lugworm1344902lugworm
network1446802network
rework136619792re_work
webwork1944842webwork
artwork1447093artwork
bagworm1566353bagworm
beadwork1846033beadwork
beworm1339993be_worm
bywork1834863_bywork
cutwork16176823cutwork
daywork1845653daywork
deworm1249533de_worm
eelworm1245523eelworm
felwort13410583felwort
figwort1448223figwort
flatwork1845393flatwork
fleawort1447023fleawort
fretwork1845693fretwork
headwork1945793headwork
keyword1844563keyword
lacework1746853lacework
lathwork1845633lathwork
leadworks1745123leadworks
leadwort1247473leadwort
leafworm1653913leafworm
lector83514983lector_
lectors93415763lectors
leeward1135783leeward
legator83011133legator_
legators92811033legators
leger65721513leg_er_
legers74518313leg_ers
leghorns1244903leghorns
legion75712983legio_n
legions84611783legions
legong836963leg_ong
legroom1076093legroom
lessor64010603lessor_
lessors73610523lessors
lifework1844763lifework
linkwork1444253linkwork
lobworm1445253lobworm
logbook1454513logbook
logwood1255573logwood
lugworms1443893lugworms
lungworm1443853lungworm
lungwort1245493lungwort
meshwork2043553meshwork
mugwort1346753mugwort
networks1546143networks
nonwork1448423nonwork
openwork1743523openwork
outwork141710353outwork
overwork18118233overwork
pinwork16107243pinwork
prework164210913prework
ragwort11510743ragwort
recork126315493re_cork
reword106321413re_word
rewore938030163re_wore
reworks145113603re_works
reworn98122203re_worn
seatwork1546783seatwork
slopwork1743723slopwork
teamwork1744563teamwork
tinwork1476993tinwork
topwork1646343topwork
warwork1757583warwork
waxwork24104883waxwork
webworks2044663webworks
webworm1744313webworm
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.453394461.4
2DLD Change Limit134027766.59320328.7
3Display Results76760.0332303.0
 (SQL Overall)178691767.07925242.4
 
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.