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

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

121 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
piecework204320(None) 
pieceworks2143071pieceworks
pieceworker2251432pieceworker
fieldwork2062213fieldwork
firework1847403fi_rework
lacework1746843_lacework
lifework1844753li_fework
patchwork2343893patchwork
piecer105213083piece__r_
piecers114112253piece__rs
piecewise1641993piecewise
pieceworkers2361233pieceworkers
pilewort1389123pi_lewort
pinwork16107243pi__nwork
pitchfork2352543pitchfork
presswork1854523presswork
prework164210903p__rework
timework1744793ti_mework
wirework1846563wi_rework
beadwork1846034_beadwork
brickwork1943104brickwork
bridgework2151684bridgework
capework1945794_capework
casework1746764_casework
clockwork1942624clockwork
coachwork2343284coachwork
crewelwork2251264crewelwork
ductwork1843554_ductwork
falsework1943264falsework
fancywork2451954fancywork
fieldworks2162354fieldworks
fireworks1946544fi_reworks
fireworm1646684fi_reworm
framework2143404framework
fretwork1845684fre_twork
guesswork1752064guesswork
hackwork1945114_hackwork
headwork1945794_headwork
homework2045824_homework
housework1944524housework
inchworm1843094_inchworm
interwork1647074_interwork
ironwork15125054_ironwork
laceworks1846584_laceworks
leadwork1645074_leadwork
legwork1545654_le_gwork
lifeworks1944434li_feworks
linkwork1444254li_nkwork
meshwork2043554_meshwork
millwork1745524mi_llwork
mitrewort1465284mitrewort
needlework1851464needlework
network1446794_ne_twork
openwork1743514ope_nwork
overwork18118224ove_rwork
paintwork1843014paintwork
paperwork2044314paperwork
patchworks2443554patchworks
picador1245924pi_cador_
picadors1345854pi_cadors
piceous11310694pi_ce_ous
piciform1764994pi_ciform
picklock1743614pi_cklock
pickwick2042294pi_ckwick
piece96717994piece____
pieced113912104piece___d
piecemeal1552084piecemeal
pieces104217274piece___s
piedfort1444874pie_dfort
piefort1249534pi__efort
piercer11337774pierce__r_
piercers12316724pierce__rs
pileworts1495354pi_leworts
pincer104019174pince__r_
pincers113916504pince__rs
pinchcock2151904pinchcock
pinewood1445404pi_newood
pinworks17106354pi__nworks
pinworm1467174pi__nworm
piscator1246924piscator_
piscators1347084piscators
piscatory1645274piscatory
pisciform1843254pisciform
piscivore1652364piscivore
pitchforks2452374pitchforks
poechore1547854poec_hore
precatory1649114precatory
precensor1345254precensor_
precensors1445464precensors
precentor1348734precentor_
precentors1488344precentors
preceptor1547324preceptor_
preceptors1657054preceptors
preceptory1945484preceptory
precook1577804prec__ook
prerecord1444174prerecord
prereform1644294prereform
pressworks1954124pressworks
preworks17599004p__reworks
preworn124711214p__reworn
rackwork1645584_rackwork
recork126315484_rec__ork
rework136619784___rework
rockwork1644994_rockwork
seatwork1546774_seatwork
shellwork1943244shellwork
spadework19133584spadework
steelwork1643544steelwork
stickwork17133434stickwork
stonework1644084stonework
teamwork1744564_teamwork
timberwork2152054timberwork
timeworks1844754ti_meworks
timeworn1344224ti_meworn
tinwork1476994ti__nwork
tubework1744734_tubework
webwork1944834_we_bwork
wheelwork2243154wheelwork
wickerwork2151934wickerwork
wireworks1946014wi_reworks
wireworm1645884wi_reworm

Search took 18 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 Filter1786911653290.423422437.4
2DLD Change Limit16532912116.8909788.6
3Display Results1211210.0462630.4
 (SQL Overall)17869112117.35910293.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.