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

93 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
outdanced1322657(None) 
outdance11238731outdance_
outdances12198501outdances
outdared102711512outda_red
outdated1012513192outda_ted
outfaced14219462outfa_ced
outfenced1555092outfenced
outmanned1245482outmanned
outpaced13269792outpa_ced
outraced112414202outra_ced
outrance102212772outrance_
outrances112912112outrances
outranged11239042outranged
outranked14247862outranked
danced105315253___danced
entranced1247393entranced
guidance1244983guidance_
guidances1344773guidances
nuanced1036203nu__anced
outacted1139383out_acted
outadded1135933out_added
outasked1337123out_asked
outbaked1538393outba_ked
outbalanced1652073outbalanced
outbarked1636673outbarked
outbawled1554953outbawled
outdancing1445223outdancing
outdare83113403outda_re_
outdares92712463outda_res
outdate83016423outda_te_
outdates93114743outda_tes
outdazzled2041823outdazzled
outdistanced1651263outdistanced
outdodged1343903outdodged
outdone8311643outdon_e_
outdragged1443223outdragged
outdueled1144723outdueled
outearned1056683outearned
outfabled1595093outfabled
outface123011973outfa_ce_
outfaces132311393outfa_ces
outfasted13147173outfasted
outfawned1644133outfawned
outfence1356973outfence_
outfences1456463outfences
outflanked1842883outflanked
outgained1137223outgained
outgassed1145623outgassed
outgazed19197733outga_zed
outgnawed1443623outgnawed
outgunned1143963outgunned
outhandled1573633outhandled
outhunted1345723outhunted
outjinxed2443133outjinxed
outland81212343outlan__d
outlander1045733outlander
outlasted10128353outlasted
outlawed1238033outla_wed
outlined92512953outlin_ed
outmarched1843583outmarched
outmatched1843483outmatched
outpace112613023outpa_ce_
outpaces122411943outpa_ces
outpainted1344323outpainted
outpassed1245803outpassed
outplaced1446353outplaced
outplanned1363623outplanned
outpriced1446423outpriced
outpunched1842773outpunched
outrace92418553outra_ce_
outraces102217863outra_ces
outraged102313103outra_ged
outraised1039243outraised
outrange92410223outrange_
outranges102510013outranges
outrated92219313outra_ted
outraved122511923outra_ved
outsailed1037793outsailed
outsinned1045673outsinned
outspanned1343453outspanned
outtalked1445513outtalked
outtasked1445373outtasked
outthanked1842913outthanked
outvalued1344203outvalued
outvaunted1452743outvaunted
outvoiced1544403outvoiced
outwaited13137293outwaited
outwalked1745293outwalked
outwarred1345473outwarred
outwasted13137683outwasted
outwatched1943423outwatched
outwinded1444663outwinded
tranced104414173__tranced

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641936.46622988.1
3Display Results93930.0462021.7
 (SQL Overall)178691936.66826798.3
 
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.