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

108 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
outwastes1212769(None) 
outcastes11118901outcastes
outwashes15116181outwashes
outwaste11147941outwaste_
outwasted13137681outwasted
outcaste10119612outcaste_
outcasts10108682outcast_s
outdates93114742outda_tes
outfasted13147172outfasted
outfasts11117232outfast_s
outgasses1036662outgasses
outlasted10128352outlasted
outlasts8108712outlast_s
outmaster1147302outmaster
outmasters1245732outmasters
outpasses1146612outpasses
outrates82421372outra_tes
outwaited13137292outwaited
outwaits1137492outwait_s
outwishes15126562outwishes
outwrites1238232outwrites
cutlases1038033cutlas_es
cutlasses1145103cutlasses
cutwater1344833cutwa_ter
cutwaters1443613cutwa_ters
mouthwashes2262063mouthwashes
mutases92012043mut_as_es
mutates92215793mut_a_tes
nutates73214973nut_a_tes
nutcases1085793nutcas_es
outacted1139383out_acted
outacts9310213out_act_s
outages82317323out_a_ges
outasked1337123out_asked
outasks1138173out_as_ks
outate62923403out_a_te_
outbakes1439993outba_kes
outboasted1344343outboasted
outboasts1144763outboast_s
outcast91013743outcast__
outclasses12145133outclasses
outdances12198503outdances
outdares92712463outda_res
outdate83016423outda_te_
outdated1012513193outda_ted
outeaten8310423outea_ten
outeats72215703outea_t_s
outfables1485563outfables
outfaces132311393outfa_ces
outfast101412123outfast__
outfeasted1444313outfeasted
outfeasts12114333outfeast_s
outfishes15118023outfishes
outgassed1145623outgassed
outgazes18248713outga_zes
outgushes1344853outgushes
outhustles1352563outhustles
outkisses1344303outkisses
outlast71015443outlast__
outpaces122411943outpa_ces
outpass939713outpas__s
outpassed1245803outpassed
outposts1037253outpost_s
outpushes1445253outpushes
outquotes1874513outquotes
outraces102217863outra_ces
outrages92215933outra_ges
outraises9311023outraises
outrances112912113outrances
outranges102510013outranges
outrate72323183outra_te_
outrated92219313outra_ted
outraves112313833outra_ves
outrushes1246653outrushes
outsees72616433out__sees
outsets73514923out__sets
outskates13177153outskates
outstates91710753outstates
outtakes12310033outta_kes
outtasked1445373outtasked
outtasks1235633outtas_ks
outvalues1244303outvalues
outvotes1137903out_votes
outwait10411763outwait__
outwalked1745293outwalked
outwalks1535993outwa_lks
outwards1299123outwa_rds
outwarred1345473outwarred
outwars10912793outwa__rs
outwash13187613outwas__h
outwasting1446433outwasting
outwatch1643903outwa_tch
outwatches1843473outwatches
outwearies1345353outwearies
outwiles1139233outw_iles
outwished1655683outwished
outwits103110863outw_it_s
outwitted1345133outwitted
outwrestles1481493outwrestles
outwrite1139453outwrite_
outwrote1137723outwrote_
posthastes1546273posthastes
radwastes1364123radwastes
retastes82212903ret_astes
subcastes1387493subcastes
tastes64126423__t_astes
unwasted12259783_unwasted
wastes96224883___wastes

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.440406115.9
2DLD Change Limit1486411086.75022020.9
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.23624694.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.