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

123 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
cockneys193449(None) 
cockney1835871cockney_
cockers153618332cock_ers
cockeye1867222cock_eye
cockeyes1967032cock_eyes
cockiness17248782cockiness
cockles153414642cockle_s
cockneyfy2651312cockneyfy
cockneyish2451402cockneyish
cockneyism2351662cockneyism
coneys115218422co__neys
cookeys16478502cook_eys
hackneys2033682hackneys
hockeys19509272hock_eys
jockeys23365952jock_eys
boloneys1334503boloneys
cacklers163710703cacklers
cackles153717203cackle_s
carneys124310543c_arneys
chimneys1883643chimneys
chutneys1642323chutneys
clockers16369813clock_ers
cocaines121314443cocaine_s
cochleas1545273cochleas
cocinera1245553cocinera
cocineras1344963cocineras
cockades1738433cockades
cocked155022563cock_e_d
cocker144320393cock_e_r
cockerels1784673cockerels
cockeyed2096123cock_eyed
cockier154013623cockie_r
cockiest163013293cockiest
cockily1838493cockily_
cockle143913573cockle__
cockled163710823cockle_d
cockneyfies2551293cockneyfies
cockneyisms2451313cockneyisms
cockpits1845743cockpits
cocks135227163cock___s
cockshy2143223cockshy_
cockups1735223cock_ups
cocky164215933cock__y_
coconuts1246333coconuts
cohunes1249713cohune_s
coignes103912153coigne_s
coiners93620753co_iners
cojones163512103cojone_s
cokes115537193co_k_e_s
coldness1137953coldness
colonels104210453colonels
colones96124433colone_s
comfreys1843333comfreys
cones76457423co__ne_s
coney105932883co__ney_
conines93827793conine_s
conkers133721043conk_ers
conners94023113co_nners
conveys15308223co_nveys
cooeys114914483co__oeys
cookers134619463cook_ers
cookey155414333cook_ey_
cookies133719273cookie_s
cookless14258633cookless
coolness1037743coolness
corkers134118853cork_ers
corkiness152810443corkiness
corneas94717003co_rneas
cornels94716663co_rnels
corners94723313co_rners
cornets94820573co_rnets
coronels104012143coronels
coroners104016223coroners
coronets103814363coronets
coseys115215813co__seys
cosines94122673cosine_s
cosiness103214283cosiness
coveys145413503co__veys
coyness1277323co_yness
cozeners19297783cozeners
cozeys204610913co__zeys
coziness19319823coziness
cracknels1743433cracknels
crockets16339543crock_ets
dickeys17479303dick_eys
dockers143715003dock_ers
dockets144412243dock_ets
donkeys15426663donk_eys
gooneys11407073go_oneys
hackney1935123hackney_
hickeys19508223hick_eys
hockers163915913hock_ers
hockey184813153hock_ey_
honeys124016083ho__neys
honkeys17439513honk_eys
hookeys17448953hook_eys
jockey22408033jock_ey_
journeys1843203journeys
lackeys16458263lack_eys
lockers133516923lock_ers
lockets134612203lock_ets
locknuts1443683locknuts
locksets1435693locksets
looneys10487013lo_oneys
mickeys18447943mick_eys
mockers153812943mock_ers
moneys115513623mo__neys
monkeys16407423monk_eys
ockers123813903_ock_ers
packness1636933packness
pockets154612253pock_ets
pokeys15529513po_k_eys
rickeys16548983rick_eys
rockers133916553rock_ers
rockets134615363rock_ets
rockiness15237833rockiness
rockless14297293rockless
sickness1437833sickness
sockets134012983sock_ets
sockeye1666413sock_eye
sockeyes1765763sock_eyes
sockless14267793sockless
tourneys1134013tourneys

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621236.72021750.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.18624866.5
 
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.