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

148 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
outboxes173782(None) 
outboxed1836871outboxed
outfoxes1836741outfoxes
hatboxes2055002hatboxes
hotboxes2045062hotboxes
outbakes1439992outbakes
outbox1537462outbox__
outcomes1239762outcomes
outdoes8313122outdo_es
outfoxed1936012outfoxed
outgoes8312642outgo_es
outloves11249672outloves
outmodes11208962outmodes
outmoves13228172outmoves
outsoles8813112outsoles
outvotes1137902outvotes
postboxes2045242postboxes
unboxes16208302_unboxes
boomboxes2243443boomboxes
boxes145625073___boxes
buboes104513993bu_bo_es
coalboxes2043683coalboxes
detoxes1538803det_oxes
iceboxes1943533iceboxes
jukeboxes2951503jukeboxes
lockboxes2453453lockboxes
lummoxes1942553lummoxes
oboes75717713o__bo_es
oboles83815833o__boles
orthoses11311143orthoses
osteoses839033osteoses
ostioles839273ostioles
ostoses71213553ost_oses
outages82317323out_ages
outbacks1638983outbacks
outbake13310773outbake_
outbaked1538393outbaked
outbarks1437833outbarks
outbawls1336053outbawls
outbeams1236063outbeams
outbeg938733outb__eg
outbegs1036483outb_egs
outbids1098913outb_ids
outblazes2085443outblazes
outbless1037963outbless
outblooms1342973outblooms
outboard1138323outboard
outboards1246213outboards
outboast1048543outboast
outboasts1144763outboasts
outbound1146583outbound
outboxing19155763outboxing
outbrags1136693outbrags
outbraves1436713outbraves
outbred10311263outb_red
outbreed1138503outbreed
outbreeds1244223outbreeds
outbribes1345463outbribes
outbulges12134743outbulges
outbulks1444763outbulks
outburns1036063outburns
outbuys1246053outb_uys
outbye1147913outb_ye_
outcome11310573outcome_
outcooks1436723outcooks
outcries10313573outcries
outdares92712463outdares
outdates93114743outdates
outdodges1243993outdodges
outdoer849273outdo_er
outdoers937513outdoers
outdone8311643outdone_
outdoors936433outdoors
outfaces132311393outfaces
outfires1139863outfires
outflies11310153outflies
outfools1136533outfools
outfoots1136883outfoots
outfox1636143outfox__
outgazes18248713outgazes
outgives12218623outgives
outgone8311463outgone_
outhomer1348133outhomer
outhomers1446063outhomers
outhouse11310883outhouse
outhouses12310663outhouses
outhowls1445723outhowls
outjinxes2343113outjinxes
outlies72421993out_lies
outlines82418093outlines
outlives112511763outlives
outlooks1236793outlooks
outlove102410243outlove_
outloved12248583outloved
outmode10199663outmode_
outmoded12207703outmoded
outmove12238713outmove_
outmoved14247283outmoved
outpaces122411943outpaces
outpolls1046213outpolls
outports1048273outports
outposts1037253outposts
outpours1036683outpours
outpower1336673outpower
outpowers1445193outpowers
outquotes1874513outquotes
outraces102217863outraces
outrages92215933outrages
outrates82421373outrates
outraves112313833outraves
outrides92414993outrides
outroars838923outroars
outrocks1437903outrocks
outrode82313423outrode_
outrolls847823outrolls
outroots839873outroots
outrowed1239443outrowed
outrows10311403outro_ws
outscores11178463outscores
outsees72616433out_sees
outsides92513233outsides
outsizes172311083outsizes
outsmokes1545313outsmokes
outsnores9176773outsnores
outsoars838853outsoars
outsole71013433outsole_
outtakes12310033outtakes
outtower1136193outtower
outtowers1244763outtowers
outvies102214243out_vies
outvoices1444423outvoices
outvote1038803outvote_
outvoted1237273outvoted
outwiles1139233outwiles
outwore101912693outwore_
outworks15148973outworks
pegboxes2043143pegboxes
saltboxes1853083saltboxes
skyboxes2442673skyboxes
soapboxes2043273soapboxes
soundboxes2052223soundboxes
subtones10311383subtones
teaboxes1745063teaboxes
toolboxes1843213toolboxes
umbones1138013_umbones
unboxed17249573_unboxed
woodboxes2243953woodboxes
workboxes2543883workboxes

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621487.25020160.3
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.73623098.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.