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

144 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
preworks1759901(None) 
prework164210911prework_
reworks145113601_reworks
artworks1546522artworks
fireworks1946552fireworks
fretworks1945112fretworks
pinworks17106352pinworks
prebooks1656302prebooks
precooks1656762precooks
preforms1537412preforms
presoaks1436602presoaks
presorts105311682presorts
pressworks1954122pressworks
pretors9316812pretor_s
prewarms15406732prewarms
prewarns13456942prewarns
prewires133811012prewires
preworked1954652preworked
preworn124711222prewor_n
recorks134813022_recorks
rewords115413982_rewords
rework136619792_rework_
tryworks1844602tryworks
wireworks1946022wireworks
artwork1447093artwork_
beworms1437933_beworms
brewers123811063brewer_s
byworks1944543_byworks
capeworks2045633capeworks
caseworks1846413caseworks
cribworks2043383cribworks
cutworks17166003cutworks
dayworks1945563dayworks
deworms1338033_deworms
farmworks2143843farmworks
firework1847413firework_
fireworms1745603fireworms
forewords16117403forewords
formworks2144133formworks
frameworks2243263frameworks
fretwork1845693fretwork_
gasworks1645943gasworks
homeworks2145763homeworks
ironworks16114813ironworks
laceworks1846583laceworks
legworks1645373legworks
lifeworks1944433lifeworks
networks1546143networks
openworks1843363openworks
outworks15148973outworks
overworks19127393overworks
paperworks2144073paperworks
pelorus939273p_elorus
performs1547493performs
perks115325803p_e__rks
pieceworks2143073pieceworks
pieforts1344863pieforts
pileworts1495353pileworts
pinwork16107243pinwork_
pinworms15115783pinworms
plexors1645423plexor_s
porks115124143p___orks
praetors1039833praetor_s
prearms11369173pre_arms
preboards1446423preboards
preboils1267293preboils
prebook1557523prebook_
precodes13711573precodes
precook1577803precook_
precools1237703precools
precures12312903precures
predusks1543423predusks
prefers123713333prefer_s
prefires134313283prefires
prefocus1544743prefocus
preform1439623prefor_m
preloads1157513preloads
premolds1345843premolds
premoral1249713premoral
premorse1237553premorse
preops104911943pre_o_ps
preoral9312673pre_oral
prepacks1836583prepacks
prepares122014163prepares
prerock1536723prerock_
prescores133912173prescores
presoak1348453presoak_
presort95219543presor_t
pressors103212693pressor_s
presswork1854533presswork_
prestores114716083prestores
preterms1237223preterms
pretor8315753pretor__
preverbs15295303preverbs
prewar114712583prewar__
prewarm14479613prewar_m
prewarn124410153prewar_n
prewire124311143prewir_e
prewired14358473prewired
preworking2044233preworking
prewrap14104973prew_rap
prewraps15114053prewraps
preyers124412363preyer_s
priors83914483pr_ior_s
rebooks134010513_rebooks
rebores95319163_rebores
recocks154711463_recocks
recooks134711233_recooks
records105213923_records
recork126315493_recork_
redocks14409933_redocks
reforms1239823_reforms
relocks134411293_relocks
relooks114010723_relooks
remarks13329983_remarks
remoras9314073_remoras
reparks13249513_reparks
reperks13298093_reperks
reports94916213_reports
resoaks1148973_resoaks
resorbs95010523_resorbs
resorts74817193_resorts
retorts76016513_retorts
rewards114813993_rewards
rewarms12439603_rewarms
rewires104717113_rewires
rewoke1339521223_rewo_ke
reword106321413_rewor_d
rewore938030163_rewor_e
reworked16247773_reworked
reworn98122203_rewor_n
spadeworks20133523spadeworks
timeworks1844753timeworks
tinworks1596043tinworks
topworks1745343topworks
tremors93711233tremor_s
tubeworks1844233tubeworks
warworks1877063warworks
waxworks25114723waxworks
webworks2044663webworks
wirework1846573wirework_
wireworms1745033wireworms
works125621903___works
yardworks2044483yardworks

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621446.55022314.8
3Display Results1441440.0433348.8
 (SQL Overall)1786911447.01325480.0
 
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.