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

134 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
corkers13411885(None) 
cockers153618331cockers
conkers133721041conkers
cookers134619461cookers
corders104520881corders
corers85231071cor_ers
corker124720851corker_
corners94723311corners
forkers144615781forkers
porkers134314931porkers
workers144612691workers
barkers134318512barkers
bonkers134015302bonkers
bookers134016612bookers
borders104317532borders
borers85122682bor_ers
brokers133111912brokers
burkers133716622burkers
calkers134414692calkers
cankers134418752cankers
carders104820352carders
careers95218782careers
carers85133962car_ers
carpers114521252carpers
carters95327252carters
carvers124817542carvers
chokers164311522chokers
clockers16369812clockers
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
cobbers134114752cobbers
cocker144320392cocker_
codders114114452codders
coders95426982co_ders
codgers115113932codgers
coercers1237652coercers
coffers154112692coffers
coilers93619902coilers
coiners93620752coiners
cokes115537192co_ke_s
colters93522442colters
comakers16339172comakers
combers134516622combers
comers105328082co_mers
confers124120092confers
congers104223232congers
conker124721552conker_
conners94023112conners
cooers84324562co_oers
cooker124722452cooker_
cookery164210392cookery
cookeys16478502cookeys
coolers93522492coolers
coopers114019482coopers
cooters94525722cooters
copers104629842co_pers
copiers114215962copiers
coppers133519752coppers
copters113621282copters
corbels113813592corbels
corder94322882corder_
corer75538872cor_er_
cores76361852cor_e_s
corked135020782corke_d
corkier133114302corkier_
corks116028272cork__s
cormels113813372cormels
corneas94717002corneas
cornels94716662cornels
corner84625622corner_
cornets94820572cornets
coroners104016222coroners
corses84433462corse_s
corsets94819802corsets
corulers1039772corulers
corvees124613792corvees
corves115122522corve_s
corvets124715022corvets
coshers123618182coshers
costers94128332costers
cotters94323442cotters
couriers103213172couriers
coursers104412302coursers
courters103015372courters
couters93827302couters
covers114627962co_vers
cowers114625532co_wers
coworkers1854362coworkers
criers83918582c_riers
croakers14288522croakers
crowers124614902crowers
crozers184111082crozers
curbers115514382curbers
curers84923192cur_ers
curlers94218072curlers
cursers94317162cursers
dockers143715002dockers
dormers104313922dormers
dorpers104113172dorpers
dorsers83516302dorsers
forcers124215712forcers
forgers115218182forgers
forker134717902forker_
formers128217952formers
gorgers94813642gorgers
hockers163915912hockers
honkers143315232honkers
hookers144916512hookers
jerkers18287082jerkers
jokers175511192jo_kers
larkers113014512larkers
lockers133516922lockers
lookers114014072lookers
lurkers113910082lurkers
markers133516102markers
mockers153812942mockers
ockers123813902_ockers
orders74315992_orders
ormers84316142_ormers
parkers133816872parkers
pokers124617922po_kers
porker124917542porker_
porters93722702porters
rockers133916552rockers
scorers94115322scor_ers
scorners10228492scorners
soakers114114952soakers
sorners73416872sorners
sorters74221132sorters
tokers104818892to_kers
worker134715112worker_
wormers124012572wormers
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.390458182.1
2DLD Change Limit1076711343.31332499.5
3Display Results1341340.0462913.0
 (SQL Overall)1786911343.74947663.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.