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

199 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
lockset1331116(None) 
locket123922471lock_et
locksets1435691locksets
backset15314192backset
docket134721172dock_et
locked134921662lock_ed
locker124019422lock_er
lockets134612202lock_ets
locknut1345252locknut
lockout1359332lockout
locks115126922locks__
lockstep1643812lockstep
locust85312342locus_t
pocket144622622pock_et
rocket125425282rock_et
socket123923522sock_et
backseat1648903backseat
backsets1638853backsets
becket144619883beck_et
blackest16269303blackest
blocked16449983block_ed
blocker15419923block_er
blockier1666133blockier
blockiest1736363blockiest
blocks144513943blocks__
bocks134526573bocks__
boneset9316433boneset
booklet132312643booklet
bosket124919223bosk_et
brocket154013383brock_et
bucket144620733buck_et
clocked164112833clock_ed
clocker153910873clock_er
clocks144916233clocks__
closet85226603clo__set
cocked155022563cock_ed
cocker144320393cock_er
cockier154013623cockier
cockiest163013293cockiest
cockle143913573cockle_
cockled163710823cockled
cockles153414643cockles
cockney1835873cockney
cockpit1747993cockpit
cocks135227163cocks__
cockshut1944433cockshut
cockshy2143223cockshy
corset85636223co_rset
coset75748843__coset
cosset84125863co_sset
crocket154615673crock_et
docked145018333dock_ed
docker134417653dock_er
dockets144412243dock_ets
docks126022313docks__
flocked174510253flock_ed
flockier1745343flockier
flockiest1835643flockiest
flocks154713533flocks__
focused13166413focused
focuser12155783focuser
focuses12159653focuses
hocked165521303hock_ed
hocker155118563hock_er
hockey184813153hock_ey
hocks144925493hocks__
hocused13167013hocused
hocuses121710423hocuses
hooklet142510813hooklet
jacket194720673jack_et
jockey22408033jock_ey
jocks185118083jocks__
jocose1537103jocose_
laciest93819043laciest
lacked135324653lack_ed
lacker125325623lack_er
lackey154813353lack_ey
lacks116129203lacks__
lankest112714113lankest
licked134621563lick_ed
licker125222043lick_er
licks115325393licks__
lickspit1643913lickspit
likest104914383l_ikest
locale83915653locale_
locales93715093locales
locate83919843locate_
located103114183located
locater93113603locater
locates93218813locates
lochs106715513lochs__
lock106134363lock___
lockage1436613lockage
lockages1536723lockages
lockbox2243383lockbox
lockers133516923lockers
locking143718153locking
lockjaw2341823lockjaw
locknuts1443683locknuts
lockouts1445493lockouts
lockram1544913lockram
locksmith2053003locksmith
locksteps1743343locksteps
lockup1434763lock_up
lockups1534243lockups
locoed94312193loc_oed
locoes85516583loc_oes
locos75822603locos__
locule83412033locule_
loculed10317653loculed
locules92812603locules
locus74819993locus__
locusta9326533locusta
locusts9277933locusts
loesses7310033loesses
logiest82515543logiest
longest84114953longest
looked114717073look_ed
looker104816953look_er
lookist1139563lookist
lookout1148033lookout
looks95124863looks__
loose56627683lo_ose_
loosed75520893lo_osed
loosen66615963lo_osen
looser65219943lo_oser
looses67328243lo_oses
loosest75811563lo_osest
lorikeet1255643lorikeet
lorises73918593lorises
lose45144583lo__se_
losel54419423lo__sel
loser54728673lo__ser
loses56742013lo__ses
losses65925233lo_sses
lost47951493lo__s_t
lotoses73713643lotoses
lotuses74011253lotuses
loudest839933loudest
louse56131013lo_use_
loused74822913lo_used
louses66230283lo_uses
loveseat1145783loveseat
lowest93915593lowes_t
lowse87219903lo_wse_
lucked135118023luck_ed
luckie123611413luckie_
luckier133811533luckier
luckies133313683luckies
luckiest143011443luckiest
lucks115723563lucks__
mocked154716613mock_ed
mocker143315443mock_er
mocks135023823mocks__
moonset92413043moonset
nocked134617383nock_ed
nocks115121013nocks__
ocker113915753_ock_er
octet7324063_oc_tet
offset1238373_offset
onset54730173_o_nset
oocyst1136133oocys_t
outset64027453_outset
packet144726503pack_et
picket144924313pick_et
placket15412873plack_et
pocked154818983pock_ed
pockets154612253pock_ets
pockier153911603pockier
pockiest163412053pockiest
pocks135022963pocks__
pocosen1146833pocosen
posset84923253po_sset
quickset2345363quickset
racket125229423rack_et
rochet115423003roc_het
rocked135022323rock_ed
rocker124319573rock_er
rockets134615363rock_ets
rockier134911883rockier
rockiest142912223rockiest
rocks114626413rocks__
roset55945243ro__set
sickest131813793sickest
slackest14289403slackest
slickest14229253slickest
socked134721503sock_ed
sockets134012983sock_ets
sockmen1535453sockmen
socks114926083socks__
tacket124627493tack_et
thickset17257133thickset
ticket124524853tick_et
tucket124219483tuck_et
wackest164710863wackest
wicket155318943wick_et
worset96726583wo_rset
yocked164114423yock_ed
yocks144418373yocks__

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271997.94016880.0
3Display Results1991990.0762618.4
 (SQL Overall)1786911998.45221141.9
 
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.