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

191 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
cockeye186722(None) 
cockeyed2096121cockeyed
cockeyes1967031cockeyes
sockeye1666411sockeye
buckeye1835682buckeye
cockade1638132cockade
cocked155022562cocke_d
cocker144320392cocke_r
cockered17710212cockered
cockerel16107112cockerel
cockers153618332cockers
cockle143913572cock_le
cockney1835872cockney_
cockneys1934492cockneys
cocky164215932cock_y_
cookey155414332cookey_
cookeys16478502cookeys
hockey184813152hockey_
hockeys19509272hockeys
jockey22408032jockey_
jockeyed2563412jockeyed
jockeys23365952jockeys
sockeyes1765762sockeyes
ackee115825373_acke_e
buckeyes1945263buckeyes
cackle143416923cack_le
cakey145517273c_akey_
chickee183111553chicke_e
chocked194411613chocke_d
chokey184811713chokey_
clocked164112833clocke_d
clocker153910873clocke_r
clockers16369813clockers
coatee84327223coate_e
cocaine111315173cocaine
coccyx1942663coc_cyx
cochleae1544643cochleae
cock126332903cock___
cockaded1836393cockaded
cockades1738433cockades
cockerels1784673cockerels
cockeyedly2551553cockeyedly
cockier154013623cockier
cockiest163013293cockiest
cockily1838493cockily
cocking163619983cocking
cockish1838503cockish
cockled163710823cockled
cockles153414643cockles
cocklike1536733cocklike
cockneyfy2651313cockneyfy
cockpit1747993cockpit
cocks135227163cock__s
cockshy2143223cockshy
cocksure1645133cocksure
cockup1635713cock_up
cockups1735223cockups
cocotte1138603cocotte
cocreate122611813cocreate
coffee144113743coffe_e
cohere112716993co_here
coke107038383co_k__e
coked124730693co_ke_d
cokes115537193co_ke_s
coky137526823co_k_y_
college102410443college
compere134616623compere
compete134716553compete
concede12310103concede
concrete12411083concrete
coney105932883co_ney_
coneys115218423co_neys
congee96024473conge_e
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
conky145818743conk_y_
convene123314323convene
convey144610223convey_
conveyed17247923conveyed
conveyer16278143conveyer
conveys15308223conveys
cooee74531023co_oe_e
cooey105828223co_oey_
cooeyed1346893co_oeyed
cooeys114914483co_oeys
cooked135921363cooke_d
cooker124722453cooke_r
cookers134619463cookers
cookery164210393cookery
cookie123716043cook_ie
cooky145321363cook_y_
corkage1438373corkage
corked135020783corke_d
corker124720853corke_r
corkers134118853corkers
corky145221153cork_y_
cortege1098953cortege
corvee114320093corve_e
cosey106226713co_sey_
coseys115215813co_seys
coulee8323513coule_e
covey136121783co_vey_
coveys145413503co_veys
cozey196718543co_zey_
cozeys204610913co_zeys
crickey18418143crickey_
crikey15317783crikey_
crocked164014433crocke_d
crockery19356603crockery
crocket154615673crocke_t
crocketed1845123crocketed
crockets16339543crockets
dickey165913523dickey_
dickeys17479303dickeys
dockage1535723dockage
docked145018333docke_d
docker134417653docke_r
dockers143715003dockers
docket134721173docke_t
docketed16156583docketed
dockets144412243dockets
donkey14449733donkey_
donkeys15426663donkeys
eocene8311613eoc_ene
goldeye1234643goldeye
hackee154921833hacke_e
hickey185011993hickey_
hickeys19508223hickeys
hocked165521303hocke_d
hocker155118563hocke_r
hockers163915913hockers
hokey155422183ho_key_
honkey165113823honkey_
honkeys17439513honkeys
hookey164713933hookey_
hookeys17448953hookeys
jockette2165033jockette
jokey195014693jo_key_
lackey154813353lackey_
lackeyed18104513lackeyed
lackeys16458263lackeys
lockage1436613lockage
locked134921663locke_d
locker124019423locke_r
lockers133516923lockers
locket123922473locke_t
lockets134612203lockets
mickey174211853mickey_
mickeys18447943mickeys
mocked154716613mocke_d
mocker143315443mocke_r
mockers153812943mockers
mockery18376913mockery
monkey153710593monkey_
monkeyed1844153monkeyed
monkeys16407423monkeys
mooneye12116933mooneye
nocked134617383nocke_d
ocker113915753_ocke_r
ockers123813903_ockers
ocreae83310273_ocreae
oxeye1536913_o_xeye
pinkeye16326493pinkeye
pocked154818983pocke_d
pocket144622623pocke_t
pocketed17147143pocketed
pocketer16157373pocketer
pockets154612253pockets
pocky165314603pock_y_
pokey145318973po_key_
pokeys15529513po_keys
rickey154613973rickey_
rickeys16548983rickeys
rockabye1942853rockabye
rocked135022323rocke_d
rocker124319573rocke_r
rockers133916553rockers
rockery16439253rockery
rocket125425283rocke_t
rocketed15157793rocketed
rocketer14158333rocketer
rockets134615363rockets
rocky144513853rock_y_
sickee124622223sicke_e
socked134721503socke_d
socket123923523socke_t
socketed15177343socketed
sockets134012983sockets
tackey154613083tackey_
yocked164114423yocke_d

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271916.73619897.1
3Display Results1911910.0762513.2
 (SQL Overall)1786911917.23224708.4
 
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.