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

120 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
outadded113593(None) 
outacted1139382outacted
outadd837802outa_d_d
outadds936202outadd_s
outasked1337122outasked
outdared102711512outdared
outdated1012513192outdated
outmoded12207702outmoded
quadded1934862qu_added
unadded10238522_unadded
added84918433___added
bradded12388713_bradded
budded113912333bu__dded
cladded12356923_cladded
gadded103913173__gadded
gladded11357453_gladded
guarded1036153gu_arded
madded113513553__madded
misadded1335753misadded
mudded114511383mu__dded
mutated102712253muta_ted
nutated83113423nuta_ted
obtained1136533obtained
obtruded1243363obtruded
obtunded1243523obtunded
outadding1235793outadding
outage72017533outa_ge_
outages82317323outa_ges
outargued1144403outargued
outate62923403outa_te_
outbaked1538393outbaked
outbarked1636673outbarked
outbawled1554953outbawled
outbidden1342973outbidden
outbidder1343153outbidder
outboxed1836873outboxed
outbred10311263out_bred
outbreed1138503outbreed
outchided1645173outchided
outcried1139543outcried
outdanced13226573outdanced
outdare83113403outdare_
outdares92712463outdares
outdate83016423outdate_
outdates93114743outdates
outdid81210923out__did
outdodged1343903outdodged
outdoer849273out_doer
outdoes8313123out_does
outdrew1137143out_drew
outduel837303out_duel
outearned1056683outearned
outed65429063out___ed
outfabled1595093outfabled
outfaced14219463outfaced
outfasted13147173outfasted
outfawned1644133outfawned
outfired1238083outfired
outfoxed1936013outfoxed
outgained1137223outgained
outgassed1145623outgassed
outgazed19197733outgazed
outguided1264573outguided
outhandled1573633outhandled
outlander1045733outlander
outlasted10128353outlasted
outlawed1238033outlawed
outled74020343out__led
outlined92512953outlined
outlived12269583outlived
outloved12248583outloved
outmanned1245483outmanned
outmode10199663outmode_
outmodes11208963outmodes
outmoved14247283outmoved
outpaced13269793outpaced
outpassed1245803outpassed
outplodded1542413outplodded
outraced112414203outraced
outraged102313103outraged
outraised1039243outraised
outranged11239043outranged
outranked14247863outranked
outrated92219313outrated
outraved122511923outraved
outridden1143803outridden
outride82615683outride_
outrider92410563outrider
outrides92414993outrides
outrode82313423outrode_
outrowed1239433outrowed
outsailed1037793outsailed
outside82414193outside_
outsider9269643outsider
outsides92513233outsides
outsized18209743outsized
outsped101110323out_sped
outspeed11117933outspeed
outtalked1445513outtalked
outtasked1445373outtasked
outtraded1176983outtraded
outvalued1344203outvalued
outvied11239693out_vied
outvoted1237273outvoted
outwaited13137293outwaited
outwalked1745293outwalked
outwarred1345473outwarred
outwasted13137683outwasted
outwiled1237603outwiled
outwinded1444663outwinded
padded114113503__padded
radded94716493__radded
readded103310733_readded
retarded102410753retarded
squadded2033843squadded
studded10236873_studded
tedded93810893__tedded
unaided92414603_unaided
unpadded1345183unpadded
wadded124014173__wadded

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.1731032896.0
2DLD Change Limit1461621207.42319690.4
3Display Results1201200.0602000.0
 (SQL Overall)1786911207.65623340.0
 
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.