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

124 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
locksets143569(None) 
lockets134612201lock_ets
lockset13311161lockset_
backsets1638852backsets
dockets144412242dock_ets
lockers133516922lock_ers
locket123922472lock_et_
locknuts1443682locknuts
lockouts1445492lockouts
lockstep1643812lockstep
locksteps1743342locksteps
locusts9277932locus_ts
pockets154612252pock_ets
rockets134615362rock_ets
sockets134012982sock_ets
backseats1746673backseats
backset15314193backset_
beckets15399823beck_ets
blockers16398793block_ers
blockiest1736363blockiest
bonesets1036843bonesets
booklets14247123booklets
boskets13409473bosk_ets
brockets16328123brock_ets
buckets153811693buck_ets
clockers16369813clock_ers
closets94611603clo__sets
cockers153618333cock_ers
cockiest163013293cockiest
cockles153414643cockle_s
cockneys1934493cockneys
cockpits1845743cockpits
cockshuts2042773cockshuts
corsets94819803co_rsets
cosets85824403__cosets
cossets95014283co_ssets
crockets16339543crock_ets
dockers143715003dock_ers
docket134721173dock_et_
flockiest1835643flockiest
flockless1843163flockless
focusers13134373focusers
focuses12159653focuse_s
hockers163915913hock_ers
hockeys19509273hock_eys
hocuses121710433hocuse_s
hooklets15217203hooklets
jackets205011373jack_ets
jockeys23365953jock_eys
lackers134120543lack_ers
lackeys16458263lack_eys
lickers134118253lick_ers
lickspits1742503lickspits
locales93715093locale_s
locaters102710073locaters
locates93218813locate_s
lockages1536723lockages
locked134921663lock_e_d
locker124019423lock_e_r
lockjaws2441873lockjaws
locknut1345253locknut_
lockout1359333lockout_
lockrams1643923lockrams
locks115126923lock___s
locksmith2053003locksmith
locksmiths2152013locksmiths
lockups1534243lock_ups
locoes85516583loc_oe_s
locules92812603locule_s
locust85312343locus_t_
locusta9326533locus_ta
loesses7310033loesse_s
loggets9378913lo_ggets
lookers114014073look_ers
lookists1245713lookists
lookouts1244563lookouts
loosens716310963lo_osens
looses67328253lo_ose_s
loosest75811563lo_osest
lorikeets1341893lorikeets
lorises73918593lorise_s
losels64714593lo__sels
losers65123583lo__sers
loses56742013lo__se_s
losses65925233lo_sse_s
lotoses73713653lotose_s
lotuses74011253lotuse_s
louses66230283lo_use_s
loveseats1253223loveseats
luckies133313683luckie_s
luckiest143011443luckiest
luckless14265893luckless
mockers153812943mock_ers
moonsets10216413moonsets
ockers123813903_ock_ers
octets839403_oc_tets
offsets1333503_offsets
onsets64013543_o_nsets
oocysts1243923oocys_ts
outsets73514923_outsets
packets155114773pack_ets
pickets154314183pick_ets
plackets1646583plack_ets
pocket144622623pock_et_
pockiest163412053pockiest
pocosens1255263pocosens
possets94212773po_ssets
quicksets2442383quicksets
rackets134916873rack_ets
rickets134915093rick_ets
rochets124213473roc_hets
rockers133916553rock_ers
rocket125425283rock_et_
rockiest142912223rockiest
rockless14297293rockless
rosets65819953ro__sets
socket123923523sock_et_
sockless14267793sockless
tackets134914363tack_ets
thicksets18263733thicksets
tickets134113683tick_ets
tuckets134810333tuck_ets
wickets164010943wick_ets
worsets105512843wo_rsets

Search took 7 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.406440125.6
2DLD Change Limit1461621246.37622923.8
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.82826170.3
 
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.