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

121 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
outstares9161018(None) 
outstare81410691outstare_
outstared10188421outstared
outstarts9176321outstarts
outstates91710751outstates
outdares92712462out_dares
outglares1047002outglares
outscores11178462outscores
outshames1445922outshames
outskates13177152outskates
outsmarts11155142outsmarts
outsnores9176772outsnores
outsoared10157592outsoared
outsoars838852outsoar_s
outstands1045542outstands
outstart81611282outstar_t
outstarted1155072outstarted
outstate81411992outstate_
outstated10169812outstated
outstayed13185932outstayed
outstays1156622outsta_ys
outsteers936032outsteers
outsware11168842outsware_
outtakes12310032out_takes
upstares10178582_upstares
bustards11308513bu_stards
custards11338393cu_stards
cuttages11297223cut_tages
lustres73013233lu_st_res
mustards11297883mu_stards
offstages1652033offstages
ottars64112223o_t_tar_s
ousters74122793ou_ster_s
outages82317323ou__tages
outbakes1439993out_bakes
outbarks1437833out_barks
outblazes2085443outblazes
outboards1246213outboards
outbraves1436713outbraves
outcharges1644833outcharges
outcharms1643923outcharms
outdare83113403out_dare_
outdared102711513out_dared
outdates93114743out_dates
outearns838403out_earns
outfaces132311393out_faces
outfires1139863out_fires
outgazes18248713out_gazes
outglare937383outglare_
outglared1145923outglared
outhears11810393outhear_s
outlearns944633outlearns
outpaces122411943out_paces
outplaces1347743outplaces
outraces102217863out_races
outrages92215933out_rages
outrates82421373out_rates
outraves112313833out_raves
outroared10158113outroared
outroars838923outroar_s
outsails8139863outs_ails
outsays102710403outs_a_ys
outscore10169203outscore_
outscored12207073outscored
outscorns11144883outscorns
outsees72616433outs__ees
outserts8309803outs_erts
outserves12147373outserves
outshame1346743outshame_
outshamed1545313outshamed
outshines1238613outshines
outsiders10236663outsiders
outsides92513233outs_ides
outsizes172311083outs_izes
outskate12168013outskate_
outskated14176833outskated
outskirts1343513outskirts
outsmart10168923outsmar_t
outsmarted1344323outsmarted
outsmiles1146443outsmiles
outsmokes1545313outsmokes
outsnore8187683outsnore_
outsnored10175983outsnored
outsoar739493outsoar__
outsoles8813113outs_oles
outsources1242913outsources
outspans1038223outspa_ns
outsparkles1791483outsparkles
outstand938043outsta_nd
outstaring1137803outstaring
outstay1047683outsta__y
outsteer837553outst_eer
outsteered1143563outsteered
outstrides1154743outstrides
outstrip1045083outst_rip
outstrips1145203outstrips
outstrives1374253outstrives
outstrokes1464583outstrokes
outstudies1142663outstudies
outstunts943613outstunts
outswears1244303outswear_s
outswore11168673outswore_
outtake11310793out_take_
outtalks1236503out_talks
outtasks1235633out_tasks
outthrew14123973out_threw
outtrades1077693outtrades
outturns835913out_turns
outwards1299123out_wards
outwars10912793out_war_s
outwearies1345353outwearies
outwears1197263outwear_s
stares66038753___stares
substages12127353substages
substates111410333substates
unstates81314993_unstates
upstages11147373_upstages
upstare9158683_upstare_
upstared11156573_upstared
upstarts10165273_upstarts
upstates10189643_upstates

Search took 9 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.436409841.7
2DLD Change Limit1486411217.67319372.0
3Display Results1211210.0462630.4
 (SQL Overall)1786911218.15521911.8
 
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.