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

477 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
rockets13461536(None) 
brockets16328121brockets
crockets16339541crockets
dockets144412241dockets
lockets134612201lockets
pockets154612251pockets
rackets134916871rackets
rickets134915091rickets
rochets124213471rochets
rockers133916551rockers
rocket125425281rocket_
sockets134012981sockets
beckets15399822beckets
boskets13409472boskets
brackets163310432brackets
brocket154013382brocket_
buckets153811692buckets
cockers153618332cockers
crickets16418122crickets
crochets15359832crochets
crocket154615672crocket_
dockers143715002dockers
docket134721172docket_
hockers163915912hockers
hockeys19509272hockeys
jackets205011372jackets
jockeys23365952jockeys
lockers133516922lockers
locket123922472locket_
locksets1435692locksets
mockers153812942mockers
ockers123813902_ockers
octets839402_octets
packets155114772packets
pickets154314182pickets
pocket144622622pocket_
prickets16329082prickets
rachets124516832rachets
rackers134320452rackers
racket125229422racket_
rackety16499112rackety
rickety16478312rickety
rickeys16548982rickeys
rochet115423002rochet_
rocked135022322rocke_d
rocker124319572rocke_r
rockery16439252rockery
rocketed15157792rocketed
rocketer14158332rocketer
rocketers15186882rocketers
rocketry1744502rocketry
rockiest142912222rockiest
rockless14297292rockless
rocks114626412rock__s
roquets16398942roquets
rosets65819952ro_sets
socket123923522socket_
sprockets1743252sprockets
tackets134914362tackets
tickets134113682tickets
tuckets134810332tuckets
wickets164010942wickets
ackees124914583_ackees
avocets1235453avoc_ets
backers153821883backers
backsets1638853backsets
baskets135111833baskets
becket144619883becket_
bickers154316553bickers
blockers16398793blockers
bocces123912023bocce_s
boches134618523boche_s
bocks134526573bock__s
bonkers134015303bonkers
bonnets94812803bonnets
bookers134016613bookers
booklets14247123booklets
bosket124919223bosket_
brachets154311983brachets
brackens16327923brackens
bracket154117233bracket_
briskets14346563briskets
brocks145214153brock__s
brokers133111913bro_kers
brooklets1543683brooklets
buckers153517453buckers
bucket144620733bucket_
cachets145014263cachets
caskets133910173caskets
clockers16369813clockers
cocked155022563cocke_d
cocker144320393cocke_r
cockeye1867223cockeye
cockeyes1967033cockeyes
cockiest163013293cockiest
cockles153414643cockles
cockneys1934493cockneys
cockpits1845743cockpits
cocks135227163cock__s
cockups1735223cockups
cokes115537193co_ke_s
collets93517903collets
comets105823583co_mets
conkers133721043conkers
cookers134619463cookers
cookeys16478503cookeys
coquets18399893coquets
corkers134118853corkers
cornets94820573cornets
corsets94819803corsets
corvets124715023corvets
cosets85824403co_sets
cossets95014283cossets
covets114819643co_vets
crackers164111723crackers
cricket154716953cricket_
croakers14288523croakers
crochet143616663crochet_
crocked164014433crocke_d
crockery19356603crockery
crocketed1845123crocketed
crockpots1943023crockpots
crocks145118423crock__s
crookest1436683crookest
croquets1955213croquets
crotchets16396303crotchets
crownets13407673crownets
dackers143417043dackers
deckels14367363deckels
deckers144413833deckers
dickens144410133dickens
dickers144117663dickers
dickeys17479303dickeys
docents102810803docents
docked145018333docke_d
docker134417653docke_r
docketed16156583docketed
docks126022313dock__s
donkeys15426663donkeys
droplets1136063droplets
duckers143214713duckers
facets116316653fac_ets
forgets113813793forgets
forkers144615783forkers
friskets15326263friskets
frocked17439333frocke_d
frockless1843453frockless
frocks154111213frock__s
froglets1235263froglets
fuckers163611593fuckers
gaskets12348153gaskets
gobbets12327643gobbets
goblets103210183goblets
godets8410933go_dets
goglets9379783goglets
gorgets94711783gorgets
grocers103511253groc_ers
grommets13234663grommets
hackees165014103hackees
hackers164619043hackers
hickeys19508223hickeys
hocked165521303hocke_d
hocker155118563hocke_r
hockey184813153hocke_y
hocks144925493hock__s
hoggets12498323hoggets
hokes126231643ho_ke_s
honkers143315233honkers
honkeys17439513honkeys
hookers144916513hookers
hookeys17448953hookeys
hooklets15217203hooklets
hornets104113553hornets
howlets13329223howlets
ickers123914183_ickers
jackers204214453jackers
jacket194720673jacket_
jockette2165033jockette
jockettes2254383jockettes
jockey22408033jocke_y
jockos19527563jock_os
jocks185118083jock__s
jokers175511193jo_kers
jokes165423333jo_ke_s
junkets18377623junkets
kickers124013293kickers
knockers13285733knockers
lackers134120543lackers
lackeys16458263lackeys
lickers134118253lickers
locates93218813locates
locked134921663locke_d
locker124019423locke_r
locknuts1443683locknuts
lockouts1445493lockouts
locks115126923lock__s
lockset13311163lockset_
lockups1534243lockups
locoes85516583locoe_s
locusts9277933locusts
loggets9378913loggets
lookers114014073lookers
markets133314033markets
mickeys18447943mickeys
mocked154716613mocke_d
mocker143315443mocke_r
mockery18376913mockery
mocks135023823mock__s
mockups1733343mockups
mokes114631033mo_ke_s
monkeys16407423monkeys
moppets13307163moppets
motets84216193mo_tets
muckers153612803muckers
muskets13258643muskets
neckers134210463neckers
nickels13338653nickels
nickers134415093nickers
nocked134617383nocke_d
nocks115121013nock__s
nonets64118703no_nets
objets15125323_objets
ochers113915303_ochers
ocker113915753_ocke_r
octet7324063_octet_
okehs12477463_o_kehs
okes84936343_o_ke_s
onsets64013543_onsets
oocysts1243923oocysts
oocytes1246063oocytes
owlets93110393_owlets
packers153818893packers
packet144726503packet_
peckers153312673peckers
pickers153718093pickers
picket144924313picket_
plackets1646583plackets
pocked154818983pocke_d
pocketed17147143pocketed
pocketer16157373pocketer
pocketers17196493pocketers
pockiest163412053pockiest
pocks135022963pock__s
poets76024443po__ets
pokers124617923po_kers
pokes116133013po_ke_s
pokeys15529513po_keys
poppets10338853poppets
porkers134314933porkers
possets94212773possets
prickers163710673prickers
pricket153616443pricket_
proceeds1335983proceeds
process11310403proc_ess
projets1639163pro_jets
prophets1539503prophets
propjets1935493propjets
puckers153514673puckers
rabbets11279423rabbets
racers84725433rac_ers
races74943243rac_e_s
rachet115028973rachet_
raciest92820013raciest
racists92613323racists
racked134526083racke_d
racker124824553racke_r
racketed15169123racketed
racks115028853rack__s
racquets1944763racquets
rakees104516973r_akees
rakers104123573r_akers
rakes94440353r_ake_s
ramets83517393r_amets
ramjets1635163ramjets
rankers113217463rankers
rankest112713813rankest
ratchets133110263ratchets
recants93217093recants
recasts93413533recasts
recces10614913recce_s
recepts113010263recepts
recess8314263rec_ess
recheats1339193recheats
rechews1537293rechews
recites93524583recites
recits83621353rec_its
recked134821803recke_d
reckless14257973reckless
reckons13269653reckons
recks115625133reck__s
recoats92616643recoats
recuts83817373rec_uts
reekers113613143reekers
reflets103513153reflets
reglets83512983reglets
regrets83212923regrets
rejackets2262983rejackets
rekeys13347693r_ekeys
relets64025673r_elets
remeets93712413remeets
rennets75212633rennets
resets65427613r_esets
rets45352563r___ets
revets94022173r_evets
rewets94617213r_ewets
riblets93412553riblets
ricers84120993ric_ers
rices75536153ric_e_s
richens12349733richens
riches115022083riche_s
richest122813683richest
ricked136523623ricke_d
rickey154613973ricke_y
ricks115126133rick__s
ricochets1643413ricochets
rillets74216153rillets
riskers114011993riskers
rivets94417113r_ivets
roaches123616213roache_s
roadeos837413roadeos
roamers93713463roamers
roarers73812743roarers
roasts64915413ro_asts
robbers112814163robbers
robes75133303ro_be_s
robles85321693roble_s
robots8313153ro_bots
rock105735183rock___
rockaby1843243rockaby
rockeries15128973rockeries
rocketeer15174493rocketeer
rocketeers16173593rocketeers
rocketing1666973rocketing
rocketries1645893rocketries
rockfish2043903rockfish
rockier134911883rockier
rockiness15237833rockiness
rocking143619633rocking
rockoon1345653rockoon
rockoons1445003rockoons
rockrose1444953rockrose
rockweed1843313rockweed
rockweeds1942833rockweeds
rocky144513853rock__y
rococos1145903rococos
rocs65533663roc___s
rodents8611543rodents
rodeos75314503ro_deos
rodes614039083ro_de_s
rodless8310073rodless
roes45954143ro__e_s
rogers74517913ro_gers
rogues74617673rogue_s
roles56747983ro_le_s
rolfers104011813rolfers
rollers73117473rollers
romeos84013173ro_meos
rompers113412243rompers
rondels82510053rondels
ronnels7318613ronnels
roofers105013903roofers
rooked114918143rooke_d
rookery14398313rookery
rookies113917103rookies
rookiest122912173rookiest
rooks95325043rook__s
roomers95416413roomers
roosers74217873roosers
rooses65526233roose_s
roosts64916323ro_osts
rooters74522933rooters
rootlets8308653rootlets
roots55933673ro__ots
ropers84325903ro_pers
ropes75940063ro_pe_s
ropiest93317773ropiest
roques154912563roque_s
roquet154415893roquet_
roscoes9310923roscoe_s
roses56445773ro_se_s
roset55945243ro_set_
rosiest73919213rosiest
rosters73727543rosters
rotates72819773rotates
rotches123515703rotche_s
rotes56143903ro_te_s
rotguts833763rotguts
rots46454093ro___ts
rotters74421393rotters
rottes64524833rotte_s
rouches124217893rouche_s
rouens64814443ro_uens
roues56039353ro_ue_s
rouges76022383rouge_s
roupet84218343roupet_
rousers75220143rousers
rouses65436283rouse_s
rousts617016723ro_usts
routers74822873routers
routes66129313route_s
routs57133413ro__uts
rovers95423523ro_vers
roves84834483ro_ve_s
rowels94515453ro_wels
rowens94515303ro_wens
rowers94924573ro_wers
rozzers1535633rozzers
ruches114819583ruche_s
rucked134718763rucke_d
ruckles133414603ruckles
rucks114422053ruck__s
ruckus12407793ruck_us
runlets73310773runlets
russets738163russets
rykes125513033r_yke_s
sachets123914103sachets
sackers133820223sackers
secrets9311773secrets
shockers17319463shockers
sickees134514213sickees
sickens134411483sickens
sickest131813793sickest
skyrockets1851443skyrockets
soakers114114953soakers
soccers1138393soccers
society1236083society
socked134721503socke_d
socketed15177343socketed
sockeye1666413sockeye
sockeyes1765763sockeyes
sockless14267793sockless
socks114926083sock__s
socles8418453socle_s
sokes95031423so_ke_s
sonnets74211993sonnets
sorbets93012513sorbets
soviets1087293soviets
sprocket1646773sprocket_
stockers143411073stockers
suckers133717623suckers
sunkets113511283sunkets
tackers134319623tackers
tacket124627493tacket_
thickets17287083thickets
tickers133617723tickers
ticket124524853ticket_
tochers123413093tochers
toilets74112913toilets
tokens104711563to_kens
tokers104818893to_kers
tokes95234973to_ke_s
tonlets73212503tonlets
toquets16367863toquets
trackers143512853trackers
trickers143812813trickers
trinkets1237143trinkets
trochees132510183trochees
troches123715343troche_s
trocked144312243trocke_d
trocks123614633trock__s
trokes104019263tro_ke_s
truckers14279013truckers
tuckers134014353tuckers
tucket124219483tucket_
voces105918053voc_e_s
wackes154717713wacke_s
wackest164710863wackest
wickers164114703wickers
wicket155318943wicket_
workers144612693workers
worsets105512843worsets
wreckers17315973wreckers
yocked164114423yocke_d
yocks144418373yock__s
yokels13488063yo_kels
yokes125223023yo_ke_s
yonkers14379823yonkers

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 Filter1786911340270.423422437.4
2DLD Change Limit1340274775.93622578.7
3Display Results4774770.1702805.9
 (SQL Overall)1786914776.52927368.8
 
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.