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

124 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
outgained113722(None) 
obtained1136532obt_ained
outearned1056682outearned
outfawned1644132outfawned
outgain81010742outgain__
outgains9810162outgain_s
outgassed1145622outgassed
outgazed19197732outga_zed
outgrinned1242782outgrinned
outguided1264572outguided
outgunned1143962outgunned
outlined92512952out_lined
outmanned1245482outmanned
outpainted1344322outpainted
outraised1039242outraised
outsailed1037792outsailed
outshined1346542outshined
outwaited13137292outwaited
attained997353_attained
bargained1344953bargained
contained12310893cont_ained
curtained1265503curtained
detained103111643det_ained
detrained1158913detrained
entrained1089413entrained
fountained1443333fountained
gained84617463___gained
mutined103311353mut__ined
obtainer1045793obt_ainer
ordained1035183o_rdained
outacted1139383out_acted
outadded1135933out_added
outasked1337123out_asked
outbaked1538393outba_ked
outbargained167913outbargained
outbarked1636673outbarked
outbawled1554953outbawled
outbribed1445003outbribed
outburned1245213outburned
outcaviled1643243outcaviled
outchided1645173outchided
outcried1139543outcri_ed
outdanced13226573outdanced
outdared102711513outda_red
outdated1012513193outda_ted
outfabled1595093outfabled
outfaced14219463outfa_ced
outfasted13147173outfasted
outfind1139563out_fin_d
outfired1238083out_fired
outgaining1237093outgaining
outgambled1692333outgambled
outgasses1036663outgasses
outgave11259563outga_ve_
outgaze17239223outga_ze_
outgazes18248713outga_zes
outgazing2037143outgazin_g
outgive11199253outg_ive_
outgiven12255433outg_iven
outgives12218623outg_ives
outglared1145923outglared
outglowed1444313outglowed
outgnawed1443623outgnawed
outgoing1039273outgoin_g
outgoings1143953outgoings
outgone8311463outg_one_
outgrin8810553outgrin__
outgrins979823outgrin_s
outguide1045953outguide_
outguides1145413outguides
outgushed1444483outgushed
outjinxed2443133out_jinxed
outlaid81110653outlai__d
outlain71212613outlain__
outland81212343outla_n_d
outlasted10128353outlasted
outlawed1238033outla_wed
outlearned1143623outlearned
outline72321333out_line_
outliner82412113out_liner
outlines82418093out_lines
outlived12269583out_lived
outpaced13269793outpa_ced
outpaint10311773outpain_t
outpaints1145283outpaints
outpassed1245803outpassed
outplanned1363623outplanned
outpointed1344313outpointed
outpriced1446423outpriced
outraced112414203outra_ced
outraged102313103outra_ged
outraise8311933outraise_
outraises9311023outraises
outranged11239043outranged
outranked14247863outranked
outrated92219313outra_ted
outraved122511923outra_ved
outsaid81210923outsai__d
outshine11310723outshine_
outshines1238613outshines
outsinned1045673outsinned
outsized18209743out_sized
outsmiled1245673outsmiled
outspanned1343453outspanned
outtalked1445513outtalked
outtasked1445373outtasked
outvalued1344203outvalued
outvaunted1452743outvaunted
outvied11239693out_vi_ed
outvoiced1544403outvoiced
outwalked1745293outwalked
outwarred1345473outwarred
outwasted13137683outwasted
outwiled1237603out_wiled
outwind1139153out_win_d
outwinded1444663out_winded
regained102111243_regained
retained93016093ret_ained
retrained10411313retrained
stained84215343_st_ained
strained9412253_strained
sustained1045383sustained
trained84117203__trained
untrained10510993untrained

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.483369960.7
2DLD Change Limit1486411246.73322076.5
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.26224606.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.