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

119 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
unswore103905(None) 
unsworn1046841unsworn
inshore1038722inshore
onshore10310012onshore
outswore11168672outswore
swore84920812__swore
unaware1038032unaware
unshorn1036942unshorn
unspoke1336572unspoke
unsure62815412uns_ure
unworn93411332un_worn
unwove12238882un_wove
answer936893answer_
answered1235483answered
answerer1144263answerer
answers1037043answers
anymore1256243anymore
ashore9414613_ashore
cussword1443233cussword
encore8314773en_core
ensnare767123ensnare
ensure63416003ens_ure
forswore14106953forswore
insnare748243insnare
insole63515863ins_ole
inspire938253inspire
insure63416603ins_ure
inwove12167273in_wove
lungworm1443843lungworm
lungwort1245493lungwort
misword1338413misword
oospore939013oospore
outscore10169203outscore
outsnore8187683outsnore
outsware11168843outsware
outsworn11166663outsworn
outwore101912693outwore
rescore95616193rescore
restore75822973restore
rewore938030153_rewore
score75526733__score
shore85432653__shore
snore55424953__snore
sore47059533__s_ore
spore75428593__spore
store56333813__store
sunstone847793sunstone
sware85828213__sware
sword95214113__sword
sworn86115303__sworn
tussore7317283tussore
ugsome934783ugs_ome
unawake1445343unawake
unawares1137053unawares
unborn83310813un_born
unbroke13217743unbroke
unchoke16248193unchoke
unclose91111643unclose
uncork1239043un_cork
undoer73113043un_doer
undone7914253un_done
unfroze1945413unfroze
unglove1136103unglove
unhorse1038583un_horse
unicorn946513unicorn
uniform1247053uniform
unloose797863unloose
unmitre936993unmitre
unmoor836313unmoor_
unmoored1137333unmoored
unmoors945903unmoors
unpure82911533un_pure
unquote1645903unquote
unrobe82611673un_robe
unrove92511683un_rove
unsafe9310693uns_afe
unsavory1442573unsavory
unscrew1245463uns_crew
unseared91113943unseared
unshared121510703unshared
unsharp1235543unsharp
unshod1067603unsho_d
unshowy1644173unshowy
unsmart939603unsmart
unsmoked1536013unsmoked
unsnarl7107153unsnarl
unsober967643uns_ober
unsold71410513uns_old
unsorted9312513uns_orted
unsoured9310063unsoured
unsowed112511053unsowed
unsown9328433uns_own
unsphere1355853unsphere
unspoken1454243unspoken
unspool945163unspool
unstate71916213unstate
unstoned9311043unstoned
unstop837473unsto_p
unstops936993unstops
unswathe1444603unswathe
unswayed15155713unswayed
unswear1035003unswear
unswears1144023unswears
unswept1246013unswept
unswollen1242623unswollen
untorn63012343un_torn
untwine1038623untwine
unwary1239823un_wary
unwise9510803un_wise
unwon84512343un_wo_n
unwooed11229773un_wooed
unworked16238503un_worked
unwoven13176673un_woven
unyoke1367293un_yoke
upbore10247883u_pbore
upslope1144173upslope
upstare9158683upstare
uptore8279453u_ptore
wore77144673___wore

Search took 7 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.1401276364.3
2DLD Change Limit1340271196.58020368.8
3Display Results1191190.0462587.0
 (SQL Overall)1786911196.76626410.1
 
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.