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

126 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
rockers13391655(None) 
cockers153618331cockers
dockers143715001dockers
hockers163915911hockers
lockers133516921lockers
mockers153812941mockers
ockers123813901_ockers
rackers134320451rackers
rocker124319571rocker_
rockery16439251rockery
rockets134615361rockets
backers153821892backers
bickers154316552bickers
blockers16398792blockers
bonkers134015302bonkers
bookers134016612bookers
brockets16328122brockets
brokers133111912bro_kers
buckers153517452buckers
clockers16369812clockers
cocker144320392cocker_
conkers133721042conkers
cookers134619462cookers
corkers134118852corkers
crackers164111722crackers
croakers14288522croakers
crockery19356602crockery
crockets16339542crockets
dackers143417042dackers
deckers144413832deckers
dickers144117662dickers
docker134417652docker_
dockets144412242dockets
duckers143214712duckers
forkers144615782forkers
fuckers163611592fuckers
grocers103511252groc_ers
hackers164619042hackers
hocker155118562hocker_
hockeys19509272hockeys
honkers143315232honkers
hookers144916522hookers
ickers123914182_ickers
jackers204214452jackers
jockeys23365952jockeys
jokers175511192jo_kers
kickers124013292kickers
knockers13285732knockers
lackers134120542lackers
lickers134118252lickers
locker124019422locker_
lockets134612202lockets
lookers114014072lookers
mocker143315442mocker_
mockery18376912mockery
muckers153612802muckers
neckers134210462neckers
nickers134415092nickers
ochers113915302_ochers
ocker113915752_ocker_
packers153818892packers
peckers153312672peckers
pickers153718092pickers
pockets154612252pockets
pokers124617922po_kers
porkers134314932porkers
prickers163710672prickers
puckers153514672puckers
racers84725432rac_ers
racker124824552racker_
rackets134916872rackets
rakers104123572r_akers
rankers113217462rankers
reekers113613142reekers
ricers84120992ric_ers
rickets134915092rickets
rickeys16548982rickeys
riskers114011992riskers
roamers93713462roamers
roarers73812742roarers
robbers112814162robbers
rochets124213472rochets
rocked135022322rocke_d
rockeries15128972rockeries
rocket125425282rocke_t
rocketers15186882rocketers
rocketry1744502rocketry
rockier134911882rockier_
rockless14297292rockless
rocks114626412rock__s
rogers74517912ro_gers
rolfers104011812rolfers
rollers73117472rollers
rompers113412242rompers
roofers105013902roofers
rookery14398312rookery
roomers95416412roomers
roosers74217882roosers
rooters74522932rooters
ropers84325902ro_pers
rosters73727552rosters
rotters74421392rotters
rousers75220142rousers
routers74822872routers
rovers95423522ro_vers
rowers94924572ro_wers
rozzers1535632rozzers
sackers133820222sackers
shockers17319462shockers
soakers114114952soakers
soccers1138392soccers
sockets134012982sockets
stockers143411072stockers
suckers133717622suckers
tackers134319622tackers
tickers133617722tickers
tochers123413092tochers
tokers104818892to_kers
trackers143512852trackers
trickers143812812trickers
truckers14279012truckers
tuckers134014352tuckers
wickers164114702wickers
workers144612692workers
wreckers17315972wreckers
yonkers14379822yonkers

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711262.95336461.6
3Display Results1261260.0462739.1
 (SQL Overall)1786911263.37252992.6
 
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.