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

133 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
outstared1018842(None) 
outsoared10157591outsoared
outstare81410691outstare_
outstares91610181outstares
outstarted1155071outstarted
outstated10169811outstated
outstayed13185931outstayed
outdared102711512out_dared
outglared1145922outglared
outroared10158112outroared
outscored12207072outscored
outshamed1545312outshamed
outskated14176832outskated
outsmarted1344322outsmarted
outsnored10175982outsnored
outstand938042outsta_nd
outstart81611282outstar_t
outstarts9176322outstarts
outstate81411992outstate_
outstates91710752outstates
outsteered1143562outsteered
outsware11168842outsware_
upstared11156572_upstared
bustard10389723bu_star_d
buttered112712623but_tered
custard10389973cu_star_d
guttated10266873gut_tated
guttered10259163gut_tered
lustered92510603lu_stered
lustred8359053lu_st_red
mustard10359533mu_star_d
mustered112511503mu_stered
muttered112610793mut_tered
ousted73720583ou_st__ed
outbaked1538393out_baked
outbarked1636673out_barked
outbeamed1445363outbeamed
outblazed2195173outblazed
outboard1138323outboar_d
outbraved1566063outbraved
outbred10311263ou__tbred
outcharged1744213outcharged
outcharmed1843703outcharmed
outdare83113403out_dare_
outdares92712463out_dares
outdated1012513193out_dated
outearned1056683out_earned
outfaced14219463out_faced
outfired1238083out_fired
outgazed19197733out_gazed
outglare937383outglare_
outglares1047003outglares
outgnawed1443623outgnawed
outheard1288543outhear_d
outlawed1238033out_lawed
outleaped1246173outleaped
outlearned1143623outlearned
outmastered1452783outmastered
outpaced13269793out_paced
outplaced1446353outplaced
outplayed1545213outplayed
outpoured1246013outpoured
outprayed1545753outprayed
outraced112414203out_raced
outraged102313103out_raged
outrated92219313out_rated
outraved122511923out_raved
outsaid81210923outs_a_id
outsailed1037793outsailed
outsavored1452663outsavored
outscore10169203outscore_
outscores11178463outscores
outscorned1343583outscorned
outserved13136463outserved
outshame1346743outshame_
outshames1445923outshames
outshined1346543outshined
outsinned1045673outsinned
outsized18209743outs_ized
outskate12168013outskate_
outskates13177153outskates
outsmart10168923outsmar_t
outsmarts11155143outsmarts
outsmiled1245673outsmiled
outsmoked1644773outsmoked
outsnore8187683outsnore_
outsnores9176773outsnores
outsoar739493outsoar__
outsoars838853outsoar_s
outsourced1342873outsourced
outspanned1343453outspanned
outsparkled1891593outsparkled
outsped101110323outs__ped
outspeed11117933outs_peed
outspread1243503outs_pread
outstands1045543outstands
outstaring1137803outstaring
outstay1047683outsta__y
outstays1156623outsta_ys
outsteer837553outst_eer
outsteers936033outsteers
outstood945933outst_ood
outstride1085783outst_ride
outstrip1045083outst_rip
outstrode1065423outst_rode
outstudied1242363outstudied
outstunted1143183outstunted
outsulked14124753outsulked
outswore11168673outswore_
outtake11310793out_take_
outtakes12310033out_takes
outtalked1445513out_talked
outtasked1445373out_tasked
outthrew14123973out_threw
outtrade938343out_trade
outtraded1176983outtraded
outward11811403out_war_d
outwarred1345473outwarred
outwearied1444083outwearied
oystered1236923o_ystered
puttered112611143put_tered
stared75429873___stared
unseared91113943_unseared
unshared121510703_unshared
unstarred1036363_unstarred
unstated91615813_unstated
unstayed12168393_unstayed
upsoared11154353_upsoared
upstaged12135243_upstaged
upstare9158683_upstare_
upstares10178583_upstares
upstarted1244213_upstarted
uttered82712433_ut_tered

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 Limit1486411336.59322545.3
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.07925242.4
 
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.