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

117 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
outstaring113780(None) 
outsoaring1137701outsoaring
outstarting1245011outstarting
outstating1139361outstating
outstaying1446091outstaying
outdaring1179722out_daring
outglaring1246272outglaring
outhearing1438442outhearing
outroaring1138832outroaring
outsaying1338702outs_aying
outscoring1346232outscoring
outshaming1645662outshaming
outskating1536852outskating
outsmarting1444382outsmarting
outsnoring1145612outsnoring
outspring1238902outs_pring
outstanding1344552outstanding
outsteering1244552outsteering
outswearing1544072outswearing
outwearing1437182outwearing
upstaring1235962_upstaring
buttering122312523but_tering
guttering112410443gut_tering
lustering102711203lu_stering
lustring9269723lu_st_ring
lutestring1143473lutest_ring
mustering122212333mu_stering
muttering122611323mut_tering
ousting84021353ou_st__ing
outbaking1638233out_baking
outbarking1746213out_barking
outbeaming1546043outbeaming
outblazing2245593outblazing
outbraving1646163outbraving
outcharging1843783outcharging
outcharming1943583outcharming
outdating11810863out_dating
outdrawing1546023outdrawing
outearning1146743out_earning
outeating10814493out_eating
outfacing1578113out_facing
outfiring1338163out_firing
outgazing2037143out_gazing
outgnawing1544433outgnawing
outlawing1337933out_lawing
outlaying1338543out_laying
outleading1237133outleading
outleaping1346203outleaping
outlearning1243543outlearning
outmastering1552953outmastering
outpacing1478363out_pacing
outplacing1546193outplacing
outplaying1645963outplaying
outpouring1346043outpouring
outpraying1646523outpraying
outracing12912163out_racing
outraging111010883out_raging
outrating10916403out_rating
outraving13910133out_raving
outreading1239283outreading
outring84021023ou__t_ring
outsailing1137563outsailing
outsang83411273outs_a__ng
outsavoring1542963outsavoring
outscorning1443473outscorning
outseeing1038333outs_eeing
outselling1188023outselling
outserving1446743outserving
outshining1446533outshining
outsing83320463outs___ing
outsinging1246273outsinging
outsinning1146173outsinning
outsitting1147133outsitting
outsmiling1345743outsmiling
outsmoking1745123outsmoking
outsourcing1452973outsourcing
outspanning1443563outspanning
outsparkling1951653outsparkling
outspeaking1844173outspeaking
outsprang1243903outs_prang
outsprings1343953outs_prings
outsprint1148203outs_print
outsprung1243153outs_prung
outstand938043outsta__nd
outstare81410693outstar__e
outstared10188423outstar_ed
outstares91610183outstar_es
outstart81611283outstar__t
outstarted1155073outstarted
outstarts9176323outstar_ts
outstation1046163outstation
outstations1145343outstations
outstride1085773outst_ride
outstriding1344203outstriding
outstrip1045083outst_ri_p
outstrips1145203outst_rips
outstrive1265083outst_rive
outstriving1543793outstriving
outstudying1642153outstudying
outstunting1243783outstunting
outsulking1544723outsulking
outswing1259283outs__wing
outtalking1545483out_talking
outtasking1545723out_tasking
outtrading1247153outtrading
outwarring1445363outwarring
outwearying1843203outwearying
oystering1337553o_ystering
puttering122611643put_tering
staring84527053___staring
unsparing1237713_unsparing
unstating10711213_unstating
unstring9312093_unst_ring
upsoaring1244513_upsoaring
upstaging1344113_upstaging
upstarting1343883_upstarting
uttering91613083_ut_tering

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 Filter1786911406030.1561145455.1
2DLD Change Limit1406031178.07617410.0
3Display Results1171170.0631857.1
 (SQL Overall)1786911178.29521542.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.