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

102 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
warworks187706(None) 
warwork1757571warwork_
waxworks25114721waxworks
artworks1546522_artworks
dayworks1945562dayworks
earworms1346762earworms
farmworks2143842farmworks
gasworks1645942gasworks
hairworks1944842hairworks
warlocks1735362warlocks
warlords1245302warlords
warworn1357342warwor_n
waterworks2046172waterworks
waxwork24104882waxwork_
waxworms2393662waxworms
webworks2044662webworks
wireworks1946012wireworks
yardworks2044482yardworks
arbores94016033_arbores
arbors84717873_arbor_s
ardors74416863_ardor_s
armors85017813_armor_s
artwork1447083_artwork_
awlworts1443593awlworts
bagworms1645203bagworms
barwares13610093barwares
beadworks1945723beadworks
byworks1944543_byworks
capeworks2045633capeworks
carboras12311573carboras
carports1238943carports
caseworks1846413caseworks
cutworks17166003cutworks
daywork1845653daywork_
earlocks1435693earlocks
earmarks1444793earmarks
earthworks2043563earthworks
earworm1238733earwor_m
fanworts1446103fanworts
farmwork2044183farmwork_
fireworks1946543fireworks
flatworks1944703flatworks
formworks2144133formworks
hackworks2045203hackworks
hairwork1845073hairwork_
hairworms1743973hairworms
handworks2046703handworks
harbors12412413harbor_s
hayforks2143423hayforks
headworks2045953headworks
laceworks1846583laceworks
lathworks1945193lathworks
leadworks1745123leadworks
legworks1645373legworks
madworts1456173madworts
networks1546143networks
oarlocks1445103oarlocks
outworks15148973outworks
overworks19127383overworks
paperworks2144073paperworks
parlors9312913parlor_s
pinworks17106353pinworks
preworks17599003preworks
rackworks1745543rackworks
ragworts12125803ragworts
reworks145113593_reworks
roadworks1745293roadworks
saltworks1645163saltworks
sartors7314953sartor_s
seatworks1646303seatworks
starworts12105263starworts
swearwords1752293swearwords
taroks106115283tar_o_ks
taskworks1543903taskworks
teamworks1844593teamworks
tinworks1596033tinworks
topworks1745343topworks
tryworks1844603tryworks
warders113416813warder_s
warfares1436683warfares
warhorse1445343warhorse
warhorses1545573warhorses
warks127932403wa___rks
warlock1636293warlock_
warlord1136293warlor_d
warmers124514293warmer_s
warners103315563warner_s
warpers123413583warper_s
warriors1135363warrior_s
waterwork1946643waterwork_
waxworker2642133waxworker
waxworkers2752003waxworkers
waxworm2264563waxwor_m
wayworn1675293waywor_n
webwork1944833webwork_
webworms1843743webworms
wirework1846563wirework_
wireworms1745023wireworms
woodworks2045583woodworks
woolworks1954393woolworks
works125621903___works
yardwork1944503yardwork_

Search took 9 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.1561145455.1
2DLD Change Limit1461621028.21617789.9
3Display Results1021020.0502040.0
 (SQL Overall)1786911028.42221217.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.