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

115 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
warworn135735(None) 
warwork1757581warwork
wayworn1675291wayworn
careworn1347882careworn
earworm1238742earworm
forworn13107792forworn
warlord1136292warlord
warworks1877062warworks
waterworn1546182waterworn
waxwork24104882waxwork
waxworm2264572waxworm
acorn75616623_a_corn
adorn64917093_a_dorn
arbor74818113_arbor_
arbors84717883_arbors
ardor64617863_ardor_
ardors74416873_ardors
argon65520593_argo_n
armor75118053_armor_
armors85017813_armors
armory114211473_armory
arson55118833_arso_n
artwork1447093_artwork
aswoon947013_aswoon
attorn6310793_attorn
awlwort1356353awlwort
bagworm1566353bagworm
baron78131243bar_o_n
barware12610703barware
baryon111211613baryo_n
carbarn1139453carbarn
carbon104919043carbo_n
carbora11310703carbora
cardon94120853cardo_n
cardoon104813813cardoon
carport11316033carport
carton84522663carto_n
cartoon94114463cartoon
daywork1845653daywork
earworms1346783earworms
fanwort13310733fanwort
farmwork2044193farmwork
foreworn14108863foreworn
forlorn1096423forlorn
forsworn14125763forsworn
garcon92912483garco_n
garron73113493garro_n
hagborn1344953hagborn
hairwork1845073hairwork
hairworm1644543hairworm
harbor11410723harbor_
harbors12412413harbors
harpoon1238313harpoon
jargon1448823jargo_n
jargoon1545193jargoon
lardon74415063lardo_n
lardoon83410373lardoon
madwort13611363madwort
maroon83118203mar_oon
marron83717543marro_n
outworn101610753outworn
overworn14118833overworn
pardon94618733pardo_n
parlor8312673parlor_
parlors9312913parlors
parson83817903parso_n
parton84720993parto_n
preworn124711223preworn
ragwort11510743ragwort
reworn98122203_reworn
sartor6313883sartor_
sartors7314973sartors
saxhorn1744223saxhorn
starwort1198683starwort
swearword1642353swearword
sworn86115313__sworn
tarpon82812803tarpo_n
unsworn1046843unsworn
unworn93411333_unworn
waggon1136393waggo_n
wagon94312953wa_go_n
waitron1036333waitron
wanion93213063wanio_n
wanton94413813wanto_n
warden104515513war_den
warder104020273warder_
warders113416813warders
warfare1336733warfare
warfarin1444983warfarin
warhorse1445343warhorse
warier93722893warier_
warison1037083warison
warlock1636293warlock
warlords1245303warlords
warmer113816733warmer_
warmers124514293warmers
warn75239323wa___rn
warner93717223warner_
warners103315563warners
warper114015583warper_
warpers123413583warpers
warren95012853war_ren
warrior1045363warrior_
warriors1135363warriors
waterwork1946653waterwork
waxworks25114723waxworks
waxworms2393673waxworms
wayward1736053wayward
webwork1944843webwork
webworm1744313webworm
werwolf1644573werwolf
wirework1846573wirework
wireworm1645893wireworm
worn75631753___worn
yardwork1944513yardwork

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.390458182.1
2DLD Change Limit1340271157.19018640.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.62623431.8
 
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.