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

246 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
cockered1771021(None) 
cockerel16107111cockerel
cockeyed2096121cockeyed
bickered17108002bickered
cankered153010222cankered
checkered2144682checkered
cockaded1836392cockaded
cocked155022562cock__ed
cocker144320392cocker__
cockerels1784672cockerels
cockers153618332cocker_s
cockeye1867222cockeye_
cockeyes1967032cockeyes
cockled163710822cock_led
coffered1737672coffered
cohered133514692co_hered
compered153414922compered
coopered133310932coopered
coppered153410542coppered
cornered11311132cornered
coshered14610292coshered
cottered112511732cottered
covered133315292co_vered
cowered133214652co_wered
crocketed1845122crocketed
dackered16116892dackered
dickered16117532dickered
docketed16156582docketed
jockeyed2563412jockeyed
lackered15108682lackered
nickered15117022nickered
ochered132610282_ochered
pocketed17147142pocketed
puckered1736102puckered
rocketed15157792rocketed
socketed15177342socketed
suckered1537832suckered
tochered1437912tochered
tuckered1535962tuckered
bickerer16106773bickerer
bordered1248933bordered
bothered142110393bothered
bowered133113043bo_wered
brokered1536083brokered
bucketed1736763bucketed
bucklered1844543bucklered
bunkered15177183bunkered
cacheted16148233cacheted
cackled164613303cack_led
cambered15129003cambered
cancered132411553cancered
cantered113415983cantered
capered123014043c_apered
careered1139493careered
casketed1534953casketed
catered103117773c_atered
centered112513523centered
cered85227443__c_ered
cheered133713293c_heered
chickened2144623chickened
chocked194411613chock__ed
choppered1964883choppered
chowdered1944013chowdered
cindered1239793cindered
ciphered1637053ciphered
clavered14187633clavered
clinkered1634773clinkered
clobbered16164103clobbered
clocked164112833clock__ed
clocker153910873clocker__
clockers16369813clocker_s
clovered14187363clovered
cochaired1743883cochaired
cockade1638133cockade_
cockades1738433cockades
cockcrow1842753cockcrow
cockering1839693cockering
cockeyedly2551553cockeyedly
cockier154013623cock_ier
cockle143913573cock_le_
cockles153414643cock_les
cockney1835873cock_ney
cocksure1645133cocksure_
cocooned1337293cocooned
cocreated142710093cocreated
coerced1238583co__erced
coexerted1944763coexerted
cohere112716993co_here_
coherer122912783co_herer
coheres122917693co_heres
coinhered1536593coinhered
coked124730693co_k__ed
cokehead1845063co_kehead
collared113211143collared
colleted113011663colleted
colored10313473co_lored
coloured1148313coloured
commerced18125463commerced
compared153811823compared
compeered1646303compeered
compere134616623compere_
comperes143217973comperes
competed154113593competed
conceded1438293conceded
concerned1438643concerned
concerted14312113concerted
concreted1439413concreted
concurred1445673concurred
conferee13613733conferee
conferred1537753conferred
congeed113212313conge_ed
conjured18117903conjured
conked135019113conk__ed
conker124721553conker__
conkers133721043conker_s
conquered2145463conquered
conserved1538853conserved
convened143412223convened
converged1636973converged
conversed1538683conversed
converted15311563converted
conveyed17247923conveyed
cooeed95917863co_oe_ed
cooeyed1346893co_oeyed
cooked135921363cook__ed
cooker124722453cooker__
cookeries151210633cookeries
cookers134619463cooker_s
cookery164210393cooker_y
corbeled1338373corbeled
cored85044223co___red
corked135020783cork__ed
corker124720853corker__
corkers134118853corker_s
corseted11311473corseted
cosseted1178343cosseted
countered12313003countered
coverer123113523co_verer
coveted133011523co_veted
cowherd1636953cowher_d
cozened19349183co_zened
cratered1149683cratered
cricketed1854683cricketed
crocheted1745313crocheted
crocked164014433crock__ed
crockeries1857113crockeries
crockery19356603crocker_y
cuckooed1743303cuckooed
cumbered15157963cumbered
cyphered1934653cyphered
daikered1495223daikered
docked145018333dock__ed
docker134417653docker__
dockers143715003docker_s
doctored1245623doctored
doddered1234943doddered
donnered10307753donnered
dormered1255673dormered
dowered122811553do_wered
flickered1943753flickered
foddered1434553foddered
fostered122210453fostered
goffered1634523goffered
hankered16289443hankered
hocked165521303hock__ed
hocker155118563hocker__
hockers163915913hocker_s
hollered1237603hollered
homered133212713ho_mered
hoovered15195413hoovered
hovered143411573ho_vered
hunkered16186923hunkered
jacketed22146533jacketed
knackered1543683knackered
koshered1636063koshered
lackeyed18104513lackeyed
lechered1437523lechered
locked134921663lock__ed
locker124019423locker__
lockers133516923locker_s
loitered938183loitered
loppered13326753loppered
louvered1244993louvered
lowered112711913lo_wered
mackerel1644863mackerel
mocked154716613mock__ed
mocker143315443mocker__
mockeries17128263mockeries
mockers153812943mocker_s
mockery18376913mocker_y
moldered1237173moldered
mongered1238953mongered
monkeyed1844153monkeyed
mothered142310103mothered
nickeled15115513nickeled
nocked134617383nock__ed
occurred1343483occurred
ochred12328003_oc_hred
ocker113915753_ocker__
ockers123813903_ocker_s
offered1436143_offered
ordered9108533_ordered
osiered837123_osiered
overed102216623_o_vered
packeted17148283packeted
pickeered1843463pickeered
pickerel1645273pickerel
picketed17167383picketed
pocked154818983pock__ed
pocketer16157373pocketer
pondered126411293pondered
portered112311543portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643po_wered
puckerer1645793puckerer
racketed15169123racketed
rocked135022323rock__ed
rocker124319573rocker__
rockeries15128973rockeries
rockers133916553rocker_s
rockery16439253rocker_y
rocketer14158333rocketer
rockweed1843313rockweed
rogered939553ro_gered
scowdered1643743scowdered
shickered19115723shickered
sickened1546783sickened
snickered16115343snickered
snookered1443263snookered
sobered102912433so_bered
socked134721503sock__ed
sockeye1666413sockeye_
sockeyes1765763sockeyes
soldered1038153soldered
ticketed15146643ticketed
tinkered1387683tinkered
tokened1236393to_kened
tottered9208703tottered
towered112911403to_wered
ulcered1037973ulc_ered
vouchered1843853vouchered
whickered22114033whickered
wondered13239943wondered
yocked164114423yock__ed

Search took 9 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.406440125.6
2DLD Change Limit1461622467.58019282.6
3Display Results2462460.0932645.2
 (SQL Overall)1786912468.07922118.0
 
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.