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

130 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
cockeyes196703(None) 
cockeye1867221cockeye_
cockeyed2096121cockeyed
sockeyes1765761sockeyes
buckeyes1945262buckeyes
cockades1738432cockades
cockered17710212cockered
cockerel16107112cockerel
cockerels1784672cockerels
cockers153618332cocke_rs
cockles153414642cock_les
cockneys1934492cockney_s
cookeys16478502cookey_s
hockeys19509272hockey_s
jockeyed2563412jockeyed
jockeys23365952jockey_s
sockeye1666412sockeye_
ackees124914583_acke_es
buckeye1835683buckeye_
cackles153717203cack_les
chickees19258513chicke_es
clockers16369813clocke_rs
coatees93816553coate_es
cocaines121314443cocaines
coccyges1542333coccyges
coccyxes2142013coccyxes
cockade1638133cockade_
cockaded1836393cockaded
cocked155022563cock__ed
cocker144320393cock__er
cockeyedly2551553cockeyedly
cockier154013623cock_ier
cockiest163013293cock_iest
cockiness17248783cockiness
cockle143913573cock_le_
cockled163710823cock_led
cockney1835873cock_ney
cockneyfies2551293cockneyfies
cockneyfy2651313cockneyfy
cockneyish2451403cockneyish
cockneyism2351663cockneyism
cockpits1845743cockpits
cocks135227163cock___s
cockshies2045173cockshies
cockups1735223cock_ups
cocky164215933cock_y__
cocottes1238303cocottes
cocreates132611883cocreates
coffees15329573coffe_es
coheres122917693co_heres
cokes115537193co_k__es
colleges112410523colleges
comperes143217973comperes
competes144117243competes
concedes13311063concedes
concretes13411473concretes
coneys115218423co_ney_s
congees103517923conge_es
conkers133721043conke_rs
convenes132916913convenes
convexes20278273convexes
conveyed17247923conveyed
conveyer16278143conveyer
conveyers17267203conveyers
conveys15308223convey_s
cooees85621893co_oe_es
cooeyed1346893co_oeyed
cooeys114914483co_oey_s
cookeries151210633cookeries
cookers134619463cooke_rs
cookey155414333cookey__
cookies133719273cook_ies
corkages1539103corkages
corkers134118853corke_rs
corteges1198823corteges
cortexes1797613cortexes
corvees124613793corve_es
coseys115215813co_sey_s
coulees9315513coule_es
coveys145413503co_vey_s
cozeys204610913co_zey_s
crockeries1857113crockeries
crocketed1845123crocketed
crockets16339543crocke_ts
dickeys17479303dickey_s
dockages1635983dockages
dockers143715003docke_rs
docketed16156583docketed
dockets144412243docke_ts
donkeys15426663donkey_s
goldeyes1344483goldeyes
hackees165014103hacke_es
hickeys19508223hickey_s
hockers163915913hocke_rs
hockey184813153hockey__
honkeys17439513honkey_s
hookeys17448953hookey_s
jockettes2254383jockettes
jockey22408033jockey__
jockeyish2841843jockeyish
lackeyed18104513lackeyed
lackeys16458263lackey_s
lockages1536723lockages
lockers133516923locke_rs
lockets134612203locke_ts
mickeys18447943mickey_s
mockeries17128263mockeries
mockers153812943mocke_rs
monkeyed1844153monkeyed
monkeys16407423monkey_s
mooneyes1396113mooneyes
ockers123813903_ocke_rs
oxeyes1635893_o_xeyes
pinkeyes17335973pinkeyes
pocketed17147143pocketed
pocketer16157373pocketer
pocketers17196493pocketers
pockets154612253pocke_ts
pokeys15529513po_key_s
rickeys16548983rickey_s
rockabyes2042493rockabyes
rockeries15128973rockeries
rockers133916553rocke_rs
rocketed15157793rocketed
rocketer14158333rocketer
rocketers15186883rocketers
rockets134615363rocke_ts
sickees134514213sicke_es
socketed15177343socketed
sockets134012983socke_ts

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.423422437.4
2DLD Change Limit1461621306.95321021.4
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.42224075.9
 
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.