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 “rocks” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

219 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
rocks11462641(None) 
bocks134526571bocks
brocks145214151brocks
cocks135227161cocks
crocks145118421crocks
docks126022311docks
frocks154111211frocks
hocks144925491hocks
jocks185118081jocks
locks115126921locks
mocks135023821mocks
nocks115121011nocks
pocks135022961pocks
racks115028851racks
recks115625131recks
ricks115126131ricks
rock105735181rock_
rocky144513851rocky
rocs65533661roc_s
rooks95325041rooks
rucks114422051rucks
socks114926081socks
trocks123614631trocks
yocks144418371yocks
backs135729622backs
becks135522012becks
blocks144513942blocks
bock126032512bock_
bonks116326462bonks
books115729712books
borks115727702borks
bosks115218852bosks
bricks144614622bricks
brock136017072brock_
brooks125813882brooks
bucks134824292bucks
chocks174815312chocks
clocks144916232clocks
cocas95926572cocas
cock126332902cock_
cocky164215932cocky
cocos95624692cocos
conks115525702conks
cooks115429142cooks
corks116028272corks
cracks144817002cracks
cricks144316052cricks
croaks125812982croaks
crock135921992crock_
crocs95722432croc_s
crocus104813172crocus
crooks124914412crooks
crucks144412582crucks
decks124822192decks
dicks125824692dicks
dock116228742dock_
docs75631152doc_s
dorks105724442dorks
drecks13459202drecks
drouks1137122drouks
ducks124823212ducks
fecks145417852fecks
flocks154713532flocks
focus105815882focus
folks126017122folks
forks125324682forks
frock145314652frock_
fucks144419252fucks
gecks125117092gecks
gooks105422882gooks
gowks136011952gowks
groks105716122gro_ks
gucks123917302gucks
hacks144928712hacks
hecks145220652hecks
hicks145322172hicks
hock136031302hock_
hocus104715202hocus
hoicks15378282hoicks
holks124720562holks
honks125124522honks
hooks125027122hooks
howks155016852howks
hucks144322172hucks
jacks185219832jacks
jock176522642jock_
jocko184210452jocko
jockos19527562jockos
jouks165612342jouks
kecks105416572kecks
kicks104420082kicks
knocks11397442knocks
konks84917112konks
kooks85217262kooks
lacks116129202lacks
licks115325392licks
lochs106715512lochs
lock106134362lock_
locos75822602locos
locus74819992locus
looks95124862looks
lucks115723562lucks
macks135127602macks
micks135525372micks
mock126429442mock_
mocs85834902moc_s
monks116123392monks
mosks116117002mosks
mucks134622642mucks
necks115119332necks
nicks114920492nicks
nock106127182nock_
nooks95420392nooks
oaks86527902_oaks
ocas66729632_ocas
orcas75918622orcas
orcs67025432orc_s
packs135528932packs
pecks135724432pecks
picks135226142picks
pock126129292pock_
pocky165314602pocky
porks115124142porks
pricks144414262pricks
pucks134322102pucks
races74943242races
rack106234882rack_
ranks95225732ranks
reck106130562reck_
recocks154711462recocks
recs65734182rec_s
redocks14409932redocks
reeks94124032reeks
relocks134411292relocks
rices75536152rices
rick107334652rick_
rinks94827102rinks
risks94917062risks
roads66523622roads
roams74919612roams
roans54926442roans
roars55622242roars
robes75133302robes
robs65837872ro_bs
roc520243252roc__
rocked135022322rocked
rocker124319572rocker
rockers133916552rockers
rocket125425282rocket
rockets134615362rockets
rodes614039082rodes
rods56442062ro_ds
roes45954142ro_es
roils54826792roils
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
romps94617542romps
roms67038962ro_ms
roods65125282roods
roofs85321152roofs
rook85532032rook_
rooky126117622rooky
rooms75324682rooms
roots55933672roots
ropes75940062ropes
roses56445772roses
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092ro_ts
roues56039352roues
roups75118902roups
routs57133412routs
roves84834482roves
rows75941752ro_ws
ruck104728332ruck_
ruckus12407792ruckus
rusks95816192rusks
sacks114228872sacks
shocks154414582shocks
sicks115127622sicks
smocks145710012smocks
soaks95220292soaks
socas74026182socas
sock105233212sock_
socko115215112socko
sooks94425452sooks
souks94820522souks
stocks124715632stocks
sucks114523072sucks
tacks115430132tacks
ticks115823292ticks
tracks124818842tracks
tricks125319012tricks
troaks104410602troaks
trock114817602trock_
trucks124711972trucks
tucks114721122tucks
voces105918052voces
wacks146626282wacks
wicks144619362wicks
woks116224902wo_ks
wonks124818342wonks
works125621902works
wracks154711112wracks
wrecks15418882wrecks
wricks154610622wricks
yacks144419812yacks
yock135924612yock_
yoicks15375932yoicks
yoks116223742yo_ks
yolks125412772yolks
yucks144717192yucks
zonks184815172zonks
zooks184716942zooks
zouks184410502zouks

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538002191.76330516.2
3Display Results2192190.0633476.2
 (SQL Overall)1786912192.12284208.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.