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 “outearned” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
outearned105668(None) 
outlearned1143621outlearned
outbarked1636672outbarked
outburned1245212outburned
outdared102711512outdar_ed
outearn7310682outearn__
outearns838402outearn_s
outfawned1644132outfawned
outgained1137222outgained
outmanned1245482outmanned
outwarred1345472outwarred
outwearied1444082outwearied
unearned9310062_unearned
earned74818333___earned
interned93016653inte_rned
learned8329303__learned
obtained1136533obt_ained
outacted1139383out_acted
outadded1135933out_added
outargued1144403out_argued
outasked1337123out_asked
outbaked1538393outba_ked
outbawled1554953outbawled
outbeamed1445363outbea_med
outbraved1566063outbraved
outbred10311263out_br_ed
outbreed1138503out_breed
outcharged1744213outcharged
outcharmed1843703outcharmed
outcried1139543out_cried
outcursed1245133outcursed
outdanced13226573outdanced
outdare83113403outdar_e_
outdares92712463outdar_es
outdated1012513193outda_ted
outearning1146743outearning
outeaten8310423outea_ten
outechoed1544633outechoed
outfabled1595093outfabled
outfaced14219463outfa_ced
outfasted13147173outfasted
outfeasted1444313outfeasted
outfired1238083outfir_ed
outgassed1145623outgassed
outgazed19197733outga_zed
outglared1145923outglar_ed
outgunned1143963outgunned
outheard1288543outhear__d
outland81212343outla_n_d
outlasted10128353outlasted
outlawed1238033outla_wed
outleaped1246173outlea_ped
outlearn836433outlearn__
outlearns944633outlearn_s
outlearnt945963outlearn_t
outlined92512953out_lined
outmarched1843583outmarched
outpaced13269793outpa_ced
outpainted1344323outpainted
outpassed1245803outpassed
outplanned1363623outplanned
outprayed1545753outprayed
outraced112414203outra_ced
outraged102313103outra_ged
outraised1039243outraised
outranged11239043outranged
outranked14247863outranked
outrated92219313outra_ted
outraved122511923outra_ved
outreached1645003outreached
outreasoned1252113outreasoned
outroared10158113outroar_ed
outsailed1037793outsailed
outscorned1343583outscorned
outserved13136463outserved
outshined1346543outshined
outsinned1045673outsinned
outsmarted1344323outsmarted
outsoared10157593outsoar_ed
outspanned1343453outspanned
outstared10188423outstar_ed
outstarted1155073outstarted
outtalked1445513outtalked
outtasked1445373outtasked
outtraded1176983outtraded
outvalued1344203outvalued
outvaunted1452743outvaunted
outwaited13137293outwaited
outwalked1745293outwalked
outward11811403outwar__d
outwasted13137683outwasted
outwearies1345353outwearies
outworked1745573outworked
reearned948883_reearned
relearned1035633relearned
teared75722153__tear_ed
unlearned1035653unlearned
unwarned1238453_unwarned
yearned11327373__yearned

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 Filter1786911486410.423422437.4
2DLD Change Limit148641997.37620152.0
3Display Results99990.0462152.2
 (SQL Overall)178691997.84522777.7
 
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.